-
Timeout Expired
Hi Experts
I'm using MS Access 2007 and have an import link to a view (SQL Server 2000) using ODBC connection. The view contains records more then 100000+ and when i export to excel or text file i do receive below error message.
Error Message:
ODBC -- call failed.
[Microsoft] [ODBC SQL Server Driver] Timeout expired (#0)
I have already tried the below registry editing.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\ODBC -- \ QueryTimeout
Changed the above value to 600 (10 Mins)
The view takes 4min 15 sec at Microsoft SQL Server Management Studio so the above timeout should work.
Please advice where i am going wrong.
Kind Regards
Bhavesh
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules