Knowledgebase: MSSQL
Connecting to MSSQL with a DSN
Posted by Nexus Support Admin on 18 October 2003 10:08 PM

You can use the following string to connect to MSSQL with a DSN

<%
Set Conn = Server.CreateObject ("ADODB.Connection")
Conn.open "DSN=MyDSN;UID=USER;PWD=PASSWORD;DATABASE=mydatabase"
%>

 

MyDSN is the DSN that you created for the MSSQL server through the Control Panel, USER is the username and PASSWORD is the password which was provided to you in your MSSQL account setup mail.

(796 vote(s))
Helpful
Not helpful