yes.. makes teh world so much fun :/ ----- Original Message ----- From: "Steve Martin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 10:05 AM Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed
Fair play. I'll give it a shot. Don't you just love the randomness of completely deterministic machines? ;-) > -----Original Message----- > From: Paul Fennell [mailto:[EMAIL PROTECTED] > Sent: 30 July 2003 09:28 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OLEDB Error Code = 18456; Login failed > > > 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] > > -- ** 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]
