I have a website which uses a SQL Server database (version 7 I think).
I have two database files a 'mdf' and a 'ldf'.
This is the asp code that connects to it
Application("Conn_ConnectionString") = "DSN=km" 'local
sql = "SELECT * FROM AdminUser"
set rsPass = server.CreateObject("adodb.recordset")
rsPass.Open sql, Application("Conn_ConnectionString")
I have only ever used MS Access databases in the past so im not sure where to start.
What software do I need to install?
How do I setup the DSN connection - Is it the same as MS Access?