Query Error

  • Thread starter Thread starter Randy Okum
  • Start date Start date
R

Randy Okum

Frontend: Access2000

Backend: SQL 7.0

Connection: ODBC DSN

Database: Gets updated Manually on Monthly basis
from many single Access DB's. Data is just Queried
to update a singe 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
 
Randy

As part of your troubleshooting, have you tried modifying the query to
more-narrowly restrict the results? Do you have the same timeout problem
with any other queries against the back-end?

Good luck

Jeff Boyce
<Access MVP>
 
-----Original Message-----
Randy

As part of your troubleshooting, have you tried modifying the query to
more-narrowly restrict the results? Do you have the same timeout problem
with any other queries against the back-end?

Good luck

Jeff Boyce
<Access MVP>

.
I have tried to take the query and paste it in the query
Click to expand...
analyser on the sql server itself and it runs ok, it took
approx 1min 6sec. I only have four (4) fields selected
for my query.

Randy
 
?! A query (SQL) that takes a minute to run in SQL-Server ?! Sounds like a
monster! Do the lights dim, too?

Which version of SQL-Server? Do you have indexes defined? Consider posting
the SQL here for more feedback.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top