DSN-Less Connections & Chili ASP

Moving to Chili ASP Struggling to connect my databases

[erisian]

I am trying to move a site from WIN2003 to Chili ASP under Linux on a shared server.

I have exported an (Access) data table to DB5 format but cannot connect to it.
(For now the database file is in public_html)
I have tried various "spellings" for the DBQ and defaultDir values but nothing seems to work, I just get "file not found" errors.

I would really appreciate some help here...

Set MyConnect = Server.CreateObject("ADODB.Connection")
MyConnect.open "Driver={Dbase}; DBQ=/home/mywebsitename/public_html/;defaultDir=/home/mywebsitename/public_html/"
Set MyRset = Server.CreateObject("ADODB.Recordset")
MyQuery = "SELECT * FROM table1.DBF"
MyRset.Open MyQuery, MyConnect