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?
Click to expand...
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

Similar Threads

ODBC Timeout Error 0
ODBC Timeout Error 1
Pass Through Queries (Access 2002) 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Displaying pass through query 1
Progress Meter 8
Append Passthrough Query Results to Local Table 2
Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1

Top