Could not find installable ISAM.

Brent

unread,

Apr 29, 2004, 5:30:38 PM4/29/04

to

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

unread,

Apr 29, 2004, 5:45:11 PM4/29/04

to

can you post the cn string with the UID and PWD?
"Brent" <b...@b.com> wrote in message
news:1092t0h...@corp.supernews.com...

Brent

unread,

Apr 29, 2004, 5:54:11 PM4/29/04

to

@"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" <dotne...@comcast.nospam.net> wrote in message
news:eBMD0MjL...@tk2msftngp13.phx.gbl...

Paul Clement

unread,

Apr 30, 2004, 9:45:10 AM4/30/04

to

On Thu, 29 Apr 2004 15:54:11 -0600, "Brent" <b...@b.com> 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 ~~~ pcle...@ameritech.net
Microsoft MVP (Visual Basic)

Brent

unread,

May 3, 2004, 11:38:15 AM5/3/04

to

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" <UseAdddressA...@swspectrum.com> wrote in message
news:ckl4909rerbfv4nte...@4ax.com...

Brent

unread,

May 3, 2004, 11:51:03 AM5/3/04

to

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" <b...@b.com> wrote in message

news:109cprm...@corp.supernews.com...