| What ODBC driver connect MS .NET to Oracle 8.0.6 [message #100188] |
Thu, 29 August 2002 07:28  |
breenm
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
connect visual studio (vb.net Visio.Net etc) to Oracle
8.0.6
ODBC driver - keeps saysing "lisener not found"
I also have MS SQL server and CAN MAKE an ODBC connection - so I believe I'm doing things right.
What ODBC driver connect MS .NET to Oracle 8.0.6
|
|
|
|
| Re: What ODBC driver connect MS .NET to Oracle 8.0.6 [message #100189 is a reply to message #100188] |
Thu, 29 August 2002 10:40  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
SQL Server has nothing to do with Oracle and sqlnet. Your Oracle ODBC connection will use sqlnet so first use ping to test if you can reach the server. Then use tnsping to test the tnsnames.ora entry. ODBC will use this file to find the database. Say the DB you want is PROD and it is on the server ATLAS.
ping atlas ! should get a reponse
the entry in your tnsnames.ora for PROD is prod.world
tnsping prod.world !should get a response.
This has to work from your client before you create a DSN. If all the above works go to the server and verify that the listener is up and running and it is listening for the SID you are asking for.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
