In my experience here with multiple clients on our hosting servers I have from time to time found that quite often for some reason DSNs just get somehow corrupted- and give out oledb errors what make little or no sence in relation to the request made of them I have found that re- nameing and recreating the DSN in ALL these cases has solved the issue. And those clients never had a repeat of the same errors.
-----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 30 July 2003 09:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed Why? > -----Original Message----- > From: Paul fennell [mailto:[EMAIL PROTECTED] > Sent: 29 July 2003 18:36 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > Just the DSN > recreate it - > > > ----- Original Message ----- > From: "Steve Martin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, July 29, 2003 6:28 PM > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > Like I said, it's intermittent. It can happen on any template > and refreshing > the page causes it to work again. It does return the correct > user in the > error i.e. "Incorrect login for user $USER". > > fdisk? > > > -----Original Message----- > > From: Paul Fennell [mailto:[EMAIL PROTECTED] > > Sent: 29 July 2003 12:45 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > :) bleh > > > > OK I take it its returning the correct user in the error > for the db ! > > What type db is it - might be worth checking the user has all the > > correct permissions > > For the tables/etc it's trying to access. > > Is it any or all scripts or just a handful if it’s a few it might be > > permissions on that table- > > If its totally random then I suggest you delete the dsn and > > recreate it > > . > > > > -Paul > > > > -----Original Message----- > > From: Steve Martin [mailto:[EMAIL PROTECTED] > > Sent: 29 July 2003 12:38 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > 1) Nope > > 2) Nope, and not relevant. It's an OLEDB error. The > username & pwd are > > set in the CF admin so my CF scripts have no part in passing the > > credentials through. > > 3) The server isn't restarting. > > > > Meh! > > > > > > > -----Original Message----- > > > From: Paul Fennell [mailto:[EMAIL PROTECTED] > > > Sent: 29 July 2003 12:27 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > > > > 1 ) check to see if you have any other application.cfm > > files in your > > > application that may have matching var names ... > > > > > > 2) Are you locking your application vars in a time lock > eg > > > <cflock scope="application" timeout="10" type="EXCLUSIVE"> etc ? > > > > > > 3) Check your apps logs to see if its your cf server > > > restarting after a > > > query timeout reboot > > > > > > - Paul > > > > > > > > > -----Original Message----- > > > From: Steve Martin [mailto:[EMAIL PROTECTED] > > > Sent: 29 July 2003 12:20 > > > To: [EMAIL PROTECTED] > > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > Nope. The clue was in the words "intermittent error". > Thanks anyway. > > > Anyone else? > > > > > > Steve > > > > > > > -----Original Message----- > > > > From: Matt Horn [mailto:[EMAIL PROTECTED] > > > > Sent: 29 July 2003 12:17 > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > > > > > > > Sounds like you have not specified the correct username and > > > > password for > > > > your DB in the Datasource page > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Steve Martin" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Tuesday, July 29, 2003 1:15 PM > > > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > > > > > > > No, that doesn't answer my question at all. > > > > > > > > <eyes light up at a response and suddenly extinguished upon > > > > examination of > > > > content> ;-) > > > > > > > > > -----Original Message----- > > > > > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > > > > > Sent: 29 July 2003 12:13 > > > > > To: [EMAIL PROTECTED] > > > > > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > > > > > > > > > > > Hi > > > > > > > > > > Does anyone have a similar regex/udf which validates all > > > > > valid Euro date > > > > > formats? Had a butchers on cflib.org but couldn't find one. > > > > > > > > > > Thanks > > > > > > > > > > Kola > > > > > > > > > > >> -----Original Message----- > > > > > >> From: Steve Martin [mailto:[EMAIL PROTECTED] > > > > > >> Sent: 28 July 2003 14:46 > > > > > >> To: [EMAIL PROTECTED] > > > > > >> Subject: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > > > >> > > > > > >> Anyone, I'm trying to troubleshoot an intermittent error > > > > > which occurs > > > > > >> over a cross section of sites. Every now and then > we get the > > > > > following > > > > > >> error, a page refresh however results in proper > functioning. > > > > > >> > > > > > >> OLEDB Error Code = 18456; Login failed > > > > > >> > > > > > >> Steve > > > > > >> > > > > > >> -- > > > > > >> ** Archive: > > > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > >> > > > > > >> To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > > >> For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > >> For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > -- > > > > > ** Archive: > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > -- > > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 > > > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
