SQL*XL: Timeout problems

Timeout problems.

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.