I'm trying to connect to a database on a remote server, using ASP Javascript but everytime I test the connection string I get "An unidentified error has occurred"
The Custom connection string I am using is
"Driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\web\torrevieja-vermietungen\alquileres.mdb"
but I keep getting the same error.
I checked the Macromedia site for help but all it says is that is a PHP related problem, but the document type is set to ASP JavaScript.
Can anyone help me?
I think it has to be a problem on the server but I have to make sure si I can tell them.
Thank you

Edited by - DarkKave on 11 Nov 2002 15:45:36

Hi DarkKave,

this code is not going to work.
You should use the Jet-provider.
Here is an example. (Be sure to update the path to your db-file.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connvkz_STRING
MM_connvkz_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Kolibri\db\vkz.mdb;Persist Security Info=False"
%>

Succes,
Tjerk Heringa

I tried it but I still keep getting the message "an unidentified error has occurred" whenever I try to test the connection.
Here is what my code looks like now:
<%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
Dim MM_conn2_STRING
MM_conn2_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\WEB\torrevieja-vermietungen\alquileres.mdb;Persist Security Info=False"
%>

Any suggestions?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi DarkKave,

this code is not going to work.
You should use the Jet-provider.
Here is an example. (Be sure to update the path to your db-file.

&lt;%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connvkz_STRING
MM_connvkz_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Kolibri\db\vkz.mdb;Persist Security Info=False"
%&gt;

Succes,
Tjerk Heringa
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I solved this like that : for me it was because my browser worked off-line. I unchecked that and everything works fine...
hope it helps..