dsn-less connections on hosting

Hi,

In the past Ive had lost of success using Dreamweaver 8 to create dsn-less conections on a remote testing server. It has always been a Windows server.

Recently i have been looking at creating a simple blog page for a friend using an Access database on his web hosting on a Linux server using ASP VBScript.

It is virtual hosting so all the pages have to be FTPd to a directory called "web" Im sure I have setup my site definitions correctly locally and on the testing server. However after editing my custom connection string and clicking the test key I cannot establish a connection.

The connection string I am using is similar to the following

"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("\DBPath\db.mdb")

I commonly get error message 500 "Unknown server Error" after pressing the test button.

Im pretty sure the connection string is correct and its something to do with the fact its on virtual hosting (but i did think using Server.Mappath would handle that) or its because its a Linux server.

Any points in the right direction would be most appreciated! "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("\DBPath\db.mdb")