Viewing 6 posts - 1 through 7 (of 7 total)
I dont have query longer then 60 sec., this query have more jons but runs in 20-30 secs, but some time the query stop and after 60-70 seconds the error...
February 25, 2011 at 2:05 pm
no not always, you can launch the same long query well for three times and then the 4th time fails
February 25, 2011 at 1:51 pm
Same problem on win7 or winXP on sql2000 or sql2005, with office access 2003 or 2007 or 2010.... could be a odbc client driver problem.. I dont know what think...
February 25, 2011 at 1:47 pm
yes but not always, if you run&close&run the query for 3-4 times the query runs well then the next time stops and after 60secs the error. This on different clients...
February 25, 2011 at 1:43 pm
Thanks David for this brainstorm, no, under odbc data sources I've created a dsn file configuration using SQL Server driver (on DSN driver definition I don't see an timeout setting),...
February 25, 2011 at 1:24 pm
Yes, in my Access query (on SQL view) I set the odbc timeout to 0 and then in ODBC.INI registy key and in Access Settings options too. Then I trayed...
February 25, 2011 at 11:15 am
Viewing 6 posts - 1 through 7 (of 7 total)