473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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 18 '05 #1
5 4040
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 18 '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 18 '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 18 '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 18 '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 18 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Brent | last post by:
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...
1
by: Steve | last post by:
I get a "Could Not Find Installable ISAM" error on my objConn.open() statement. I suspect my connection string is bad. What I am trying to do is write to an Excel file on my local computer from a...
1
by: Karl Irvin | last post by:
In the module below, I get a "Could not find installable ISAM" error on the tdf.refresh link. The NewConnection refers to a valid database/table. My References include VBA, Access 9.0 Object...
2
by: Horst Walter | last post by:
I am using C# / ADO.NET to create an Excel sheet: This connection string works: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; This...
6
by: Robert Lawson | last post by:
I continue to get the below error message when trying to load a aspx file. Could someone please point me in the right direction for solving this? I'm trying to access an access data base and I'm...
1
by: JP Lacasse | last post by:
I translate a web application from ASP to ASP.NET and I keep getting the following error: Could not find installable ISA I used the same ConnectString ("DBQ=" &...
1
by: Roger Twomey | last post by:
I have a form that allows a user to upload a microsoft Excel Spreadsheet. (I am testing with one created in Excel 2000) The spreadsheet is uploaded correctly. It is then supposed to be read...
2
by: Henrik | last post by:
Hello I starting use ASP.NET and has created a new file to open a Access database I get these error and cant solve it - please need some help. I Use Windows 2000 (have also tried to put it...
1
by: Anatoly Kurilin | last post by:
Hi, each time I use that code for calculating a number of user connected to a data file, I get an error message: Could not find installable ISAM. What do I do wrong? Dim cn As New...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.