Discussion:
Can I change the connection time out for MS Access (using OLEDbConnection) ?
(too old to reply)
fniles
2007-04-17 05:00:32 UTC
Permalink
Can I change the connection time out in VB.Net 2003 and MS Access (using
OLEDbConnection) ?
When I use Connect Timeout = 60 in the connectionstring, I get an error
"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done."

Thanks.

ConnectionOLE = New OleDb.OleDbConnection
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBPath &
";Connect Timeout=60" ???
With ConnectionOLE
.ConnectionString = sPath
.Open() --> error "Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done."
Daniel E. Ulfe
2007-04-17 15:02:40 UTC
Permalink
I am not sure is this has something to do with it... but I thing it should
be: ""... ;Connect Timeout=60;" (note the ";" at the end)... well... if that
does not work... you can try the "ConnectionTimeout" property of the
connection like:

myCnn.ConnectionString = myConnectionString
myCnn.ConnectionTimeout = 60
myCnn.Open

Hope this helps...

Daniel.
Post by fniles
Can I change the connection time out in VB.Net 2003 and MS Access (using
OLEDbConnection) ?
When I use Connect Timeout = 60 in the connectionstring, I get an error
"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done."
Thanks.
ConnectionOLE = New OleDb.OleDbConnection
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBPath &
";Connect Timeout=60" ???
With ConnectionOLE
.ConnectionString = sPath
.Open() --> error "Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done."
fniles
2007-04-17 16:08:37 UTC
Permalink
Thank you.
I tried "... ;Connect Timeout=60" (without ";" at the end) and it gave the
same error.
When I do myCnn..ConnectionTimeout = 60 it says "property ConnectionTimeout
is 'Read Only'"
May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
What is the default ConnectionTimeout for MS Access using OLEDBConnection ?

Thank you.
Post by Daniel E. Ulfe
I am not sure is this has something to do with it... but I thing it should
be: ""... ;Connect Timeout=60;" (note the ";" at the end)... well... if
that does not work... you can try the "ConnectionTimeout" property of the
myCnn.ConnectionString = myConnectionString
myCnn.ConnectionTimeout = 60
myCnn.Open
Hope this helps...
Daniel.
Post by fniles
Can I change the connection time out in VB.Net 2003 and MS Access (using
OLEDbConnection) ?
When I use Connect Timeout = 60 in the connectionstring, I get an error
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done."
Thanks.
ConnectionOLE = New OleDb.OleDbConnection
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBPath &
";Connect Timeout=60" ???
With ConnectionOLE
.ConnectionString = sPath
.Open() --> error "Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done."
Daniel E. Ulfe
2007-04-17 18:42:19 UTC
Permalink
Hi...

My bad... the ConnectionTimeout is indeed ReadOnly.... (brain fart)

The default timeout (according to the help file) is 15 seconds... that it
should be enough to get access to your DB...
Post by fniles
May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
Are you using "link tables" in MS Access? (Using VB to connect ACCESS and
ACCESS to connect SQL?)

Sorry... I could not make "Connect Timeout" work with OLEDB-JET... :(

Daniel.
Post by fniles
Thank you.
I tried "... ;Connect Timeout=60" (without ";" at the end) and it gave the
same error.
When I do myCnn..ConnectionTimeout = 60 it says "property
ConnectionTimeout is 'Read Only'"
May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
What is the default ConnectionTimeout for MS Access using OLEDBConnection ?
Thank you.
Post by Daniel E. Ulfe
I am not sure is this has something to do with it... but I thing it should
be: ""... ;Connect Timeout=60;" (note the ";" at the end)... well... if
that does not work... you can try the "ConnectionTimeout" property of the
myCnn.ConnectionString = myConnectionString
myCnn.ConnectionTimeout = 60
myCnn.Open
Hope this helps...
Daniel.
Post by fniles
Can I change the connection time out in VB.Net 2003 and MS Access (using
OLEDbConnection) ?
When I use Connect Timeout = 60 in the connectionstring, I get an error
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done."
Thanks.
ConnectionOLE = New OleDb.OleDbConnection
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBPath &
";Connect Timeout=60" ???
With ConnectionOLE
.ConnectionString = sPath
.Open() --> error "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done."
fniles
2007-04-18 13:46:55 UTC
Permalink
Thank you.
No, I am not using "link tables" in Access.
Post by Daniel E. Ulfe
Hi...
My bad... the ConnectionTimeout is indeed ReadOnly.... (brain fart)
The default timeout (according to the help file) is 15 seconds... that it
should be enough to get access to your DB...
Post by fniles
May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
Are you using "link tables" in MS Access? (Using VB to connect ACCESS and
ACCESS to connect SQL?)
Sorry... I could not make "Connect Timeout" work with OLEDB-JET... :(
Daniel.
Post by fniles
Thank you.
I tried "... ;Connect Timeout=60" (without ";" at the end) and it gave
the same error.
When I do myCnn..ConnectionTimeout = 60 it says "property
ConnectionTimeout is 'Read Only'"
May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
What is the default ConnectionTimeout for MS Access using
OLEDBConnection ?
Thank you.
Post by Daniel E. Ulfe
I am not sure is this has something to do with it... but I thing it
should be: ""... ;Connect Timeout=60;" (note the ";" at the end)...
well... if that does not work... you can try the "ConnectionTimeout"
myCnn.ConnectionString = myConnectionString
myCnn.ConnectionTimeout = 60
myCnn.Open
Hope this helps...
Daniel.
Post by fniles
Can I change the connection time out in VB.Net 2003 and MS Access
(using OLEDbConnection) ?
When I use Connect Timeout = 60 in the connectionstring, I get an error
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done."
Thanks.
ConnectionOLE = New OleDb.OleDbConnection
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDBPath &
";Connect Timeout=60" ???
With ConnectionOLE
.ConnectionString = sPath
.Open() --> error "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done."
Paul Clement
2007-04-18 13:28:13 UTC
Permalink
On Tue, 17 Apr 2007 11:08:37 -0500, "fniles" <***@pfmail.com> wrote:

¤ Thank you.
¤ I tried "... ;Connect Timeout=60" (without ";" at the end) and it gave the
¤ same error.
¤ When I do myCnn..ConnectionTimeout = 60 it says "property ConnectionTimeout
¤ is 'Read Only'"
¤ May be I can set ConnectionTimeout for MS Access (only for SQL Server) ?
¤ What is the default ConnectionTimeout for MS Access using OLEDBConnection ?

The ConnectionTimeout property must be set prior to opening the connection to the database. The
default value is 15.


Paul
~~~~
Microsoft MVP (Visual Basic)
unknown
2007-04-23 13:42:11 UTC
Permalink
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Seconds.



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
unknown
2007-04-23 13:46:56 UTC
Permalink
Hi there,
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Minuts.




EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
unknown
2007-04-23 13:47:52 UTC
Permalink
Hi there,
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Minuts.




EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Loading...