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
