I had similar problems, all of which were unexplainable (sometimes even just "OLEDB Error. There was an error.")
I would just use an ODBC DSN, as I have not seen any proof that OLEDB is faster (and have posted several threads on this list with no outcome - as well as benchmarks that proved that they are about the same). HTH. -----Original Message----- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 10:27 PM To: CF-Talk Subject: OLEDB Error Code = 18456 I am using OLEDB data connections SQL 2000 SP2 - CF 5 (no service packs) Win 2K Sp 2. I have just recently started getting a string of odd data connection errors OLEDB Error Code = 18456 Login failed for user 'sa' (userame is not relevant have tried different users - defaulted back to SA to see if was a permission issue) I have started seeing this sporadically on my CF servers - you can actually get the error and hit refresh and everything is fine. The login's are valid - the network connection is good. I upgraded to MDAC 2.7 RTM - didn't help (was at 2.5) Anyone else have this problem at all? Thanks. ______________________________________________________________________ Get Your Own 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=coldfusionb 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
