Could not find installable ISAM.

[Brent]

Hi, my asp.net c# app is trying to connect to an Access database with a
password and am I getting the error.. Could not find installable ISAM. . If
I connect to one without a password it works fine. I've looked at Q209805
but I don't think that helped. Oledb connection. Here is the one that works
without a password.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

but add uid and pwd on one with a password and I get the error. Please help.

[William Ryan eMVP]

can you post the cn string with the UID and PWD?
"Brent" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

Hi, my asp.net c# app is trying to connect to an Access database with a
password and am I getting the error.. Could not find installable ISAM. . If I connect to one without a password it works fine. I've looked at Q209805
but I don't think that helped. Oledb connection. Here is the one that works without a password.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

but add uid and pwd on one with a password and I get the error. Please help.

[Brent]

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
Info=True;Jet OLEDB:Database PWD=abc;User ID=Admin"
also tried
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
Info=True;PWD=abc;User ID=Admin"
and
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
Info=True;Jet OLEDB:Database PWD=abc;UID=Admin"
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:eB**************@tk2msftngp13.phx.gbl...

can you post the cn string with the UID and PWD?
"Brent" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

Hi, my asp.net c# app is trying to connect to an Access database with a
password and am I getting the error.. Could not find installable ISAM. .

If

I connect to one without a password it works fine. I've looked at Q209805 but I don't think that helped. Oledb connection. Here is the one that

works

without a password.
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +

@"Data Source=C:\db2.mdb");

but add uid and pwd on one with a password and I get the error. Please

help.

[Paul Clement]

On Thu, 29 Apr 2004 15:54:11 -0600, "Brent" <[e-mail]> wrote:

¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
¤ Info=True;Jet OLEDB:Database PWD=abc;User ID=Admin"
¤ also tried
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
¤ Info=True;PWD=abc;User ID=Admin"
¤ and
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security
¤ Info=True;Jet OLEDB:Database PWD=abc;UID=Admin"
¤

Looks like the Jet OLEDB argument is incomplete (in two of your examples) and the Password (not PWD)
parameter is incorrect:

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Jet OLEDB:Engine Type=5;Persist Security
Info=True;User ID=Admin;Password=abc"

You may also need to include the path to the System.mdw file if you are implementing user level
security.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Brent]

Hmm, Man, I'm still having problems getting this to work. I have a database
password set, but I am not using user level security. What should my string
be for this? Right now I have the following string, but that gives me the
error that it needs the workgroup information file, which I am not using.
Please help. Thanks!
@"Provider=Microsoft.Jet.OLEDB.4.0;" +

@"Data Source=C:\abc.mdb;Jet OLEDB:Engine Type=5;Persist Security
Info=True;" +

@"Password=abc");

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:ck********************************@4ax.com...

On Thu, 29 Apr 2004 15:54:11 -0600, "Brent" <[e-mail]> wrote:

¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security ¤ Info=True;Jet OLEDB:Database PWD=abc;User ID=Admin"
¤ also tried
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security ¤ Info=True;PWD=abc;User ID=Admin"
¤ and
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security ¤ Info=True;Jet OLEDB:Database PWD=abc;UID=Admin"
¤

Looks like the Jet OLEDB argument is incomplete (in two of your examples) and the Password (not PWD) parameter is incorrect:

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Jet OLEDB:Engine Type=5;Persist Security Info=True;User ID=Admin;Password=abc"

You may also need to include the path to the System.mdw file if you are implementing user level security.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Brent]

Nevermind, I FINALLY got it. Here's what it was I needed....
@"Provider=Microsoft.Jet.OLEDB.4.0;" +

@"Data Source=C:\db2.mdb;Jet OLEDB:Engine Type=5;" +

@"Jet OLEDB:Database Password=abc");

I guess it was that I was providing a user password, instead of a database
password. :)

"Brent" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

Hmm, Man, I'm still having problems getting this to work. I have a database password set, but I am not using user level security. What should my string be for this? Right now I have the following string, but that gives me the
error that it needs the workgroup information file, which I am not using.
Please help. Thanks!
@"Provider=Microsoft.Jet.OLEDB.4.0;" +

@"Data Source=C:\abc.mdb;Jet OLEDB:Engine Type=5;Persist Security
Info=True;" +

@"Password=abc");

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:ck********************************@4ax.com...

On Thu, 29 Apr 2004 15:54:11 -0600, "Brent" <[e-mail]> wrote:

¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist Security

¤ Info=True;Jet OLEDB:Database PWD=abc;User ID=Admin"
¤ also tried
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist

Security

¤ Info=True;PWD=abc;User ID=Admin"
¤ and
¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Persist

Security

¤ Info=True;Jet OLEDB:Database PWD=abc;UID=Admin"
¤

Looks like the Jet OLEDB argument is incomplete (in two of your

examples) and the Password (not PWD)

parameter is incorrect:

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\abc.mdb;Jet

OLEDB:Engine Type=5;Persist Security

Info=True;User ID=Admin;Password=abc"

You may also need to include the path to the System.mdw file if you are

implementing user level

security.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)