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