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

Question

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

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

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 1

There is property called "Connect Timeout". You can add this property to the connection string available in your application.

Below is the sample connection string with user specified timeout value: (Note: Connect Timeout value is always in seconds)

connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=sa;Password=tiger;Connect Timeout=200"