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
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.
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
