Hello,

I am trying to connect to an Access database and get error "No value given for one or more required parameters.".

My code comes from two sources, a book and MSDN.

void ReadDatabase() {
    OleDbConnection objConn = new OleDbConnection(
                                 "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                 "Data Source=d:\\inetpub\\wwwroot\\myweb\\database\\myda tabase.mdb" );
    String query = "SELECT GuestBook.ID, GuestBook.Date, GuestBook.Name, GuestBook.Comments FROM GuestBook";
    OleDbCommand objCmd = new OleDbCommand( query , objConn );
    objConn.Open();
    OleDbDataReader drBooks = objCmd.ExecuteReader(); // offending line
    while (drBooks.Read())
    {
        Response.Write("<li>");
        Response.Write(drBooks["Date"]);
        Response.Write("\t");
        Response.Write(drBooks["Name"]);
        Response.Write("</li>");
    }
objConn.Close();
}

Have you tried a different operation with the connection to ascertain whether the offending item is the the connection or the command object?

Hello Brian,

I did not try a new opporation because I don't what would be a good test. I did try a couple of things with the connection:

Map Path which netted:
D:\Inetpub\wwwroot\MyWeb\ydatabase.mdb and got
Could not find file 'd:\Inetpub\wwwroot\Myweb\ydatabase.mdb' and

D:\Inetpub\wwwroot\MyWeb\database\\ydatabase.mdb and got
Could not find file 'd:\inetpub\wwwroot\myweb\database\ydatabase.mdb'

Then I set the web.config appSettings to

And then appSettings to
D:\Inetpub\wwwroot\MyWeb\database\mydatabase.mdb and got
No value given for one or more required parameters. on the open statement.

Not sure what else to do.

Thanks for your help