tks, Michael I am not sure it's mysql's problem or myODBC351's problem....
But, what I am sure is rs2("data").Value = Now is working fine in mysql323 + myodbc351 but, err in mysql407 + myodbc351 the 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: "jumpmaster" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, December 30, 2002 12:35 AM Subject: Re: ADO Error '800a01fb' > Hi Shih Chiang, > > From what I remember, MySQL 3.23 was OK with MyODBC as well. However, > with 4.06 MyODBC 2.50 AND 3.51 bomb occasionally with this error message. > > > > > At 05:37 PM 12/29/2002 +0800, Chien, Shih Chiang wrote: > > >Dear ALL. > > > >I have the similar problem... > > > >mysql 3.23 + myodbc 3.51 = OK > >mysql 4.07 + myodbc 3.51 = Error > > > >the code list is : > > > >--------------------------------------------------------------------------- - > >------------- > > > > strSQL = "DRIVER={MySQL ODBC 3.51 > >Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35;" > > > > Set Cn1 = CreateObject("ADODB.Connection") > > Cn1.Open strSQL > > strSQL1 = "select * from mytable where pkey = " & 1 > > Set rs2 = CreateObject("ADODB.Recordset") > > rs2.Open strSQL1, Cn1, 1, 3 > > > > If Not rs2.EOF Then > > rs2("data").Value = Now > > rs2.Update ' ############################ Error Line Reported. > >############################## > > End If > > > > rs2.Close > > Cn1.Close > > Set rs2 = Nothing > > Set Cn1 = Nothing > > > >--------------------------------------------------------------------------- - > >------------- > > > >pls see the attached file for more error 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' > > > > > > > Michael, > > > > > > My guess (and this is *only a guess*) -- for some reason one of the > >objects > > > is not being created; maybe the recordset object. I am not sure where you > > > are getting that error number from (presumably in you browser) as you do > >not > > > state it. i suggest that you check your webserver logs if you have access > > > to them. They might have an extended error message which will pinpoint > >your > > > problem. > > > > > > Also, you can try to 'trap' the error. I found this tid-bit on the M$ > > > site... > > > > > > > > > On error resume next > > > .. > > > .. > > > .. > > > Your problem code goes here > > > .. > > > .. > > > .. > > > if err.number <> 0 then > > > Response.Write err.description & "<BR>" & err.source & "<BR>" > > > err.clear > > > end if > > > > > > > > > Here is the link where I found it: > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7 > > > > > > > > > One last note...the reason I think it is your recordset object is because > >of > > > your query...You use single quotes in the wrong place. Your strSQL > >variable > > > should be defined as follows: > > > > > > strSQL = "SELECT * FROM IMAGES WHERE ID = '" & ID & "'" > > > > > > Or - if ID is numeric then: > > > > > > strSQL = "SELECT * FROM IMAGES WHERE ID = " & ID > > > > > > HTH, > > > Kurt > > > > > > -----Original 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 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.Connection") > > > objConn.open strConn > > > > > > set rs = server.createobject("adodb.recordset") > > > strSQL = "SELECT * FROM IMAGES WHERE `ID` = " & ID > > > rs.open strSQL, objConn, 3,1,1 > > > > > > Nothing out of the ordinary... anyone know why I'm getting this error? > > > Thanks! > > > -- > > > Michael She : [EMAIL PROTECTED] > > > Mobile : (519) 589-7309 > > > WWW Homepage : http://www.binaryio.com/ > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/products/myodbc/manual_toc.html (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe from Yahoo! Groups version, e-mail > > > [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/products/myodbc/manual_toc.html (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe from Yahoo! Groups version, e-mail > >[EMAIL PROTECTED] > > > > > > > > -- > Michael She : [EMAIL PROTECTED] > Mobile : (519) 589-7309 > WWW Homepage : http://www.binaryio.com/ > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php