Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Trouble Shooting

Buy now

Download now

SQL*XL online help

 

SQL*XL: Timeout problems

Timeout problems.

SQL*XL
home

Timeout problems may occur when running long queries or when a connection is left idle for some time. 

  • Connection Timeouts:
    Usually a timeout parameter can be specified when connecting to the database. This is driver specific:
    • OO4O - Oracle Objects for OLE:
      No timeout can be specified
    • OLE DB:
      A value for timeout can be specified in the Data Link Properties Wizard :
      • Create a new ADO connection
      • The 4 tabbed Data Link Properites Wizard will show
      • In tab 1 choose an OLE DB provider (driver) for your database
      • In tab 2 specify the connection settings
      • In tab 4 specify a value for the General Timeout 
        A value of 0 should indicate that there a timeout will not occur. Another value can be given for the timeout in seconds
    • ODBC:
      A value for timeout can be specified in the Data Link Properties Wizard :
      • Create a new ADO connection
      • The 4 tabbed Data Link Properites Wizard will show
      • In tab 1 choose the Microsoft OLEDB provider for ODBC drivers
      • In tab 2 specify the connection settings
        • select your Data Source Name (DSN) from the dropdown
        • or, create a new connection string
        • When the test button returns successful continue
      • In tab 4 specify a value for the General Timeout 
        A value can be given for the timeout in seconds
  • Query Timeouts:
    When executing a complex query the database may take some time to work out how to get the data. When using ADO connections there is a default timeout of 30 seconds. Through the SQL*XL program parameters you can change this value.

See also:

SQL*XL ribbon in Excel