ODBC Erroor - Timeout

J

JimP

A pass through query runs a stored procedure on a SQL Server db. A second
append query uses the pass hrough query to populate a local table in the
mdb.

1. On one user's pc, both the pass through query and append query run fine.
2. On another user's pc, the pass through query runs fine, but the append
query times out

The SQL Server db and mdb are identical

Any ideas on what could be causing the error?
 
S

Stefan Hoffmann

hi Jim,
1. On one user's pc, both the pass through query and append query run fine.
2. On another user's pc, the pass through query runs fine, but the append
query times out
The SQL Server db and mdb are identical
Any ideas on what could be causing the error?
No. Use the SQL Profiler. Maybe a deadlock...



mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top