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