Keyword Not Supported: Provider - Sporadic Error

[jjwild]

We are writing a ASP.NET/VB.NET web site that uses an Access 97 database (legacy requirement).

It is running fine most of the time, except that about every 100th request sent to the database, we are receiving the Keyword Not Supported: Provider error. This happens on all 3 of our machines and a remote machine over which we have no control. So although it is sporadic, it is not a wierd issue having to do with how one particular PC is configured.

The connection string we use is the following:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\CBR32\Priv\Priv.mdb;User Id=;Jet OLEDBatabase Password=xxx".

Any ideas?

Thanks,

John Wildanger

 

[jbenson001]

Check this link for construction of connection strings:

http://www.connectionstrings.com/

From what I can see for Access connections strings, the bolded part is not necessary and may be causing a problem:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\CBR32\Priv\Priv.mdb;User Id=;[b]Jet OLEDB:Database[/b] Password=xxx".

 

[jjwild]

Thanks, but putting "Jet OLEDBatabase Password=" in the connection string instead of just "Password=" is needed for the Access 97 mdb. Without it, we receive a complaint that "the workgroup information file is missing or opened exclusively by another user".

Any other ideas on this?