
October 4th, 2004, 01:29 PM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
losing connection after server has been running a while
ok... i have a coldfusion application that runs on a win2k server with an odbc connection to db2 running on an as/400. everything was up and running fine. all the queries are correct, no errors, working fine.
then i start getting errors that i can't explain. like this one:
ODBC Error Code = 37000 (Syntax error or access violation)
[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0010 - String constant beginning '/simplic' not delimited.
i have tried recreating the datasource. same problem. if i restart the coldfusion application server in the services control panel in windows then everything starts working perfectly again. sometimes it will go for several days with no problem, sometimes only a coupla hours.
any help greatly appreciated
|