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