Re: ADO Error '800a01fb'

2002-12-29 Thread ggelu
err msg in msgbox: Query-based update failed because the row to update > could not be found. > > > > > > - Original Message - > From: "Michael She" <[EMAIL PROTECTED]> > To: "Chien, Shih Chiang" <[EMAIL PROTECTED]> > Cc: &

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She
Hi, Have you tried passing a string value of the date? MySQL accepts dates in -MM-DD format instead of Microsoft's standard value... maybe it'll work if you concatanate the values manually? It's a wild guess : ) At 01:24 AM 12/30/2002 +0800, Chien, Shih Chiang wrote: tks, Michael I a

Re: AW: ADO Error '800a01fb'

2002-12-29 Thread Michael She
ael She [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 17:39 An: Gelu Gogancea Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is

Re: ADO Error '800a01fb'

2002-12-29 Thread Chien, Shih Chiang
update could not be found. - Original Message - From: "Michael She" <[EMAIL PROTECTED]> To: "Chien, Shih Chiang" <[EMAIL PROTECTED]> Cc: "jumpmaster" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Mo

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen
'" If it is numeric it should be "...WHERE ID = " & ID Hth Freddie -Ursprüngliche Nachricht- Von: Michael She [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 17:39 An: Gelu Gogancea Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: AD

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen
quot;...WHERE ID = " & ID Hth Freddie -Ursprüngliche Nachricht- Von: Michael She [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 17:39 An: Gelu Gogancea Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Line 45

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She
ember 2002 12:02 An: [EMAIL PROTECTED]; Michael She Cc: [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu ___

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She
or msg... tks. Chiang - Original Message - From: "jumpmaster" <[EMAIL PROTECTED]> To: "Michael She" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 29, 2002 7:39 AM Subject: RE: ADO Error '800a01fb&

Re: ADO Error '800a01fb'

2002-12-29 Thread Gelu Gogancea
TED] - Original Message - From: "Freddie Sorensen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 29, 2002 1:35 PM Subject: AW: ADO Error '800a01fb' I don't think so since there is no other way to create an

RE: ADO Error '800a01fb'

2002-12-29 Thread jumpmaster
l Message- From: Chien, Shih Chiang [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:37 AM To: jumpmaster; Michael She; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: ADO Error '800a01fb' Dear ALL. I have th

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen
chael She Cc: [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY P

Re: ADO Error '800a01fb'

2002-12-29 Thread Gelu Gogancea
] [EMAIL PROTECTED] - Original Message - From: "Michael She" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, December 28, 2002 7:57 AM Subject: ADO Error '800a01fb' > Hi all, > > I'm getting

RE: ADO Error '800a01fb'

2002-12-28 Thread jumpmaster
nal Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 6:57 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft

ADO Error '800a01fb'

2002-12-27 Thread Michael She
Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = "DSN=binaryio;" Set objConn = Server.CreateObject("ADODB.Con