MS Oracle Data Provider - Null password

[Guest]

Hi

My machine has an Oracle 9i client that uses OS authentication to log in, so we use a / for the user name and a blank password. I am having trouble logging into the database with the following connection string

this.MSConnection.ConnectionString = "user id=/;data source=devd;password="

I get an ORA-01005: null password error. This connection string works fine with Oracle's ODP.NET driver. I have tried removing the password parameter, and still no luck. Any suggestions?

 

[Guest]

I was able to connect using the following string

this.MSConnection.ConnectionString = "integrated security=true;data source=devd";

 

[Pete Wright]

Just a point of interest - that's not quite the same as connecting with a
null password. What Integrated Security = true does is tell the database to
authenticate you based on your Windows login credentials.

On the null password side did you try setting the password to two single
quotes `` ?

--
--------------------------------------------------------
Peter Wright (www.petewright.org)
Author of ADO.NET Novice To Pro
From Apress. www.apress.com (and 10
other doorstops from Wrox)

I was able to connect using the following string:

this.MSConnection.ConnectionString = "integrated security=true;data

source=devd";

 

[Guest]

Hi

I am using the Windows login credentials to connect to Oracle. It seems like Microsoft's Oracle Data Provider behaves differently from Oracle's ODP.NET

As I mentioned earlier, the connection string I used for Microsoft's driver is
this.MSConnection.ConnectionString = "integrated security=true;data source=devd"

But the connection string I used for ODP.NET was
this.oracleConnection.ConnectionString = "user id=/;data source=devd"

Oracle's documentation states that for OS authentication, the user id needs to be set to / and any password given will be ignored

Thanks


----- Pete Wright wrote: ----

Just a point of interest - that's not quite the same as connecting with
null password. What Integrated Security = true does is tell the database t
authenticate you based on your Windows login credentials

On the null password side did you try setting the password to two singl
quotes ``

--
-------------------------------------------------------
Peter Wright (www.petewright.org
Author of ADO.NET Novice To Pr
From Apress. www.apress.com (and 1
other doorstops from Wrox

I was able to connect using the following string

source=devd"