Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-20 : 08:23:21
|
| Ludo writes "I use MS Access to connect to a SQL 2000 Server database.I try to run a query that reads rows from the SQL database and writes them into the Access database.All runs on one and the same machine.I get an error as follows :ODBC--call failed[Microsoft][ODBC SQL Server Driver] TImeout expired (#0)Any suggestions ?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-20 : 14:35:23
|
| What is your query?Tara |
 |
|
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
Posted - 2004-10-05 : 13:35:13
|
| Ludo, I have the same problem. Although I have not found an answer that works everytime, I have found that limiting the data pulled, by setting up simple views has helped work around that problem. A view is just like and Access query. Let me know if you need additional assistance with this.*************************Got some code from Rob. Can anyone help? |
|
|
|
|
|
|
ODBC call failes - Timeout expired (#0)