Access Timeout

[Alvin]

When i try to retrieve data using access from SQL server, but I keep getting
the error ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired(#0)
But when i test the ODBC DSN connection. It came out successful.

Please help

 

[Jon Furman]

Have you tried increasing the timeout value? I believe that you'll find it
under Tools>Options>Advanced, tinker with that and see if it helps. Also you
might check the query that you're pulling data with, you may be pulling to
large of a data set. Try querying a smaller data set and see if that works.

Jon

 

[Alvin]

I've tried changing the values like you said but still getting the timeout.
is there any other possible way?

 

[Jon Furman]

No luck huh? Can you pull any data from SQL server? If not maybe there's a
problem with the versionof MDAC you have installed, you may want to get the
latest version and try that. Another thing to check is to make sure that you
have security rights to read from that SQL server database. If you don't
have read rights, Access may allow you to create and test the connection but
SQL server will refuse to send you the data. Just something to check.


Jon

 

[Alvin]

I was able to pull data with another access form from the same mdb file.
There's a total of 2 forms in this file. AP(Acct)Form and AP(Rcpt) form. I
was able to pull data from the rcpt form but not acct form.
so i don't think it has anything to do with the MDAC version.
and since i'm not familiar with Access and SQL, so i don't know what to do

 

[Sergey L]

Hey guys, I'm getting same error! It started happening after I installed
Symantec Antivirus client 9.0 If I restart computer and run it again it works
fine!! I found some Symantec article on that regarding same error message but
different error number
http://service1.symantec.com/SUPPOR...av_ce&dtype=corp&svy=&prev=&miniver=savce_9.0
(copy and paste that link above) However article didn't help even after
reinstalling antivirus and ofcourse Sym. support doesn't know why. Today I
excluded all Access and SQL folders from getting scanned. Will see. Please
let us know if you have similar environment.