Access DB ISAM Error

[bruce]

your connection string is wrong

use something like this

("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" & server.MapPath("/_database/test.mdb"))


[b]quote:Originally posted by lipwrcom000


I am trying to open a connection to an Access DB (Access 2003) stored in the _database directory. I'm getting the following error when the aspx page loads.

"Could not find installable ISAM."

Here is the offending code which is executed during Page_Load...


string connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DSN=MYDSN";
string CmdText = "SELECT PK_FileID, FileName, FileSize, " +
"ContentType FROM Newsletters";

OleDbConnection con = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand(CmdText, con);

con.Open();

OleDbDataReader rd = cmd.ExecuteReader(CommandBehavior.SingleResult |
CommandBehavior.CloseConnection);



The error is triggered from " con.Open(); ".

I've googled this extensively and keep coming up with suggestions from Microsoft pertaining to checking the oledb dll's for Jet.

Does anybody have any suggestions?

Thanks in advance,
Dave

</blockquote id="quote"></font id="quote">

[lipwrcom000]

I am trying to open a connection to an Access DB (Access 2003) stored in the _database directory. I'm getting the following error when the aspx page loads.

"Could not find installable ISAM."

Here is the offending code which is executed during Page_Load...


string connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DSN=MYDSN";
string CmdText = "SELECT PK_FileID, FileName, FileSize, " +
"ContentType FROM Newsletters";

OleDbConnection con = new OleDbConnection(connString);
OleDbCommand cmd = new OleDbCommand(CmdText, con);

con.Open();

OleDbDataReader rd = cmd.ExecuteReader(CommandBehavior.SingleResult |
CommandBehavior.CloseConnection);



The error is triggered from " con.Open(); ".

I've googled this extensively and keep coming up with suggestions from Microsoft pertaining to checking the oledb dll's for Jet.

Does anybody have any suggestions?

Thanks in advance,
Dave

[lipwrcom000]

Thanks Bruce. That did the trick, though I'm not sure why using a DSN gave me the ISAM error.

Thanks again...
Dave