OLEDB connection

[Former Member]

Hi all,

Anybody knows the behaviour of the property "TimeOut" in the database profile setup for OLEDB connections ? What does the empty value means (see attached file) ?  What would be an appropiate value in order to setup a SQLCA object a bit more fault tolerant ?

We have a client with some cable/switches/nic problems and our app disconnects 2 o 3 times every day.

Any help would be appreciated

Best regards

________________

AUS Julián Tagarro

NeoSistemas SRL

[Former Member]

Hi Chris and Ted,

Thanks for your answers.

We are working with SQLServer. I forgot to mention that in my original post. I've already check the documentation provided in the Help button but I didn't find it very useful.

What do you mean by connection time ? If the PC disconnects from the network for an eventual network problem SQLCA keeps trying to reconnect for 30 seconds ? How can Command Timeout help to make SQLCA less sentive to problems ?

We want to help our customer while they fix their infraestructure problems. They get "[DBNETLIB][ConnectionWrite (send()).]General network error" and "SQLSTATE = 08S01 Microsoft OLE DB Provider for SQL Server Connection Failure" all the time, so they ask us if we can make the DB connection a bit more fault tolerant.

Thanks again

________________

AUS Julián Tagarro

NeoSistemas SRL

[Former Member]

Hi  Julián ;

Q1:  What do you mean by connection time ?

A1:  When processing the Connect Using SQLCA command

Q2: If the PC disconnects from the network for an eventual network problem SQLCA keeps trying to reconnect for 30 seconds?

A2: Yes, or for what ever the TIMEOUT=nnn value is.

Q3: How can Command Timeout help to make SQLCA less sensitive to problems ?

A3:  Your error is a connection one - so the command timeout is not applicable in this case.

Regards ... Chris

PS; I think that you can also change the default timeout in SQLServer via an SP_Configure ... for example:

No Timeout:     EXEC sp_configure 'remote query timeout', 0 ;

5M Timeout:    EXEC sp_configure 'remote query timeout', 300 ;

[Former Member]

Thanks Chris. I will give it a try.

Best regards

________________

AUS Julián Tagarro

NeoSistemas SRL

[Former Member]

Hi  Julián;

  The default value is driver specific and applies to the connection time. So for example in SQLServer, if you do not specify the TIMEOUT=nnn value it defaults to 30 seconds, for Access its 15 seconds, etc

  Note that you can also specify a Command timeout as well.

Regards ... Chris

[Former Member]

Hi Julian,
The following is from the documentation:

Timeout database parameter
Description

Specifies the number of seconds the interface should wait for a connection to
the data provider to complete.

If you click on the Help button from the picture you provided and follow the links it will take you to the exact page in the documentation.

HTH

Ted Zimmerman