Connecting to MSSQL with a DSN - Powered By Kayako eSupport

05 Sep 2010

Support Center » Knowledgebase » Connecting to MSSQL with a DSN

	Connecting to MSSQL with a DSN

Solution *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 or which you have created thru your Control Panel.*

Article Details

Article ID:

Created On:

11 Jan 2007 02:51 PM