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
