Yes, it is checked. Thanks for giving me something to try. Were you getting similar errors?
Thanks, Jamie On Thu, 14 Feb 2002 17:56:30 -0500, "Thomas Muck" <[EMAIL PROTECTED]> wrote: >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
