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
26 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 ...
0
votes
0answers
33 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;','...
0
votes
0answers
21 views

What could cause a slow DB connection between AWS and Azure?

Currently we are running with a piece of middleware and our SQL server in AWS. We are looking to move to Azure SQL managed instance. But I am experiencing severely increased insert times when using ...
0
votes
0answers
25 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 ...
0
votes
0answers
12 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 ...
1
vote
1answer
34 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 ...
0
votes
0answers
125 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 ...
0
votes
1answer
42 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.
0
votes
0answers
244 views

Unable to find oracle/dms/console/DMSConsole

I am using centos-8, java-8, tomcat-8, oracle 18.4.0 XE I not able to connect to the database. Tried to check everything that I was able to do but not able to understand where is the mistake. I ...
0
votes
0answers
231 views

SQL Polybase - Connect to MySQL ODBC - Issue with decimal data type

hope someone has a clue about this... I'm using SQL 2019 Polybase to connect to a MySQL 8 Server using an ODBC (MySQL 8.0.20 ODBC Driver). CREATE EXTERNAL DATA SOURCE eds_test1 WITH ( LOCATION = '...
0
votes
0answers
64 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 ...
0
votes
1answer
65 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 ...
0
votes
1answer
28 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 ...
1
vote
1answer
37 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 ...
0
votes
0answers
11 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 ...
0
votes
1answer
33 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 ...
0
votes
0answers
366 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 ...
0
votes
1answer
46 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 ...
1
vote
1answer
79 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-...
7
votes
1answer
3k 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 ...
2
votes
1answer
295 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 ...
2
votes
0answers
254 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
389 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
88 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
83 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
46 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
2k 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
2k 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 ...
1
vote
0answers
441 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
1answer
960 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 ...
0
votes
1answer
3k 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
293 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
183 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
198 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 ...
2
votes
0answers
514 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
661 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
615 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
691 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
3k 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
789 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
132 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
254 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
797 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
2k 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
223 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 ...
1
vote
1answer
3k 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
309 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
801 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
1answer
4k 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
76 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
2 3 4 5