Questions tagged [odbc]

In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).

Filter by
Sorted by
Tagged with
0 votes
0 answers
3 views

Why won't this config use DECLARE / FETCH on Amazon Redshift?

In my home directory I have created: .odbcinst.ini [ODBC Drivers] Amazon Redshift (x64)=Installed [Amazon Redshift (x64)] Description=Amazon Redshift ODBC Driver(64-bit) Driver=/opt/amazon/...
user avatar
0 votes
0 answers
15 views

Using ODBC drivers to connect to Postgres database via Powershell

I've routinely connected to a postgres database via ODBC using a powershell script. Like this.... $DBConnectionString = "Driver={PostgreSQL Unicode(x64)};Server=$MyServer;Port=$MyPort;Database=$...
user avatar
0 votes
1 answer
34 views

error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified when import excel data to sql server

I work on SQL server 2017 I need to import data from excel 2016 to sql server 2017 I using python script to do that I create odbc and success test with name Testserver path G:\ImportExportExcel have ...
user avatar
0 votes
0 answers
41 views

How do I configure DB2 on Windows with SSL so that I can connect via ODBC?

DB2 11.5 running on Windows Server 2016 Standard SQL Server 14.0.3430.2 I'm able to set up ODBC with some DB2 databases, but when the DB2 database is secured with an SSL certificate, which they call ...
user avatar
0 votes
0 answers
41 views

Can't use ODBC to connect to MariaDB

Linux Mint 20 (Ubuntu 20). MariaDB version: "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" LibreOffice 6.4.7.2. I want to run LibreOffice Base ...
user avatar
0 votes
1 answer
56 views

Open SQL Server data in QGIS on Ubuntu

I am trying to connect to a SQL Server (MSSQL) database from QGIS on Ubuntu. As per the following link, I have created an odbc.ini file and the driver as per - https://docs.microsoft.com/en-us/sql/...
user avatar
  • 105
2 votes
1 answer
110 views

How to avoid returning partial data from SQL Server in .NET application?

We got ticket from client which is reporting that sometimes get partial data from query. In simple word query is a query on view: SELECT column1, column2, column3, column4, column5, column6 ... ...
user avatar
  • 307
1 vote
1 answer
120 views

After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values [closed]

I had a total meltdown after installing "Feature update to Windows 10, version 21H2". A month into this I am now suspect that somehow this update reconfigured the way user System is handled. ...
user avatar
  • 133
0 votes
0 answers
31 views

Issues connecting to postgresql DB using SSIS ODBC connector

I have an odd issue with ODBC connector: I built a very simple ssis package to read data from a Postgresql DB and then load the data into a sql server DB. To connect to the postgresql DB, i used ODBC ...
user avatar
  • 23
1 vote
0 answers
81 views

Polybase converts getdate() to the wrong format

We have two SQL Servers (both running Enterprise version on 15.0.4083.2) where we use queries to External tables via Polybase from one server to the other. We have encountered a strange error when we ...
user avatar
  • 563
0 votes
1 answer
128 views

SQL Server 2019 Polybase error - cant create External table

I am trying to setup an external data source in SQL Server 2019 to another database on the same server. I am doing this to create external table I tried the following to set it up I installed SQL ...
user avatar
1 vote
3 answers
51 views

SQL Server driver installed with OS

Does the "SQL Server" driver that gets installed with the OS get updated via windows updates? This is the driver that can be select when defining a DSN via ODBC Data Source Administration or ...
user avatar
  • 21
0 votes
1 answer
31 views

Postgresql current_timestamp and ODBC Conection pooling [closed]

Current_timestamp returns the time of the beginning of the transaction, which is the time of the end of the previous transaction. But what happens for connection pooling? The commit may have happened ...
user avatar
  • 143
0 votes
0 answers
160 views

Possible memory leak of cx_Oracle/pyodbc/Oracle Instant Client?

Let me first list all the relevant information... Oracle database Version 19.4.0.0.0 Oracle instantclient version: 21.3.0.0.0 OS version: RHEL 7.9 x64 cx_Oracle version: 8.2 pyodbc version: 4.0.32 ...
user avatar
-1 votes
1 answer
389 views

ODBC connection fails when running with SQL Server Agent

I've changed an SSIS package to use a 64-bit ODBC connection instead of 32-bit. After deployment it works fine when executing the package but when running a SQL Server Agent job with the package it ...
user avatar
0 votes
0 answers
27 views

Encrypted ODBC driver fails when job is scheduled in SQL Server Agent

I have installed an ODBC driver (system DSN) on a SQL server to connect to an external database. It uses SSL encryption. In SSMS I am able to query it using a linked server and openquery(). In C# ...
user avatar
0 votes
0 answers
41 views

Using Powershell and ODBC connection to Postgresql, how can I catch the Notices from a call procedure?

I have a procedure that will raise some output. call my_procedure(param1, param2); table "temp_ts" does not exist, skipping INFO: No BR has been applied. INFO: Params are valid. Code ...
user avatar
0 votes
2 answers
52 views

Left Outer Join possible? [closed]

i have a problem which needs to get resolved and i hope some of you can help. i have an article table (Table A) Article Description A43234 desk A42323 paper A43235 chair and a ...
user avatar
1 vote
0 answers
1k views

SQL connection error in python webapp: "pandas.io.sql.DatabaseError: Execution failed on sql"

I have built a Webapp with python flask, that reads and writes to SQL tables. Typically in the morning, I receive an error regarding SQL query execution that looks like this (see logs snippet below). ...
user avatar
  • 11
0 votes
0 answers
132 views

ODBC source SQL Server unable to connect to local Sql express 2019

On My Win10 I'm trying to connect to my local Sql Server Express via ODBC. I must the ODBC driver "SQL Server". I create the connection via ODBC sources. I Receive an error prompt. I've ...
user avatar
0 votes
1 answer
153 views

ODBC Calling Fill - Unexpected closed connection after 2 hours

Using PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit I use driver PostgresSQL Unicode(x64) version 13.00.00.00 I have ...
user avatar
0 votes
0 answers
225 views

Postgres: ODBC: ERROR: SSL connection has been closed unexpectedly; Error while executing the query

I'm currently in Australia and so is the database. Staff attempting to connect to the database from overseas (USA, UK) consistently run into the error: ERROR: SSL connection has been closed ...
user avatar
  • 1
0 votes
0 answers
100 views

Sql Server ODBC Linked Server

I'm trying to create a linked server in SQL server 2017, linked system is odbc (criteria criOdbc) Test 1 Form SQL Server SSMS select * from OPENROWSET('MSDASQL','DSN=criteria64;uid=xxxx;pwd=yyyy;','...
user avatar
  • 143
1 vote
1 answer
63 views

What is MS Access ODBC SQL syntax for a table with AutoIncrement and Memo columns?

I am migrating a full framework .NET app to core. It used ADOX to create an MS Access database and tables. It used OLE DB to populate data. In ADOX, the data type was ADOX.DataTypeEnum.adInteger and ...
user avatar
0 votes
0 answers
45 views

Remote connection to a dBase database living on a private server

So I have to work with legacy code, built on dBase. The dBase app is currently used on desktop through a bunch of UI forms. This will still be the case, but added functionalities are needed. This code ...
user avatar
1 vote
1 answer
50 views

Need help with ODB Database over VPN [closed]

I use an ODB SQL Database for electronic components. The Database comes from Omnify which a PLM system that is used to store all the electronic components that we use. The database is accessed using ...
user avatar
  • 11
0 votes
0 answers
562 views

How can I call a SQL Server stored procedure from Oracle and retrieve a scalar return value?

I'm developing a PL/SQL solution in Oracle Database Enterprise Edition 12.1.0.2. I'm calling stored procedures in Microsoft SQL Server 2014. I am using DG4ODBC with the DBMS_HS_PASSTHROUGH package to ...
user avatar
  • 603
0 votes
1 answer
100 views

How to select Data from ODBC Source in MySQL

I try to select data from MSSQL in MySQL over straight way. I want to store the result in a view. What did I do now: Add the MSSQL Server as a ODBC Datasource.
user avatar
0 votes
0 answers
164 views

ODBC convert postgres citext column in SQL Server linked server

I am trying to connect a PostgreSQL to SQL Server server as a linked server. On the SQL Server, I have installed the ODBC driver for PostgreSQL (psqlodbc_09_02_0100-x64). I created a system DSN to a ...
user avatar
  • 1
0 votes
1 answer
126 views

What is an ODBK file and how to restore that?

I have recently come across a situation where I am required to restore an ODBK file. Basically this is a database file of Intergy Server (An EHR platform). I don't know how to restore that file into a ...
user avatar
0 votes
1 answer
36 views

Speeding up linking Oracle tables in Microsoft Access

Many people in my office use Oracle tables by linking them in Access (either 2010 or 2016) databases. They always complain about the fact that, when Access is about to present them the list of tables ...
user avatar
  • 1
1 vote
1 answer
160 views

MS Access linked table displays short text instead of Decimal data type

I have linked tables in MS Access databases (various versions, 2007-2019) which are connected to SQL server 2017 via Sql server 2017 drivers (eg, msodbcsql_17.2.0.1_x64). Fields that are of data type ...
user avatar
  • 111
0 votes
0 answers
16 views

Accessing Vertica Database via a shareable file DSN on Excel

I am trying to connect to a Vertica database (Vertica driver=7.02.03) on our server. I have created a .dsn file using the FILE DSN tab on ODBC Data Source Administration (64 bit). However, when I ...
user avatar
0 votes
1 answer
35 views

How to create a new user in a remote offline database without elevating roles [closed]

An enterprise C++ system that needs to be "translated", uses ODBC for connecting to SQL Server Database. The system has one central main database, many distributed local databases, which are actually ...
user avatar
  • 13
0 votes
0 answers
656 views

ODBC in Access working but not in SQL Server

I have a postgres database running on a remote server. I'd like to be able to query it in SQL Server. I downloaded the ODBC Driver for postgres and created a system DSN which successfully runs a ...
user avatar
  • 1
0 votes
1 answer
48 views

Remote connection scheme without Windows Authentication/Domain in detail [closed]

There is a legacy C++ system that needs to be "translated", that uses ODBC for connecting to remote SQL Server Database. System is distributed to many different OS and different domains, some always ...
user avatar
  • 13
2 votes
1 answer
166 views

Incompatibility between unixODBC and Firebird ODBC driver

I'm currently developing a application based in Rcode, ODBC and Firebird. For that, first I've installed firebird server and unixODBC (both 64 bits since my machine OS is 64-bits). I tried with 32-...
user avatar
  • 63
7 votes
1 answer
5k views

Does SSMS use ODBC?

I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances. I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes ...
user avatar
2 votes
1 answer
409 views

SQL Server 2012 Agent hangs at a particular time of the day [closed]

There is a 3 node SQL Server Failover Cluster with 3 instances running on same node at the moment. SQL Server version is 2012 with SP3. At a particular time of the day at 4 PM daily, SQL Agent hangs ...
user avatar
  • 357
2 votes
0 answers
363 views

ODBC Driver Manager Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303) - Windows Server 2012 R2

I have a problem with adding MySQL server via linked server to my SQL Server Database Following this instruction unfortunately just does not work out for me. I added four data sources, 2 using 64-...
user avatar
  • 21
2 votes
1 answer
768 views

Old ODBC app throws "cannot generate sspi context" on Windows 10

An old Access 2003 .adp project is currently running on Windows 7 machines, while SQL Server 2008 is on the backend. Since the app is moved to a Windows 10 machine, the app will trigger "Cannot ...
user avatar
  • 135
1 vote
0 answers
120 views

ORA-02063 Encoding problem with Oracle querying SQL Server through ODBC link

We have a problem querying some data from the SQL Server from the Oracle database with the ORA-LNX connecting to SQL-SRV using ODBC and Heterogeneous Service (Oracle HS). When we send the query ...
user avatar
  • 111
0 votes
1 answer
146 views

ODBC connection with RD Gateway [closed]

here at my company, we use an RD Gateway server. that means when we want to access a server we have to set up the gateway in the connection...something like rdsgw.mycompany.com But, how could I do an ...
user avatar
1 vote
0 answers
48 views

ODBC connects but authentication fails on users table

We have sql 2008 running in mixed mode. The site where sql is running the ODBC connection works and ms access authenticates against the user table. We have an IPSec vpn to a satellite office using ...
user avatar
3 votes
1 answer
3k views

How to get Oracle_Home directory?

I'm not asking "where is my home directory", or "how do I find it". I am pretty sure I don't have an Oracle_Home directory and I want one. What is the minimum software package that I should install to ...
user avatar
0 votes
0 answers
3k views

Unable to open BCP host data-file

Having an issue with exporting files to a network drive via the BCP host data file. There is no problem in exporting a file to the C drive of the machine that the SQL Server is installed on, however ...
user avatar
1 vote
0 answers
534 views

SSIS: Error from ODBC provider when inserting into Always Encrypted table using CMK in Azure Key Store

I'm trying to use SSIS (Visual Studio 2017) to insert data into an Azure SQL table with a column that's encrypted via Always Encrypted, and a column master key stored in Azure Key Vault, but I keep ...
user avatar
0 votes
1 answer
2k views

How can I setup and use a PostgreSQL database without installing a driver?

I have a portable PostgreSQL database that runs perfectly on my computer as a database server. This is a work computer that I use for a lot of work in Excel with non-sensitive data (that is, data that ...
user avatar
1 vote
1 answer
5k views

ODBC Error for Oracle Client 12.2.0.1

I installed Oracle Client 12.2.0.1 (x32) on a Win7 x64 machine. When I tried to create an ODBC by invoking "C:\Windows\SysWOW64\odbcad32.exe" and picking the "Oracle Client" from ...
user avatar
  • 147
1 vote
1 answer
534 views

How can I check a version of installed ODBC MariaDB connector?

Several months ago I built MariaDB Connector/ODBC from Source following official instructions: git clone https://github.com/MariaDB/mariadb-connector-odbc.git cd mariadb-connector-odbc cmake -...
user avatar
  • 113

1
2 3 4 5