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

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.

1 answer