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
0answers
68 views

Suggestion to solve ORA-24812: CHARACTER SET CONVERSION TO OR FROM UCS2 FAILED

When we run our program we are getting the below error: OFIDREP 2019/08/25 12:15:34 -E- Stil_SqlCursorFetch: OFIDREP 2019/08/25 12:15:34 -E- ODBC STATE : 'HY000' OFIDREP 2019/08/25 12:15:34 -E- ODBC ...
0
votes
0answers
10 views

Need updated connection string for MySQL ODBC 5.3

I'm upgrading MySQL ODBC from 5.1.6 to 5.3.13, Windows 64-bit, to be used with a Visual FoxPro application. The previous connection string for DNSless operation was: lcDSNLess="DRIVER={MySQL ODBC 5....
0
votes
0answers
117 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 ...
0
votes
0answers
30 views

ODBC “generate SSPI context” error

We have a new SQL server has only TLS 1.1 & 1.2 enabled. We installed SQL server on it with "Local system" account. Later we change it to a domain account. User experience the "generate SSPI ...
1
vote
0answers
78 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 ...
0
votes
0answers
27 views

SQL Server - Fail to create new MySQL linked server - Error 7303

I'm trying to create a MySQL linked server but I get a 7303 error. I tried both x86 and x64 versions of the odbc driver but it doesn't change anything. My connection on the system odbc to the database ...
0
votes
1answer
37 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 ...
1
vote
0answers
202 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 the list and clicked ...
1
vote
1answer
37 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 -...
0
votes
2answers
56 views

Issue with Identifiers in Postgres greater than Oracle's limit while connecting over ODBC (DBLINK)

We have a database link from Oracle 12.1 to Postgres via psqlODBC Driver. There is a problem while running few queries/statements when the Postgres identifiers, like the length of a column name ...
1
vote
0answers
91 views

Unable to Connect to SQL Server 2005 through ODBC drivers from Windows 2012 server

We are unable to connect to a specific Database server which has SQL Server 2005 installed on Windows 2003 server from any of the Windows Server 2012. It used to work till last week, the only change ...
0
votes
0answers
93 views

bcp: dsn specified an unsupported driver

A straight-forward call to bcp works on linux and not on windows. Ubuntu ~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv \ -D -S mydsn -c -U myuser -t, -r '\n' -P '...' ...
0
votes
0answers
162 views

Unable to establish connection with data source with Teradata. Missing settings: {[DBCName]}

I'am installed Teradata driver on CentOS as described in official README. After installation drivers is located in /opt/teradata/client /ODBC_32/ /ODBC_64/ Each folder has subfolders and files ...
1
vote
0answers
133 views

Received an unsupported type from Postgres. (14) (SQLGetData)

I have database in PostgreSQL. It is simplest possible database with schema presented here: http://www.postgresqltutorial.com/postgresql-create-table/ I want to migrate it to MySQL. I trying to ...
0
votes
1answer
244 views

Oracle ODBC connection failure (using oracle's stock ODBC drivers)

I want to use an Oracle-ODBC connection in Visual Studio 2017/ SSIS as it's much faster than OLE DB during tests. Problem: I follow Oracle's steps to the letter. Install instant client (v18, ...
0
votes
1answer
268 views

SQL Server Execute Permission Denied

I have a small app which calls a stored procedure over ODBC using a sysadmin user with login and password. The problem is that some (Windows Domain) users get an error saying execute permissions were ...
1
vote
0answers
311 views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
0
votes
1answer
226 views

Cannot connect to an Hana database via its ODBC driver

I have not found any documentation about ODBC connection strings for Hana and am trying to connect using the examples in SAP HANA Database Client Interfaces. An attempt to connect via ODBC with the ...
2
votes
1answer
252 views

ODBC Driver “Oracle in OraClient11g_home1” required but can't seem to get it on Windows 10

Not sure if this was the right StackExchange for this. My job recently upgraded their machines to Windows 10 and I thought setting them up would be a breeze, but I can't for the love of me figure out ...
0
votes
1answer
68 views

Apache Ignite as linked Server in SQLServer?

I tried to set up a linked server via ODBC connection in SQLServer. It seem to connect but showed all the caches as empty names in SSMS. Also I couldnt get a select query to work. Has anybody had any ...
1
vote
0answers
87 views

Why getting Error accessing Cassandra with DataStax ODBC Driver?

We are using Cassandra 2.2.11, and trying to configure DataStax ODBC driver. We are getting the following error message: SQLSTATE: HY000[DataStax][CassandraODBC] (10) Error while executing a query ...
2
votes
2answers
471 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
41 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
248 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
134 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
678 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
101 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
156 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
806 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
48 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
451 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
108 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
666 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
3k 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
254 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
100 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
1k 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
146 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
1answer
1k 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
755 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
1answer
65 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
252 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
33 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
35 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 ...
2
votes
1answer
237 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
164 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
2k 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
83 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
113 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....
1
vote
1answer
2k 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 ...