 |
26-Oct-2005, 16:09 PM
|  | Guest | | | | | | | | | | Timeout executing query including ODBC-linked SQL Servertables
I receive the "Timeout expired" message after 60 seconds, when the
dateinterval that is a part of the query is to large. Therefore I'd
like to increase the timeout value to say 600 seconds.
I've read the threads that explains how to solve the timeoutproblem
when calling stored procedures by changing the value of
"commandtimeout", but this is not usable for me since I'm just running
a query consisting of 4 linked tables.
The connection string used during link is:
ODBC;DRIVER=SQL
Server;SERVER= ;UID=;PWD=;APP=Microsoft®
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/5821-timeout-executing-query-including-odbc-linked.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
Access;DATABASE=;Network=DBMSSOCN;
Any ideas?
Thanks in advance
Best regards
Søren Horney
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh! |
26-Oct-2005, 16:54 PM
| | Guest | | | | | | | | | | Re: Timeout executing query including ODBC-linked SQL Servertables
Are you saying that you've got 4 tables linked to tables in SQL Server, and
you're trying to join them in your front-end?
Create a view on the server!
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Sogge" wrote in message
news:1130319318.899151.132020@o13g2000cwo.googlegr oups.com...
I receive the "Timeout expired" message after 60 seconds, when the
dateinterval that is a part of the query is to large. Therefore I'd
like to increase the timeout value to say 600 seconds.
I've read the threads that explains how to solve the timeoutproblem
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
when calling stored procedures by changing the value of
"commandtimeout", but this is not usable for me since I'm just running
a query consisting of 4 linked tables.
The connection string used during link is:
ODBC;DRIVER=SQL
Server;SERVER=;UID=;PWD=;APP=Microsoft®
Access;DATABASE=;Network=DBMSSOCN;
Any ideas?
Thanks in advance
Best regards
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
Søren Horney
 |
26-Oct-2005, 17:53 PM
| | Guest | | | | | | | | | | Re: Timeout executing query including ODBC-linked SQL Servertables
Thx Douglas for a quick reply - I'll ask our DB-manager to make a view!
However IF I still need to alter the default timeout of 60 seconds - Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
how is this done?
Best Regards
Søren |
27-Oct-2005, 08:58 AM
| | Guest | | | | | | | | | | Re: Timeout executing query including ODBC-linked SQL Servertables
To be honest, I'm not sure there is a way for linked tables. I'm not sure
what's on the Advanced tab under Tools | Options has anything.
Do you need to be able to update the resultant recordset? If not, what you
can do is create a pass-through query that joins the 4 tables. You can set
the ODBC TImeout for pass-through queries (and it would eliminate the need
for a view to be created)
Sorry I can't be of more help, but I seldom use ODBC-linked tables: I use
pass-through queries, and unbound forms. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Sogge" wrote in message
news:1130324559.921849.156640@g43g2000cwa.googlegr oups.com...
Thx Douglas for a quick reply - I'll ask our DB-manager to make a view!
However IF I still need to alter the default timeout of 60 seconds -
how is this done?
Best Regards
Søren
|
27-Oct-2005, 08:58 AM
| | Guest | | | | | | | | | | Re: Timeout executing query including ODBC-linked SQL Servertables
Thx again Douglas, I've now managed to make a Pass-Through query, but
how exactly do I set the "ODBC TImeout for pass-through queries" - it's
not in the Tools-Settings-Advanced tab!?
Best regards
Søren Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821 |
27-Oct-2005, 08:58 AM
| | Guest | | | | | | | | | | Re: Timeout executing query including ODBC-linked SQL Servertables
When you create a Pass-Through Query, Access default the TimeOut Interval to
60 secs. However, you can change it if necessary.
Open the Pass-Through Query in SQL View. Open the Properties window of the
Query using the icon with the left-pointing figer on a list or the Menu View Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
/ Properties or the function key F4) and you should see the ODBC Timeout Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5821
Property of the Pass-Through Query.
--
HTH
Van T. Dinh
MVP (Access)
"Sogge" wrote in message
news:1130338142.912172.233550@z14g2000cwz.googlegr oups.com...
Thx again Douglas, I've now managed to make a Pass-Through query, but
how exactly do I set the "ODBC TImeout for pass-through queries" - it's
not in the Tools-Settings-Advanced tab!?
Best regards
Søren
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | Panjabi Today 02:27 AM 11 Replies, 232 Views | | | | | | | | | | » Books You Should Read... | | | |
Søren
