Simple question on .mdb files (i think) 1

[owrsome]

Ok, I'm sure this is something I'm just overlooking, but I have an asp script that reads from a .mdb file using the following code... (Basically this works on one .mdb file but not on any others. So, I assume the error is in the format of the file, but I can't figure out the difference.)

//
// ***Setting up Database connection
//
var conn = Server.CreateObject("ADODB.Connection"
conn.Provider = "Microsoft.Jet.OLEDB.4.0";

//
// ***Opening Connection to mdb file.
//
conn.Open(Server.mappath("/database/Export.mdb&quot);

//
// ***Database Search String
//
var rs = Server.CreateObject("ADODB.Recordset"


// setting rs.Source here....
// ...


//
// ***Opening Recordset Connection
//
rs.ActiveConnection = conn;
rs.Open();

AND THIS IS THE ERROR I'M GETTING:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

I assume the connection is the paramater w/out value???

Thanks,
-Ben

 

[owrsome]

The question is very simple...
Should the .mdb file be in a different format? The one file works, but I can't seem to get any other .mdb file to run with this code.

 

[swampBoogie]

This has to do with SQL query you are using. One typical thing that can cause this error is a misspelled columnname or tablename.