| ODBC Failed - Urgent [message #294119] |
Wed, 16 January 2008 09:23  |
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  |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA |
Senior Member |
|
|
|
What happens when you do a TNSPING ?
|
|
|
]
Members
Search
Help
Register
Login
Home
