By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Can I change the connection time out for MS Access (using OLEDbConnection) ?

P: n/a
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."
Apr 17 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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.

"fniles" <fn****@pfmail.comwrote in message
news:Op*************@TK2MSFTNGP05.phx.gbl...
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."


Apr 17 '07 #2

P: n/a
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.

"Daniel E. Ulfe" <no*****@noserver.orgwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>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.

"fniles" <fn****@pfmail.comwrote in message
news:Op*************@TK2MSFTNGP05.phx.gbl...
>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."



Apr 17 '07 #3

P: n/a
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...
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.

"fniles" <fn****@pfmail.comwrote in message
news:uP**************@TK2MSFTNGP05.phx.gbl...
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.

"Daniel E. Ulfe" <no*****@noserver.orgwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>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.

"fniles" <fn****@pfmail.comwrote in message
news:Op*************@TK2MSFTNGP05.phx.gbl...
>>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."




Apr 17 '07 #4

P: n/a
On Tue, 17 Apr 2007 11:08:37 -0500, "fniles" <fn****@pfmail.comwrote:

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)
Apr 18 '07 #5

P: n/a
Thank you.
No, I am not using "link tables" in Access.

"Daniel E. Ulfe" <no*****@noserver.orgwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
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...
>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.

"fniles" <fn****@pfmail.comwrote in message
news:uP**************@TK2MSFTNGP05.phx.gbl...
>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.

"Daniel E. Ulfe" <no*****@noserver.orgwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>>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.

"fniles" <fn****@pfmail.comwrote in message
news:Op*************@TK2MSFTNGP05.phx.gbl...
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."




Apr 18 '07 #6

P: n/a
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Seconds.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Apr 23 '07 #7

P: n/a
Hi there,
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Minuts.


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Apr 23 '07 #8

P: n/a
Hi there,
Default ConnectionTimeout for MS Access using OLEDBConnection is 15 Minuts.


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Apr 23 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.