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 Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: ADO Error '800a01fb'
I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ADO Error '800a01fb'
Chiang, I can't seem to pinpoint where the problem lies, but I don't think the .value should be there...you may want to try this: If Not rs2.EOF Then rs2(data) = Now rs2.Update End If Why go through all the trouble of creating a recordset to update a value? It adds quite abit of overhead...you can use the connection object to accomplish the same. Try this: 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 = UPDATE mytable SET data = ' Now() ' WHERE pkey = 1 Cn1.Execute(strSQL1) Of course, by changing the strSQL1 statement, you can Add and Delete records from the database also. HTH, Kurt -Original 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 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] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com
Re: ADO Error '800a01fb'
Hi, From what i know i think is possible if you declare(like METADATA) this object(using UUID). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
Re: ADO Error '800a01fb'
Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: ADO Error '800a01fb'
I have heard of cases where there were some problems with MDAC and that it helped to reinstall the latest version Otherwise try to troubleshoot with something like : 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 I also think you should remove the ' from the ID in your SQL query. If the ID field is not numeric it should be ...WHERE ID = ' ID ' 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: ADO Error '800a01fb' Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: ADO Error '800a01fb'
I have heard of cases where there were some problems with MDAC and that it helped to reinstall the latest version I also think you should remove the ' from the ID in your SQL query. If the ID field is not numeric it should be ...WHERE ID = ' ID ' 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: ADO Error '800a01fb' Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ADO Error '800a01fb'
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
Re: AW: ADO Error '800a01fb'
The ' is actually a ` (under the Tilda). It's a used to quote column names in MySQL. As for trapping the error... I don't think it'll do much good since the err.description and err.source are already displayed by ASP, which is just simply: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 : ( At 05:53 PM 12/29/2002 +0100, Freddie Sorensen wrote: I have heard of cases where there were some problems with MDAC and that it helped to reinstall the latest version I also think you should remove the ' from the ID in your SQL query. If the ID field is not numeric it should be ...WHERE ID = ' ID ' 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: ADO Error '800a01fb' Line 45 is the Recordset open. I've checked the connection object beforehand to ensure it is connected properly. What is odd is that the error shows up occasionally - every 10 - 15 database queries. If I reboot my server, the error goes away, but comes back after a few days. At 02:43 PM 12/29/2002 +0200, Gelu Gogancea wrote: I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 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 _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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/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
Re: ADO Error '800a01fb'
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 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. -- 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ADO Error '800a01fb'
Hi, For sure all this happend because of MYODBC.This automation error can occur when OLE is not able to handled some data/pointers or pointers to interfaceses which must be transfered to VB,VBA,VBS...etc. For example : if you wish to transform some char* to UNICODE and in the new UNICODE data is not exist NULL termination string, this error occur.This case are happens very frequently in Windows,especially when OS remain without memory resources. In fact is an access violation error, but because error is raised in .dll, VB* doesn't know for what reason this error occur.And in this case err.description or err.number is no sens(or maybe for bug trapping). For sure is not need to restart MYSQL server.Try to reset the client connection/process. Hope it's help Regards, Gelu --- Chien, Shih Chiang [EMAIL PROTECTED] wrote: 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
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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php