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
