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

Also Read

Connect to a msaccess database using a dsn-less connection via asp (Views: 678)

Error:Microsoft OLE DB Provider for ODBC Drivers Error '80004005' -- DSN Not Found... (Views: 661)

Connecting to MSSQL with out a DSN (Views: 642)

How to Export and then Import a MySQL database using PhpMyADMIN (Views: 679)

I'm getting a strange error message: Operation must use an updateable query(error '80004005')? (Views: 628)

Portal Home
Client Area
Announcements
Knowledgebase
Submit Ticket
Downloads
Order