Problem with connection string that has Jet OLEDB:ODBC Command Time Out=180

Posted 2011-09-23 16:19
by Roger Moore
in the Access Forum

When I attempt to connect to an MS Access database with the following connection string,

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;User ID=Admin;Data Source=" + strDatabasePath + @";Mode=Share Deny None;Extended Properties="";COUNTRY=0;CP=1252;LANGID=0x0409"";Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:ODBC Command Time Out=180"

When commands execute I receive the following error:

"Could not find installable ISAM."

When I change the string to the following, it works:

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;User ID=Admin;Data Source=" + strDatabasePath + @";Mode=Share Deny None;Extended Properties="";COUNTRY=0;CP=1252;LANGID=0x0409"";Jet OLEDB:Global Partial Bulk Ops=2"

My question is, how do I increase the ODBC command timeout? TIA.

Reply 2011-09-23 21:35
by Roger Moore
in the Access Forum

Resolved issue by setting command timeout on the C# object rather than trying to set the command timeout in the connection string.