January 27, 2005 at 7:09 pm
Hi all,
I am experiencing an odbc call failed followed a login box typically every few minutes on my program
it seems to occur on queries which update large amounts of data a one time
DAO 3.6 syntax and libraries are being used
Latest mdac installed
winxp professional sp1
sql server 2000 sp3
win2k3 server
the only problem is that trace logs from sql server or odbc only tell me the connection has been dropped, which i know but there doesnt seem to be any reason for it...
anyone have any ideas or a similar issue ??
any one solved this issue or can point me in the right direction
the program is written in access xp format
------------------------------
Life is far too important to be taken seriously
January 30, 2005 at 11:18 am
Please provide some more information about your Access XP program. Are the SQL tables linked? Is it a standard Access progarm (mdb) or an Access Project (adp)? Are you using an Access query to update the data?
Access queries have a default ODBC timeout value of 60 seconds. This can be found by going to design view of the query then going to View --> Properties.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 30, 2005 at 7:52 pm
HI
the SQL tables are linked, it is a standard access program
the query used is an access query
yes i have set the timeout of the query to be greater but this does not solve the issue,
i have tried taking the query and placing it in a stored procedure but the same error occurs
as does also placing wait commands before and after the code...
finally running the program on the server (where SQL is) results in the same error
any other ideas i might try to solve this ?
------------------------------
Life is far too important to be taken seriously
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply