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
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 ...
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 ...
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 ...
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.
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 ...
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....
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 ...
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.)
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 ...
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 ...
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 ...
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/...
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
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 ...
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 ...
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 ...
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/...
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 ...
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:
#...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
odbc × 182sql-server × 40
windows × 24
mysql × 18
php × 13
dsn × 13
unixodbc × 13
microsoft-access × 12
postgresql × 11
sql-server-2008 × 11
windows-server-2003 × 9
linux × 8
windows-server-2008 × 8
windows-xp × 8
oracle × 8
sql × 7
drivers × 7
windows-7 × 6
mariadb × 6
windows-server-2008-r2 × 5
windows-server-2012-r2 × 5
database × 5
64-bit × 5
asp-classic × 5
db2 × 5