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
tf842Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PontisCommented:

 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?
tf842Author Commented:
These are good questions. I have odp.net installed. How do I tell the oracle client is installed, and if it is, the version.
PontisCommented:
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).

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

PontisCommented:
Check  HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and see how many HOMEx keys you have there. If you have more than one, make sure that you have same the parameter I specified above in each of them (you can see the path to each home in ...HOMEx\ORACLE_HOME value).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tf842Author Commented:
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
PontisCommented:
All right, I see :)

 As for the points - I would appreciate partial... Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.