Hi there, I'm writing my first ASP-coded page and I'm getting an error I don't know how to fix. I know it's a fairly common one that can be caused by a number of things, and I figure it's pretty simple... but I don't know what's causing it.
The page worked fine before I tried to make a connection to a MySQL db and pull out all the records. The connection itself is OK, I think (at least it didn't cause any errors)
Here is the relevant code:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pixel8labs.com-asp//gianna/tarot/index.asp, line 77
My db interface is cut-and-pasted from a ASP faq so I'm assuming it's correct... I hope someone can help!
' Pull selected records from the database
strQuery = "SELECT * FROM tarot"
Set rsTarotData =adoDataConn.Execute(strQuery) <--- line 77
If Not rsTarotData.BOF Then
Do While Not rsTarotData.EOF %>
<% Response.Write(rsTarotData("image").Value) %>
Response.Write("No records returned.")
End If %>