Home » Open Source » Programming Interfaces » ODBC Failed - Urgent (Access2003, Oracle Ora92)
ODBC Failed - Urgent [message #294119] Wed, 16 January 2008 09:23 Go to next message
Messages: 1
Registered: January 2008
Junior Member
I have a similar problem as in the post :Connection with the server [message #284896]

Using Access 2003 I am getting an ODBC failed error.

I added the below to Transnames.ora for the Machine Data Source DSN.. The connection works on other machines I can ping the server...The difference is the Host in the similar message has the IP address and has Service Name instead of SID. Does this make a difference.

(ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
(SID = infp)
Re: ODBC Failed - Urgent [message #294136 is a reply to message #294119] Wed, 16 January 2008 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the Oracle error is?
If it is urgent you should provide all the details before we ask you so.

Re: ODBC Failed - Urgent [message #296115 is a reply to message #294119] Thu, 24 January 2008 12:20 Go to previous message
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
What happens when you do a TNSPING ?
Previous Topic: help with Perl code to insert a long string (> 32512 chars) via stored procedure
Next Topic: why date field type change into datetime using odbc connect to oracle XE
Goto Forum:

Current Time: Fri Jun 09 08:51:47 CDT 2023