Skip to Content
author's profile photo Former Member
Former Member

OLEDB connection

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

oledb.jpg (52.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2014 at 06:38 PM


    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2014 at 06:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2014 at 07:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.