Database problem (Ch2 ASP.NET1.1)

danb · August 29th, 2004, 04:02 PM

Hi, I have a problem with connecting to a database:

Code:

The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\Dan Brammal\My Documents\BegASPNET11\Ch01'. It is already opened exclusively by another user, or you need permission to view its data.

The error is on line 22:

Code:

Line 20:        objConnection = new OleDbConnection(strConnect);
Line 21:        objCommand = new OleDbDataAdapter(strCommand, objConnection);
Line 22:        objCommand.Fill(DataSet1, "products");
Line 23:        DataGrid1.DataSource=DataSet1.Tables["Products"].DefaultView;
Line 24:        DataGrid1.DataBind();

The database is not open, and as far as I can tell I have full permissions on the database file and all folders in which it resides.

This is really annoying!! Anyone know a solution??

Thanks...

Hal Levy · August 30th, 2004, 09:10 AM

YOU don't need permissions- the ASPNET user needs permissions.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee