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
lcannon
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.

IT.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mango)(PORT = 1521))
)
(CONNECT_DATA =
(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: 58951
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.

Regards
Michel
Re: ODBC Failed - Urgent [message #296115 is a reply to message #294119] Thu, 24 January 2008 12:20 Go to previous message
MarcL
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: Mon Sep 01 09:30:51 CDT 2014

Total time taken to generate the page: 0.07386 seconds