Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
19 views

SQL Server is returning incorrect output for NON ASCII characters

I need to migrate a table data from SQL Server to PostgreSQL. I have found the result for my query is returning incorrect output. I am expecting output as UTF-8/UTF-16 encoded string from SQL Server....
2
votes
2answers
209 views

How do I use 'N' in my prepared SELECT statement

I'm connecting to an SQL Server 2008 database using pdo and the ODBC Driver 13 for SQL Server. I'm trying to run the following query which searches the database for Chinese characters: SELECT TOP (...
0
votes
0answers
11 views

Unable to select the table result in linked Server

As I have successfully created the Linked Server in SQL Server 2012 SP4 with MYSQL Server. Some of the small tables record able to fetch from the MySQL Server. And some of the big tables records when ...
1
vote
1answer
25 views

System DSN for SQL Server to connect through ODBC with for a specific port

Earlier we were using default port number on the SQL Server and import of registry was working fine when configuring the clients to connect through ODBC. Recently we moved to new server where the SQL ...
1
vote
1answer
48 views

MS SQL 2017 Batch insert performance degradation

This one's a bit strange so bear with me: I'm seeing extreme insert performance degradation after an insert was interrupted in a dirty fashion (the transaction was not committed and the connection ...
0
votes
1answer
47 views

Data Source connects but linked server cannot initialize data source object in MS SQL Server

I'm trying to create a linked server to an instance of MySQL. I've created a System DSN to the instance and that passes the connection test, but when I try to create a linked server using that data ...
1
vote
0answers
11 views

Teradata Install 32bit appears to have failed

I'm getting the error "The installation of ODBC -32bit appears to have failed. Do you want to continue the installation?" and I'm not sure how to solve it. I've never installed teradata before, and I'...
0
votes
1answer
25 views

MS Access - Creating a report based on a pass-through query that requires a parameter

I am attempting to make a report in Access that uses parameters as well as a pass-through query. I'm open to using a temporary table but the guides I can find using temporary tables all use an ...
0
votes
0answers
77 views

unixODBC - [IM002][unixODBC][Driver Manager] Data source name not found and no default driver specified

Folks, We installed unixODBC-2.3.7 on Aix 7.1 to connect to Oracle 11g. After setup odbc.ini and odbcinst.ini files and tried to connect with isql, we had the following error: # isql -v ORACLE [...
1
vote
0answers
31 views

better format using nanodbc R on Windows

Using R-3.5 and odbc (which uses nanodbc), I connect via ODBC and the ODBC Driver 13 for SQL Server ODBC driver on windows 10. DBI::dbGetQuery(odbccon, "select SYSDATETIMEOFFSET() as now") # ...
1
vote
2answers
85 views

ODBC Driver for Salesforce: Access Linked Server Object in SSMS

I have problems to access a linked server for a Salesforce ODBC data source with our MS SQL Server 2016 (Standard 64-Bit) using the Devart ODBC Driver for Salesforce in SSMS and SQL Studio Management ...
1
vote
0answers
41 views

Auth failing when using Devart ODBC connector to mLab

I'm trying to connect PowerBI to a mLab-hosted Mongodb instance. I first tried installing the MongoDB BI-connector, but after installing it didn't show up on the drivers list in Windows ODBC manager (...
0
votes
2answers
67 views

Do I need to update Oracle Client?

How does Oracle maintain Oracle Client software? I don't find Patch Updates for the Client Software of Oracle.
0
votes
1answer
327 views

Error connecting to MSSQL server from Linux

A colleague is trying to connect to the MS SQL Server Instance from linux using ODBC driver 17 and get's the below error. ('HYT00', '[HYT00] [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]...
-1
votes
1answer
80 views

'INTERVAL' is not a recognized ODBC date/time extension option

According to this docs on Interval Literals, this should be a valid INTERVAL, SELECT {INTERVAL '326' YEAR(4)}; But when I try that on dbfiddle, I get, Msg 155 Level 15 State 1 Line 1 'INTERVAL' is ...
2
votes
0answers
33 views

Upgrading Oracle ODBC driver from 11 to 12 causing code to fail

In the process of replacing our servers which involves updating the Oracle ODBC drivers from 11 to 12. We have a process that executes on these servers that calls a stored procedure. The procedure ...
2
votes
1answer
362 views

What is the HY number (HY000) in MySQL Error messages?

When I get an error some of them have an HY code, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") What is HY000 ...
0
votes
0answers
96 views

Intersystems Cache ODBC configuration for MS SQL compatibility

We have a linked server set up in our MS SQL Server 2017 to a Intersystems Cache database using supplied ODBC. For the most part it's working as expected, however sometimes it's throwing curve balls ...
0
votes
0answers
62 views

Linked server Informix driver mismatch error on driver and applciation

I tried to read all the questions here that has been asked before, but could not find any clue on my problem. I'm trying to setup a linked server to connect on INFORMIX server, I installed the driver,...
0
votes
0answers
78 views

Difference between ODBC, ODBC2 and ODBC3

My question is really simple, and sorry if it is more than only simple. But what is the difference between ODBC, ODBC2 and ODBC3 they are only different version of ODBC connections? I know that ODBC ...
0
votes
0answers
70 views

Unable to Insert data into encrypted columns using odbc driver 17 for SQL Server with column master key in azure key vault using aad authentication

I am trying to insert data into a table which is Column Encrypted using ODBC Driver 17 for SQL Server with column master key in AZURE KEY VAULT but it throws an error. When I try the same using SQL ...
0
votes
0answers
12 views

Inserting Records in linked ASE table in Microsoft Access

I am running into an odd error that i could use some help to solve. My microsoft Access File consist of: Two linked tables, using ODBC Adaptive Server Enterprise driver.(table1 and table2) One ...
0
votes
1answer
419 views

Error Calling Python module function DbMySQLFE.connect

Migrating a database from SqlServer to Mysql using "MySQL WorkBench 6.3 CE" using ODBC data source as default methode to use to connect to the RDBMS. -> Source Selection Test connection is Successful ...
4
votes
1answer
257 views

SSMA for Access - Migration Assistant Wizard fails at link tables

When using Sql Server Migration Assistant for Access with the Migration Wizard, all goes well converting an Access (2016) database to SQL Server Express (2017) until I get to the Link Tables step. ...
0
votes
0answers
73 views

SQL Server 2014 and SQL Server 2016 side by side - SQL Server Logs missing

I have two installations with one instance with SQL Server 2014 and another with SQL Server 2016 installed side by side. If I want to look at the SQL Server logs with SSMS I get the following error: ...
0
votes
0answers
170 views

How to switch OFF autocommit in a powershell ODBC connection to Postgres

I have an automated powershell script adding records to a postgres database and I’m attempting to improve the performance. Currently my connection is defined as…. $DBConnectionString = "Driver={...
0
votes
1answer
61 views

I can't open my Pharmacy management software“based on sybase database”

I am stuck with my pharmacy management software running on Windows XP with a dongle as a security system. The database is Sybase. I tried many backup copies but failed to open the program. Two ...
2
votes
2answers
99 views

SQL Server, odbc newbie question

My new job has some sql server 2014. I am an Oracle DBA. I need to help a client. They are having issues creating the ODBC connection from their laptop to the database server (or whatever MS calls ...
0
votes
2answers
32 views

MySQL Allows ODBC With Any Username

I have a MySQL Community database on a remote server and I am trying to get Microsoft Access to read data from it. This data is sensitive. The problem is, MySQL doesn't care about the username that I ...
0
votes
1answer
24 views

ODBC API SQLFetch() Asynchronously

I want to populate a grid as data is made available. If you run a really large sql query in SQL Management Studio the results window starts to populate with rows as they are made ready (I effectively ...
0
votes
0answers
221 views

Linked Server Query Performance Issue - FetchSize

I am analyzing a performance issue in SQL Server(2012) seen in queries executed against a Linked Server(connects to Oracle DB 11.2.0.4). The rows are returned in batches, 100 rows at a time. For 10,...
2
votes
1answer
150 views

Cosmos DB ODBC driver installation problem

We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error: The setup routines for Microsoft ...
1
vote
2answers
83 views

Pulling SQL Server data into Excel

I'm trying to pull data from an SQL Server database into Excel 2016 via ODBC / Microsoft Query (built in to Excel). I'd like to have a dropdown of companies, where after a company is selected from ...
2
votes
1answer
903 views

Excel Query Using MariaDB ODBC Driver

I'm using MariaDB ODBC driver version 3.0.2 for Windows(on Windows 10) and can't get excel (Excel 2013) to query the database. I'm able to connect to my MariaDB server using HeidiSQL and query just ...
0
votes
1answer
61 views

SQL Server 2012 (compability level 110) and SQL Server Native Client 10

I've upgraded my SQL Server 2008R2 to SQL 2012. I will set the compability level to 110 (2012) to all databases. But I'm wondering if it will create some problems for clients that connect to this ...
-1
votes
1answer
70 views

Expected behaviour of query notifications

I am using the Microsoft ODBC driver on a Linux system to connect to SQL Server 2012 on Windows to use the Query Notification feature. I run my C code and can see my subscription appear in sys....
0
votes
1answer
579 views

Next Steps to Diagnose ODBC SQLAllocHandle on SQL_HANDLE_DBC failed

An application intermittently fails with generic ODBC error. The client application is using ODBC to connect to SQL cluster. Enabling ODBC tracing shows this error: StorageOnlineOp 46ec-44a8 ...
0
votes
1answer
27 views

Safe to use odbc link betw Filemaker 11 Server & SQL Server 2012?

I’ve established a successful odbc connection between filemaker 11 Server and SQL Server 2012. Filemaker, inc has not certified this compatibility between the two but I have had no problems importing ...
4
votes
2answers
130 views

Access not properly translating TOP predicate to ODBC/Oracle SQL

I have a MS Access query that is based on a linked ODBC table (Oracle). The DDL for the underlying Oracle table is: create table road_insp ( insp_id integer, road_id integer, insp_date ...
0
votes
1answer
128 views

ODBC SQL tracer file question marks

I have an MS Access query that connects to an Oracle Express database via an ODBC connection. I've figured out a way to trace the SQL that is sent from MS Access to the ODBC connection. This is what ...
0
votes
1answer
411 views

Trace ODBC commands: What is the registry path for TraceSQLMode and where is SQLOUT.TXT?

In the Optimizing Microsoft Office Access documentation, it mentions that we can: ...edit a Microsoft Windows registry setting that allows you to see the commands that the Office Access database ...
1
vote
0answers
76 views

How can I forward odbc/oledbc connection through DMZ

I have an Oracle database separated from our BI system by two network zones (different sides of a DMZ). Company policy dictates that firewall openings may only pass to an adjacent zone. Therefore it ...
0
votes
0answers
127 views

Synonyms aren't visible in an ODBC connection to SQL Server 2016

I have a Crystal Reports instance (2011 Crystal version) that I'm trying to move from SQL Server 2008 to 2016. It uses ODBC (13.1 ODBC) to connect to SQL Server. In connecting to the 2008 instance ...
2
votes
0answers
67 views

Linked Server ODBC statement missing delimiters on reserved identifier

INSERT INTO SOMESERVER...[SomeTable] ([ID], [Timestamp]) VALUES (746, 1504500000) This statement is missing delimiters for the identifiers in an ODBC trace. "INSERT INTO SomeTable ( ID,Timestamp) ...
0
votes
0answers
164 views

MS Access ODBC Prepared statement needs to be re-prepared (#1615)

When I set the unique identifier after linking to a table through ODBC and I try to open any table in MS Access 2016 I get this: Reserved error (-7713): there is no message for this error. The error ...
0
votes
0answers
58 views

Access 2016 checkbox in linked ODBC MySQL table

Is it possible to have checkboxes for each record inside a ODBC linked MySQL table. Something like this: store the bolean values inside mysql database table and display yes/no UI element in Access ...
0
votes
1answer
64 views

What are the pitfalls of using “Preserve” for Cursor Behavior in Informix ODBC DSN?

I am converting an Informix SE to an IDS database. The programs I have use ODBC System DSNs to communicate with the database. For SE, we use the sesoctcp protocol. The program code, would open a ...
2
votes
0answers
380 views

Oracle Instant Client 64-bit “Unable to connect, SQLState=” Windows Server 2012

I have installed the Oracle 12.2 Instant Client ODBC 32 & 64 bit drivers and required software (VS C++ redist 2013 32 & 64 bit) on Windows Server 2012. I can create a connection and connect ...
1
vote
0answers
66 views

Missing files from mysql odbc driver installer

I'm trying to install the latest (5.2.7) version of the MySQL ODBC driver on Windows server 2008 R2, but when starting the installation, I get the following error: MySQL Workbench installs fine and ...
3
votes
1answer
335 views

Why Does SQL Server OPENQUERY To Oracle Return Different Column Types On SQL Server 2016 to 2008

I have two SQL Server Instances on the same machine, one 2008 and one 2016. Both instances have a linked server connection to the same Oracle 12 Server. If I run the following query 2008 returns 1.23 ...