issues connecting to an access DB with DW MX

[calidude]

I have been having an issue trying to connect via DSN to an access DB. I noticed that when I watch the FTP log it tries to access some file in the _mmServerScripts and the response is The system cannot find the file specified. then it give an HTTP Error Code 500 Internal Server Error. I have asked the admin of my hosting server but he says all is set up correctly. Anyone else ever have an issue like this?

Thanks
Bob

 

[ChrisHirst]

use the steps here faq333-5427 to show the actual error.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[danblack30]

First turn off friendly error messages

I use mappath for nondsn like this

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connclassifiednondsnserv_STRING
MM_connclassifiednondsnserv_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("classified_ads.mdb")
%>
if your database is in the same folder, if not change the path to your database ("yourdatabse.mdb")

and for dsn
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_conndvd_STRING
MM_conndvd_STRING = "dsn=dvd.mdb;"
%>
just set your odbc.

I prefer the mappath, faster conection easier to setup