| 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)
)
)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
