DSN on server

[simonWMC]

HI

I have created a site using asp and have it connected to an access database on my local pc (using IIS).

However, I have now come to transfer it to the server (done manually on a CD). But it isn't working properly. I'm not sure I have done everything right to set up the DSN.

I went into the OBDC control panel on the server and created a new system DSN using an access driver, but evertime i try and use the log in on my site it says page not found.

have i missed something out ?

thanks

 

[lebisol]

DSN has the be the same name or u have to edit your Connectoions/MY.asp file

hint hint:
better yet use DSN-less connection with JET drivers vs.. usong ODBC:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_lifeline_conn_STRING
MM_lifeline_conn_STRING = "dsn=DSN_NAME;"
'MM_lifeline_conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/fpdb/my.mdb") & ";  User ID=; Password=;"

%>

and simply un-comment the connection that you prefer.
DSN-less will work on localhost as well as the remote/true server.
All the best!


> need more info?
:: don't click HERE ::