Is it possible to change default OLEDB connection timeout value? Run-time error (80040e31)

sql-server vba oledb connection-timeout
Andrey Morozov picture Andrey Morozov · Jul 25, 2013 · Viewed 36.1k times · Source

I have one legacy app (VB) and I have an issue with the timeout error while connecting to SQL Server (probably through OLEDB).

enter image description here

Using SQL Profiler I figure out that the connection is dropped through exactly 30 seconds.

enter image description here

I don't have access to the source codes but I scanned exe resources and couldn't find any hardcoded connection string timeout values there.

The last chance I think I have is to change the default OLEDB timeout somewhere outside the app.

My question is: it is possible to change default OLEDB timeout value?

UPDATE

I found the connection string and changed timeout to 300 but it does not help...

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=______;Password=______;Initial Catalog=________;Data Source=______;Connect Timeout=300

After that I tried to replace current connection string with connection strings from different providers: ADO.NET and ODBC but every time I get an timeout error after 30 seconds - checkmate.

P.S.

I'll be happy to any advice

Answer

SMA picture SMA · Oct 30, 2013

Connect timeout is the limit of time to connect to the server, not to execute a command, so setting it will not help at all

Related questions

Requested operation requires an OLE DB Session object... - Connecting Excel to SQL server via ADO

I'm attempting to take Excel 2003 and connect it to SQL Server 2000 to run a few dynamicly generated SQL Queries which ultimately filling certain cells. I'm attempting to do this via VBA via ADO (I've tried 2.8 to 2.0) but I'm getting an …

Read More
MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers]. Also I have a …

Read More
How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?

When I create a DSN connection to SQL Server using the wizard, I am able to link it to a view. In this case, Access recognizes it as an editable table. But if I use a DSN-less connection to a …

Read More