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
1
vote
0answers
28 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 ...
0
votes
1answer
29 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 ...
1
vote
3answers
47 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 ...
0
votes
1answer
25 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 ...
0
votes
0answers
48 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 ...
0
votes
1answer
30 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 ...
0
votes
0answers
17 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# ...
0
votes
0answers
27 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 ...
0
votes
2answers
51 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 ...
1
vote
0answers
443 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). ...
0
votes
0answers
54 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 ...
0
votes
1answer
65 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 ...
0
votes
0answers
133 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
89 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
80 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 ...
1
vote
1answer
38 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
31 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
42 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
406 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
78 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
126 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
83 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
34 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
82 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
14 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
528 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
128 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
4k 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
357 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
315 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
555 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
107 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
114 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
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 ...
1
vote
0answers
506 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
1k 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
4k 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
399 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
256 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
239 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
627 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
753 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
694 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
788 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
993 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 ...

1
2 3 4 5