General discussion

Locked

Query Error

By NetGoofy ·
Frontend: Access2000

Backend: SQL 7.0

Connectivity: ODBC DSN

Database: SQL Database gets updated Manually on Monthly basis from many single Access DB's. Data is just Append queried to update a single SQL DB.

Problem: This last month when I updated the SQL Server, all went fine. However, when I run my queries/reports from Access at my workstation (same network 100bt), I get the following messeage!

Message: [Microsoft][ODBC SQL Server Driver]Timeout
expired (#0)

I receive this message exactly 60 seconds after
depressing the run button. I have done a little research so far and found only one situation that is typical to my situation, it was per Microsoft to increase the QueryTimeout=60 to an increase amount of second in the registry, however, this did not work. I set it to 180
seconds but I still get the message after 60 seconds.

Any help is most greatly appreciated.

Thanks Randy

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Query Error

sounds like you think this is related to your updating the sql db? you think it's got too many records to search now or something? how *is* your connectivity to the server, otherwise? sounds slow on sql end. don't know about why you can't get timeout to change (maybe try baby step of 70 secs since so repeatable? just to see if you can affect it at all?) but maybe you can work around for now with optimizing query? stored procedure? what is in sql server event log?

Collapse -

by NetGoofy In reply to

Tried it, did not work. - Sorry, but thank you for your time. I could not find the ultimate solution, so I used Crystal reports to get the data, and it works with great speed, so I am going to continue using this process.

Collapse -

by Curacao_Dejavu In reply to Query Error

I have a feeling you need to do a little maintenance on the database, compact the database and then (re)install sql 7 sp4.

Leopold

Collapse -

by Curacao_Dejavu In reply to

check out this one:
http://tinyurl.com/upvk
or it could be a bug
http://tinyurl.com/upvg


Leopold

Collapse -

by NetGoofy In reply to

Tried it, did not work. - Sorry, but thank you for your time. I could not find the ultimate solution, so I used Crystal reports to get the data, and it works with great speed, so I am going to continue using this process.

Collapse -

by NetGoofy In reply to Query Error

what is in sql server event log?

My connection is faily decent, 100bt both, workstation and server connected to a 100bt cisco switch. Tried the baby step of increasing the QueryTimeout in the registry to 70sec, did not help. Not sure how I can optimize the Query, I am only requesting 4 fields from the table and I am not familiar with stored procedures, so don't know if this is something I ought to be messing with. As for the SQL logs there a no idications of problems, or errors, all logs refer to backing up the databases and are all good logs. Here is more info on the Database:

Database has 1 table 108 fields and is currenly 3.9GBs.

Thanks Randy

Collapse -

by jwhiteman In reply to Query Error

I would first check your ODBC datasource system DSN to see which network library the connection is using. Where I work the preferred network library id TCP/IP. I have found that Microsoft will default to Named Pipes. I would also perform a test connection from the ODBC datasource.

Collapse -

by NetGoofy In reply to

Tried it, did not work. - Sorry, but thank you for your time. I could not find the ultimate solution, so I used Crystal reports to get the data, and it works with great speed, so I am going to continue using this process.

Collapse -

by NetGoofy In reply to Query Error

This question was closed by the author

Back to Networks Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums