Server Fault Stack Exchange
Server Fault Stack Exchange

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…
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?
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…
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…
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…
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…
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…
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…
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?
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…
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…
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…
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…
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…
Viky
  • 638
  • 2
  • 7
  • 11
1
2 3
…
11 12