asked on

odp.net 9.2 OS Authentication in VB.NET gets password null error

I currently have odp.net 9.2 and am using OS Authentication. When I try to use it with VB.NET after referencing system.data.oracleclient, and the connection string:
"user id=/;data source=my.database.com" I get an ora-01005 null password error.

When I log into Toad, as user / and blank password, it works fine.

I tried "user id=/;password=;data source=my.database.com" to no avail.

Any suggestions?

tf

Pontis

Do you have Oracle Client and ODP.NET installed in the same ORACLE_HOME or in separate? Make sure that you have the following line in your %ORACLE_HOME%\network\admin\SQLNET.ORA :

sqlnet.authentication_services=(NTS)

What version is Oracle client?

tf842

ASKER

These are good questions. I have odp.net installed. How do I tell the oracle client is installed, and if it is, the version.

Pontis

Also, do you use connection pooling? I came across a bug on Metalink saying that when connection pooling is used with ODP theer might be a problem with proxy authentication. Try to disable it ( pooling=false in your connect string).

ASKER CERTIFIED SOLUTION

Pontis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tf842

ASKER

Pontis,
I realized the mistake. I was referencing System.data.oracleclient instead of Oracle.dataacess.client in my vb.net code. I changed the refrences and associated propertis. Now it works.

I do not want to use connection pooling because it is kinda buggy.

Your suggestions were not the answer, but by following them, I stumbled onto it. I will ask the moderator about partial points, say 250.

How would you feel about this?

Sami

Pontis

All right, I see :)

As for the points - I would appreciate partial... Thanks.