Going from system DSN to DSN-less connection
Hello,
This is my first time developing a dynamic site. I'm working with Dreamweaver MX, using ASP and VBScript, and a Microsoft Access database. I was working with a local server using a system DSN and everything was working well. But now I'm trying to host this website in a remote server, to which I have no physical access, and do not know the full path of my "root folder". So I went back to Dreamweaver, thinking it would be really easy to change to a DSN-less connection by simply edditing the Connections file... here problems begin.
My connection string looks like this:
"Provider=Microsoft.Jet.OLEDB.4.0;Driver={Microsoft Access Driver(*.mdb)}; Data Source =" & Server.MapPath("\db\db2.mdb") & "UserID=;Password=;"
My connection file (connEIN.asp, included in all my asp files) looks like this right now:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connEIN_STRING
MM_connEIN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Driver={Microsoft Access Driver(*.mdb)}; Data Source =" & Server.MapPath("\db\db2.mdb") & "UserID=;Password=;"
%>
These are the errors I get:
1 - while oppening an .asp file in Dreamweaver: "The DynamicSelectList script does not define the findServerBehavior function."
2 - while testing the connection in Dreamweaver, or in a browser: "Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM."
Things I've tryed and failed:
a) I've also used DBQ instead of Data Source, but it does not seem to make any difference.
b) I've also tryed erasing Server.MapPath, and writing the full path (since I'm now working in a local server I control), but it still doesn't work.
c) I've also tryed rewriting my connection file into this format after reading some scatered foruns, but it didn't work either:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connEIN_STRING
set MM_connEIN_STRING = Server.CreateObject("ADODB.Connection")
MM_connEIN_STRING.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
conn = "Driver={Microsoft Access Driver(*.mdb)};DBQ =" & Server.MapPath("/einservices/db/db2.mdb")
MM_connEIN_STRING.Open conn
%>
I've wasted hours browsing and searching for an answer, and trying tinny changes. I would really appreciate help from someone who has successfully changed from a system DSN to a DSN-less connection.
Thanks in advance!
