• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

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
0
tf842
Asked:
tf842
  • 4
  • 2
1 Solution
 
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?
0
 
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.
0
 
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).

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy 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).
0
 
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
0
 
PontisCommented:
All right, I see :)

 As for the points - I would appreciate partial... Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now