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
15 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-...
-1
votes
0answers
62 views

Oracle 19: Cannot connect via ODBC but it works with Oracle SQL Developer [closed]

I am using Oracle SQL Developer to export data to CSV format. I would like to connect to the same Oracle database from R and/or Python via ODBC to do some statistics, but after following this tutorial ...
6
votes
1answer
2k 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 ...
0
votes
1answer
74 views

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

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 ...
0
votes
0answers
14 views

Ingres ODBC driver not working

I recently installed an Ingres database as part of an application install. When I try to view its ODBC though it returns the following screen. A majority of the text has been replaced with ERget: ...
2
votes
0answers
63 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-...
2
votes
1answer
90 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 ...
1
vote
0answers
35 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 ...
0
votes
1answer
26 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 ...
1
vote
0answers
42 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 ...
3
votes
1answer
208 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 ...
0
votes
0answers
28 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
668 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
77 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
215 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
47 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
155 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
822 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
113 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
83 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
160 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
138 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
405 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
230 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
432 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
420 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
465 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
662 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
355 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
87 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
123 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
550 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 (...
1
vote
1answer
530 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
179 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
1k 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
169 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
330 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
2k 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
60 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
643 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
122 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
1k 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
5k 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
295 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
113 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
3k 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
180 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
2k 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
983 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 ...