Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
1
vote
0 answers

Add new ODBC driver libs to PHP on OS X 10.6?

I'm trying to access a PostgreSQL datasource via ODBC from the installed stock PHP (OS X 10.6). Queries just hang, and I'm suspecting it can't find the PostgreSQL driver library which was installed via MacPorts. I've compiled and installed the…
bpanulla
  • 186
  • 3
1
vote
0 answers

Oracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection Problems

I have an Oracle DB on a Win 2k3 Server (64-Bit). I have to access the database from a Win7 (64-Bit) machine. I have downloaded Instant Client and the 64-Bit ODBC driver, and have apparently successfull installed it. Specifically, I downloaded the…
Hanshan
  • 161
  • 1
  • 6
1
vote
1 answer

Installing Sql Server 2008 Express edition installation removes ODBC configurations

My company distributes an application that requires Sql Server 2008 R2 Express Edition. We use the Microsoft Offline installer for Sql and make exstensive use of the command line switches to get the installation configuration that we want. All of…
Seth Spearman
  • 2,211
  • 2
  • 14
  • 10
1
vote
2 answers

ODBC config files on Ubuntu

I am trying to set up an ODBC connection on Ubuntu. I've been swimming in various config files. Could someone please remind me the directory in which the odbc config file is stored? It is called the odbc.ini file, correct? And is there another…
Genadinik
  • 1,103
  • 4
  • 19
  • 39
1
vote
0 answers

Oracle Instant Client DSN via unixODBC

I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC. The connection seems to be working properly, after issuing an odbc_connect, I get a response of type "odbc…
Brad Westness
  • 115
  • 4
1
vote
3 answers

Is Access connecting to a remote Postgresql database via ODBC usable?

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking through some disaster recovery scenarios, and it…
Guy C
  • 505
  • 1
  • 4
  • 9
1
vote
2 answers

How do I automatically connect my client to an ODBC data source on another machine with dynamic IP?

At the customer's place, we've got a postgres DB on a server, and a few clients. We connect them through ODBC-drivers, and all machines run windows (usually XP). Now we had a few annoying issues: The client "forgets" some flags in the ODBC drivers,…
Kdansky
  • 171
  • 1
  • 10
1
vote
1 answer

Windows 7 XP mode - ODBC host connection

I have a legacy application that installs fine in Windows XP mode on Windows 7 64 bit, but it requries an ODBC connection. Is it possible to have the XP mode application use the host Windows 7 ODBC configuration (and Oracle drivers)?
marcwenger
  • 235
  • 1
  • 6
  • 21
1
vote
3 answers

ODBC connection is extremely slow

I have an ODBC connection to a providex database. We use the database in software throughout the company, and the ODBC connection is created by a standard installer. Trying to test the ODBC connection or query it in Crystal Reports.Net, results in…
Tony Peterson
  • 119
  • 1
  • 1
  • 4
1
vote
1 answer

ODBC DSN Authentication Options

I was wondering if besides the standard username/password ODBC authentication, other options exist to authenticate an ODBC connection using an alternate method like PKI similar to SSH. Seems like a username / password not as secure if all I want is…
noel_g
  • 41
  • 3
1
vote
1 answer

PHP ODBC Not Closing Connections

I just asked this question on stackoverflow, and it was recommended that I also ask here. I have a PHP application that uses the ODBC functions for database access. My DBA recently discovered that the application is not closings its database…
wshato
  • 111
  • 2
1
vote
1 answer

Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 error

Background: I am fetching data from a database on SQL Server 2008 (SQLA ) over to Oracle (ORCLA) . The data is pulled using a database link, via HS ODBC connection. Both the SQL and Oracle databases were 32-bit editions. Now, we moved the Oracle…
Sathyajith Bhat
  • 286
  • 1
  • 5
  • 23
1
vote
2 answers

Windows Server 2003 - Are ODBC Data Sources set per-user?

When I'm logged into our Windows Server 2003 server, I don't see any ODBC Data Sources, but when a different user logs in (who doesn't have Administrative rights), they have a big list of ODBC Data Sources. Are ODBC Data Sources set on a per-user…
Jake Wilson
  • 8,814
  • 29
  • 97
  • 125
1
vote
1 answer

silent failure while creating odbc data source

I just got really confused trying to create an ODBC data source in Windows 2003 R2. I can create a connection to my chosen server (a MS SQL Server) on the "user DSN" tab, but when I try to do the same thing on the "system DSN tab", the process fails…
Peter
  • 406
  • 1
  • 5
  • 13
1
vote
2 answers

Error creating ODBC connection to SQL Server 2008 Express

When creating a System DSN, I get the error: Connection failed: SQLState: '08001' SQL Server Error: 2 [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. Connection failed: …
DavidB
1 2 3
…
11 12