Is "maintain database connections" checked for that datasource in the administrator? I've found that when that box is checked, I get intermittent errors.
tom "Jamie Jackson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > My CF (OLEDB) connection to MSSQL is failing intermittently, and I > can't recreate the problem. I have even looped a query 10,000 times > with 100% success. > > Every once in a while, maybe 1/1000 times, a user will generate the > attached error (I'm catching the error and mailing it to myself). > > I'm running CF5 and MSSQL 2000, and connecting via OLEDB. I'll provide > more information if necessary... > > Thanks, > Jamie > > CFTry/CFCatch Variables > DETAIL > > ERRORCODE 42000 > EXTENDEDINFO > MESSAGE OLEDB Error Code = 18456 > Login failed for user 'myUserName'. > (^ this error stinks because I lose the user's SQL) > > NATIVEERRORCODE 18456 > SQLSTATE 42000 > TAGCONTEXT > TYPE DATABASE > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
