Hello All,
I need some help with my dsn less connection string. I am using Dreamweaver MX 2004, using Access db and I have a testing server on my local machine. I am using ASP pages. I was able to set up my site and I could test it with no problems locally, however when I upload the site to my web hosting server which is a windows platform I get errors connecting to my database. This is the error I get when I log in to my site:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x468c Thread 0x1f48 DBC 0x1676fc4 Jet'.
line 15
And this is where the error refers to:
MM_rsUser.ActiveConnection = MM_amgcard_STRING
I am new with programming and I mainly used the graphical user interface. This is the connection string I used:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_amgcard_STRING
MM_amgcard_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ= c:\Inetpub\wwwroot\amg\connections\amg.mdb"
%>
Please help.
Thanks
Edited by topping - 18 June 2007 at 7:32pm