Questions tagged [odbc]
172 questions
31
votes
11 answers
How do I get this SQL Server ODBC Connection working?
Note: I've obviously changed the server names and IPs to fictitious ones.
Here's what's going on. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on this server itself, I've got an ODBC connection set…
![](../../users/profiles/22105.webp)
soapergem
- 719
- 4
- 13
- 29
9
votes
3 answers
How can I create an ODBC connection from .bat file in Windows?
I need a batch script to create an ODBC/DSN connection from a .bat file in Windows. How can I do this?
![](../../users/profiles/114595.webp)
Jhonathan
- 195
- 1
- 1
- 4
8
votes
8 answers
Remote MySQL connection fails (10060)
When I am trying to connect to a MySQL database from a remote computer I get a prompt saying: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't Connect to MySQL server on 'XXX.XXX.XX.XX' (10060)
I have created a user account in the MySQL…
None
6
votes
1 answer
32bit ODBC Postgres driver on Windows 2008 R2 x64
I'm trying to install the Postgres ODBC 32bit driver on a Windows 2008 R2 64bit machine. After installing it, with no errors, I go to the ODBC panel, the 32bit version under the /syswow64 folder and try to add the driver, select the Postgres driver…
![](../../users/profiles/223364.webp)
Mia
- 201
- 1
- 5
5
votes
2 answers
Unable to Create System DSN
Environment:
Windows 7 Professional 64-bit Operating System
Problem:
(ODBC Data Source Administrator)
Opening Administrative Tools -> Data Sources (ODBC) -> Click "System DSN" tab.
Error:
ODBC System DSN Warning
You are logged on with…
![](../../users/profiles/112306.webp)
Baxter
- 167
- 1
- 2
- 11
4
votes
2 answers
Sharing SSH port tunnel with local network
I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command:
ssh -N -f -L 5431:localhost:xxxx mycloudserver.com
(where xxxx is remote port)
With this command I can access remote PostgreSQL…
![](../../users/profiles/312391.webp)
Giovanni Formentini
- 43
- 1
- 4
4
votes
3 answers
Lotus NotesSQL Driver - cannot install
I need to install Lotus NotesSQL Driver (current version is 8.5) onto a virtual machine running XP. Here's what's I've done so far:
I retrieved the file (CZOWFEN.zip) from the IBM website.
I ran the exe.
I then went to My…
![](../../users/profiles/15017.webp)
PowerUser
- 165
- 1
- 1
- 4
4
votes
3 answers
What is the difference between running a Windows service vs. running through shell?
I am trying to troubleshoot an issue on a Windows 2008 server where running attempting to connect to a "Timberline Data Source" ODBC driver crashes if the call is in a "service" context, but succeeds if the call is initiated manually in a Remote…
![](../../users/profiles/115241.webp)
zashu
- 143
- 6
4
votes
3 answers
Windows 2003 ODBC Issues - Error 10055
Using data integrator for ETL's pulling data from DB2 to SQL Server, after some time, will get these odbc errors:
Communication link failure. comm
rc=10055 - CWBCO1003 - Sockets error,
function returned 10055
Can't do anything with ODBC after…
![](../../users/profiles/1185.webp)
ScaleOvenStove
- 285
- 6
- 11
4
votes
3 answers
ODBC: trouble removing system DSN
I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32
Anybody encountered this before?
![](../../users/profiles/13904.webp)
Nick
- 155
- 2
- 5
4
votes
2 answers
How do I install Informix ODBC on Windows Server 2003/2008?
I installed the Informix Client SDK on my PC (32 bit) and on the server. I could create an ODBC connection on my PC easily, but on both Windows 2003 and 2008 (64 bit) I can't.
I don't know if there is a 64 bit SDK; maybe this is the issue. But I…
![](../../users/profiles/19590.webp)
sergiogx
- 335
- 3
- 15
3
votes
0 answers
InterSystems ODBC drivers not connecting
Errors when trying to create a ODBC DSN.
Have tried both 32-bit and 64-bit InterSystems ODBC drivers (version 2018.1.2.309.0).
OS: Windows Server 2019 Version 1809
The 32-bit ODBC connection was working earlier. Maybe Windows Updates broke this…
![](../../users/profiles/184366.webp)
Ash
- 448
- 2
- 9
- 31
3
votes
1 answer
Issues Programmatically Adding ODBC DSN to ODBC Administrator on Windows
I am working on trying to automate some configuration, and as part of that we need to add an ODBC DSN through a script. The driver I'm trying to use is the Cloudera Impala ODBC Connector, downloaded from here. All of the machines this will run on…
![](../../users/profiles/420311.webp)
Dave McGinnis
- 133
- 1
- 12
3
votes
1 answer
What kind of file and folder permissions are necessary for ODBC?
In our network, we are using an application that connects to an *.mdb access database through ODBC (User DSN).
The mdb is based on a subfolder of a share that is locally mapped to W:
What kind of minimum permissions do I have to give users on the…
![](../../users/profiles/318510.webp)
vic
- 973
- 1
- 9
- 21
3
votes
1 answer
ORA-12705: invalid or unknown NLS parameter value specified
I have a J2EE application hosted on JBoss on Linux.
When I try to access the application, I see following error in the server.log file.
ORA-12705: invalid or unknown NLS parameter value specified
When I point the same JBoss instance to a different…
![](../../users/profiles/360512.webp)
Viky
- 638
- 2
- 7
- 11