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