Knowledgebase

Connecting to MSSQL with a DSN

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.*

Add to Favourites

Print this Article

Portal Home
Client Area
Announcements
Knowledgebase
Submit Ticket
Downloads
Order