Newbie question: "Object Required"

[gianna]

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)

Microsoft VBScript runtime  error '800a01a8'
Object required: ''
/pixel8labs.com-asp//gianna/tarot/index.asp, line 77

Here is the relevant code:

' 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 %>

	<div class="card">
	<% Response.Write(rsTarotData("image").Value) %>
	</div>

	<% rsTarotData.MoveNext 
	Loop
Else
	Response.Write("No records returned.") 
End If %>

My db interface is cut-and-pasted from a ASP faq so I'm assuming it's correct... I hope someone can help!

Gianna

[Thing]

Your query looks ok so it is your db connection string adoDataConn. Post the code where you set that variable.

[gianna]

Here you go. Thanks for taking a look...

strConnection = "driver={MySQL};server=domain.com;uid=username;
pwd=password;database=database" 

Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection