DSN-less connection headache!

Hi,



Have been used to using DSN connections all these years. Now fasthosts has moved one of my sites and says it must have a DSN-less connection. I have tried and tried but am just getting "500 - Server error" with no more detail.



I'm trying to connect to an Access dBase using ASP VB Script. My dBase is in the root of the server in a folder called /database.



Fasthosts gave me a path to follow (E:\Domains\e\everythingforthechef.com-19969252\user\) and I have tried



<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_eftc_STRING
MM_eftc_STRING = Server.MapPath("E:\Domains\e\everythingforthechef.com-19969252\user\d atabase\chef.mdb")
%>



and





<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_eftc_STRING
MM_eftc_STRING = Server.MapPath("database\chef.mdb")
%>



to no avail.



have tried both using the code in thge page and as an includes.



Could anyone shed any light at all as I am cdesperate to connect and FastHosts wont support the issue.



Thanks in advance

server.mappath is used to get the os path to the database, in other words, convert:
database\chef.mdb

to:
E:\Domains\e\everythingforthechef. com-19969252\user\database\chef.mdb

so since you have the fuill path:
E:\Domains\e\everythingforthechef. com-19969252\user\database\chef.mdb

you dont need to use the server.mappath method.


In a dsnless connection, though, you need to also specify the driver that will be used.

the format of the connection string needs follow the following rules:
Provider=<DriverName>;Data Source=<path to database"


change:
MM_eftc_STRING = Server.MapPath("E:\Domains\e\everythingforthechef. com-19969252\user\d atabase\chef.mdb")

to:

MM_eftc_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Domains\e\everythingforthechef.com-19969252\user\database\chef.mdb"