Connect to Access Database

[awieds]

I am using Dreamweaver MX and an Access 2002 database. I have already created the tables and I need to connect. For some reason I am having difficulty connecting. Can anyone help me out?
I created a connection string but when I test I get the following error:
If I select Using driver on this machine, I get the error 'Could not find installabla ISAM'
If I select Using driver on testing server then I get the error: '1)There is no testing server running on the server machine. 2) The testing server specified for this site does not map to the http://localhost/_mmserverscripts/MMHTTPDB.asp URL. Verify that the URL prefix maps to the root of the site.'
I really don't understand but I need to get this running. Csn someone help me out?
Thanks

[awieds]

Ok, I got my database to connect when I hit test. But that is only locally. Hoe do I connect to it on the server?

Thanks

[awieds]

Ok, I got it to work. When I did a simple query the connection works and everything is fine. However I ran the following query:
"SELECT ContentsOfBox.*, ProductDescription.*, ProductFeatures.*, Title.*, Products.ProductID FROM (((Products INNER JOIN ContentsOfBox ON Products.ProductID = ContentsOfBox.ProductID) INNER JOIN ProductDescription ON Products.ProductID = ProductDescription.ProductID) INNER JOIN ProductFeatures ON Products.ProductID = ProductFeatures.ProductID) INNER JOIN Title ON Products.ProductID = Title.ProductID WHERE (((Products.ProductID)=1))"

When I run the query is Access it is fine. However when I run it from my asp code my recordset is empty.
ANy suggestions?
Thanks

[sde]

it would probably do you better if you posted the related asp code. i'm gonna go ahead and move this to the asp forum.

rdove is our asp expert around here .. hopefully he'll stop by

[awieds]

The following is my asp code. It works fine on one page.

sub GetData(prod)
strQuery="Select * from contentsofbox where productid=" & prod
rs.Open strQuery, MM_myConn_STRING, 0, 2 ,1
contentDesc=rs("Description")
contentInc=rs("Includes")
UtWt=rs("UnitWeight")
UtPckg=rs("UnitPckg")
colors=rs("colors")
pckgDetails=rs("Packaging")
rs.close()
Set rs = Nothing
end sub


It works fine on one page (I pass 1 as prod). The I use it on another page where I pass 10 as prod. I am getting an error either BOF or EOF is true for
contentDesc=rs("Description")

However when I run the query in Access query builder it works fine and it returns data! So the rs can't be empty. What am I doing wrong?
Thanks!