Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).
262 questions
0
votes
1
answer
42
views
Constant Error 145: "Can't open file: 'mytable.myi'"
I’m running a MySQL ODBC 3.51 instance using VB6. A specific table keeps getting locked or corrupted, preventing the software from accessing it, and in the MySQL error log I keep finding entries like:
...
0
votes
1
answer
47
views
Linked Server failure on clustered SQL Server
I have two clustered Microsoft SQL Servers (SQLA & SQLB) installed, and confirmed that both of the servers have an ODBC connector for a local PostgreSQL server.
From that ODBC connection, I have a ...
NathanM
0
votes
1
answer
74
views
Clickhouse - Oracle ODBC connection error
I am trying to create connection between my oracle and clickhouse databases, so I could query oracle through ch like this: SELECT * FROM odbc('DSN=OracleODBC-21', 'sys', 'test'). I have successfully ...
- 101
0
votes
0
answers
59
views
ODBC select * skips columns reading from sqlServer
I'm missing knowledge, I only know ORACLE.
The Situation :
Oracle 12.1 (linux) connects to SQL Server (Win) using dg4odbc and MS-SQLServer ODBC driver for linux. Reading from SQLServer via select * ...
- 1
0
votes
0
answers
94
views
SSIS ODBC Destination to MariaDB is slow – How to enable bulk inserts?
I'm trying to copy data from SQL Server to MariaDB using SSIS.
I’ve configured a DSN using the official MariaDB ODBC connector.
My SSIS data flow consists of a simple source query (retrieving ~5,000 ...
- 512
0
votes
0
answers
46
views
Is there any way to hide tables when using a ODBC connection in Excel?
When using the ODBC data source, or the Microsoft Query Wizard to connect to a PostgreSQL database, I can see all tables; even though I only have permission to see several. The wizard even shows me ...
- 101
0
votes
1
answer
902
views
SQL Server 2019 Hard Dependency on ODBC Drivers
When installing SQL Server 2019, ODBC drivers are also installed at the same time that MSSQL seems to have a hard dependency on. Can MSSQL be reconfigured to use newer versions of ODBC drivers and the ...
- 48
1
vote
0
answers
52
views
Any issues with EDB Postgres, plpython3u, Psycopg on Apple Silicon?
I currently have an old Intel i7 based iMac. I plan to upgrade to the M4 Mac Mini (Apple silicon).
I am running Postgres and use plPython (plpython3u) internally for procedures and triggers. ...
- 161
0
votes
0
answers
136
views
How do I connect MySQL Workbench to SQL Server with System DSN
tl;dr how can one connect Workbench to SQL Server database using Windows Authentication and/or System DSN?
Context: Win11, SQL Server 2022, SQL Server Management Studio 20.2, MySQL 8.0, and MySQL ...
- 148
0
votes
1
answer
479
views
Problem with many connections from RHEL 8.10 to SQL Server
I have simple script:
for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
...
- 11
-1
votes
2
answers
2k
views
SQL agent doesn't start after ODBC upgrade
For security reasons, I would like to upgrade the ODBC driver from version 17 to version 18, but when I do this, the SQL agent does not start. How to configure it to start?
The log says: Windows could ...
- 1
0
votes
0
answers
264
views
Why is my Oracle database link to MSSQL not working after successful creation?
I am trying to establish a database link between Oracle, which is installed on a Linux server, and MSSQL, which is installed on a separate Windows server. I have already:
Successfully tested the DSN
...
1
vote
0
answers
98
views
SQL Server unexplained network traffic gaps in traced events
This appears to have started happening a week, maybe two weeks ago.
Essentially, we cannot figure out whether it is the server or the client that is periodically pausing between SQL statements. In the ...
- 4,340
1
vote
1
answer
95
views
SAGE ODBC driver - minimum required folder permisions
I have a website which I want to connect to SAGE ACCDATA folder (which resides on a different server but same network to the intranet server) using their proprietary ODBC driver.
For security purposes ...
- 163
1
vote
1
answer
7k
views
How to create a linked server to PostgreSQL database in MS SSMS?
Can someone tell me what the provider string looks like when trying to connect from MS SSMS to PostgreSQL database via linked server?
- 163