4 votes
Accepted

Is there any way of backing up the ODBC drivers of a server?

Export the DSN into a file: Get-OdbcDsn |Export-Clixml dsn.xml Import it again Import-Clixml dsn.xml |Add-OdbcDsn
Gerald Schneider's user avatar
3 votes
Accepted

Issues Programmatically Adding ODBC DSN to ODBC Administrator on Windows

So since no one answered this question, I'm going to go ahead and fill in what I ended up doing below, for people such as @gimpy who may be looking for a similar answer. I ended up just going the ...
Dave McGinnis's user avatar
3 votes

Ubuntu 16.04 PHP 7 & Microsoft ODBC Driver for SQL Server on Linux - odbc_connect undefined

I had the same issue with the repo linked in MSDN. You would need to install the php-odbc package which needs a library that conflicts with the one from the microsoft repo. I installed the driver ...
IT Stangl's user avatar
3 votes

Remote MySQL connection fails (10060)

The error 10060 means that you are not allowed to access the web server remotely. Therefore Make sure that you are using the correct IP-address of the MySQL server. The rest of the parameters of your ...
Alexander's user avatar
  • 131
2 votes

Problems connecting to SQL Server using ODBC

At a quick glance, looks likely to be a delay caused by DNS hostname lookup. I'd try setting the target hostname to its IP address, and retest.
TallTed's user avatar
  • 279
2 votes

Kerberos ticket cache location on windows for multiple users

A ~ tilde occurring as the first character of an argument in Unix/Linux shell/bash is the same as the $HOME environment variable. Windows equivalent is %USERPROFILE%. You can use any user variable ...
JosefZ's user avatar
  • 1,584
2 votes
Accepted

Conflict when editing new records in Access connected to PostgreSQL by ODBC

I found the answer here: https://stackoverflow.com/questions/25088970/ms-access-odbc-with-postgresql-table-write-conflict My problem was caused by a timestamp field that had default now() constraint....
Thunderbeef's user avatar
1 vote
Accepted

Unable to Connect to SQL Server 2014 SP2 using the SQL Native Client 10

I Found the issue for this one, the owners of this server have removed all but TLS 1.2/AES encryption which isn't supported by the SQL Native Client 10.0 I was able to download an on-request hotfix ...
Rhys's user avatar
  • 36
1 vote
Accepted

Is the MariaDB ODBC Connector 3.1.19 now stable for production when used with ASP Classic?

I updated to MariaDB ODBC Connector to 3.1.19 and it fixed the crashing issue. (I also updated PHP.)
MeSo2's user avatar
  • 274
1 vote

Installing ODBC 18 driver on Amazon Linux

on Amazon Linux 2 you can use the RHEL and Oracle Linux instructions #RHEL 9 curl https://packages.microsoft.com/config/rhel/9.0/prod.repo > /etc/yum.repos.d/mssql-release.repo exit sudo yum ...
juliano developer's user avatar
1 vote

SQLCMD command works but ODBC does not

Port is not a valid keyword in odbc.ini on Linux for Microsoft's Linux ODBC driver. You need to specify Server = <hostname>,<port> in ODBC.ini. If you're using a dynamic port, leave the ...
Rob Shinn's user avatar
1 vote
Accepted

MySQL connector/ODBC connection error following a DNS mismatch

It's quite possible MySQL is maintaining an internal DNS cache of hosts. For a quick and dirty test, try SET GLOBAL host_cache_size=0; on the server (if DNS load is a concern, remember to reset it to ...
Brandon Xavier's user avatar
1 vote
Accepted

Built PHP from source with custom DataDirect ODBC drivers, but can't auto start with systemd

I was able to resolve my issue by adding the following lines to my /usr/lib/systemd/system/httpd.service file, under the [Service] section: Environment="ODBCINST=/opt/Progress/DataDirect/...
Barry Ralphs's user avatar
1 vote

How i can install mariadb odbc connector on Ubuntu 20.04

From the MariaDB ODBC Connector knowledge base page page there is a MariaDB ODBC Binary downloads link
danblack's user avatar
  • 1,269
1 vote
Accepted

ODBC Driver for IBM iSeries AS400 version V7R1

The tool is no longer called iSeries Access, but IBM i Access Client Solutions. Look here, and scroll down to the bottom of the page for Linux Application Package. But, the last line on the page says ...
jmarkmurphy's user avatar
1 vote
Accepted

ODBC Item on MySQL query causes Zabbix server to stop

I've found a solution by using MariaDB ODBC connector instead of the MySQL connector. Download https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.0.6/ I use debian-x86_64.tar.gz Unpack it ...
Vertex's user avatar
  • 121
1 vote

System resource exceeded - what resource could that be?

The three most likely causes for the "System Resource Exceeded" error on an ODBC Data Source are: Memory allocation failure- to resolve this particular issue, you can: check what memory limit is set ...
Anson W Han's user avatar
1 vote

How to update unixODBC via yum on EB awsLinux

The unixODBC v2.3.1 is available as unixODBC-utf16. Here are the shell commands as a user with sudo access: curl -s https://packages.microsoft.com/config/rhel/7/prod.repo | sudo tee /etc/yum.repos.d/...
kenorb's user avatar
  • 6,759
1 vote
Accepted

Powershell Get-ODBCDSN error - Timeout when waiting for another concurrent operation to complete

I know i am a year late by a year, however hopefully this will help somebody else out. I was just getting the same error "Get-OdbcDsn : Timeout when waiting for another concurrent operation to ...
Mvail's user avatar
  • 26
1 vote
Accepted

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

"Microsoft ODBC Driver 13 for SQL Server" does not work with isql. You must use sqlcmd. Connecting with sqlcmd and Use the sqlcmd Utility are far better than the sqlcmd man page. To use a DSN: #...
David's user avatar
  • 13

Only top scored, non community-wiki answers of a minimum length are eligible