468,103 Members | 1,300 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

Could not find installable ISAM.

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.
Nov 22 '05 #1
5 2289
can you post the cn string with the UID and PWD?
"Brent" <b@b.com> 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.

Nov 22 '05 #2
@"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" <b@b.com> 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.


Nov 22 '05 #3
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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 22 '05 #4
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" <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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 22 '05 #5
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: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" <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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)


Nov 22 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Brent | last post: by
6 posts views Thread by Robert Lawson | last post: by
1 post views Thread by JP Lacasse | last post: by
2 posts views Thread by Henrik | last post: by
1 post views Thread by Anatoly Kurilin | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.