R
Randy
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
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