Connections to Oracle DB Suggestions?

[Daryll Shatz]

Any tips or suggestions on getting ADO.NET 2003 working with an ORACLE 7.3
or 8 database?

I have installed the Oracle client (application level install) and when I
try to add a connection, in the Server Explorer using the MS OLE DB Provider
for Oracle, I get a "connection failed because of an error initialzing
provider: ORA-12541: TNS:no listener" error.

Thanks

 

[Hussein Abuthuraya[MSFT]]

Daryl,

There are no issues when using the Oracle Client .NET Managed provider with Oracle 8 (not sure about 7.3 but it should work as well).

What you are seeing when adding a connection to Server Explorer is due to an Oracle client components issue. To make sure that the can talk to your Oracle server from
this machine, try to connect to it from SQL Plus tool that is installed by the Oracle Client components. If you can connect to is using SQL Plus then make sure that when setting
up the connection in Server Explorer that you use the same parameters (host name (server alias), UID and password). If that fails then use the following article to troubleshoot
this issue further:

INFO: Techniques to Debug Connectivity Issues to an Oracle Server Using the ODBC Driver and OLE DB Provider
http://support.microsoft.com/?id=259959

I hope this helps!

Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

 

[Lyndon Hills]

Any tips or suggestions on getting ADO.NET 2003 working with an ORACLE 7.3
or 8 database?

I have installed the Oracle client (application level install) and when I
try to add a connection, in the Server Explorer using the MS OLE DB Provider
for Oracle, I get a "connection failed because of an error initialzing
provider: ORA-12541: TNS:no listener" error.

Thanks

TNS no listener means that either the oracle listener process is not
running, or hat oracle cannot locate the machine the database is on,
or that it has found the machine but can't find a listener for the
oracle instance specified.