Sysol System Solution Knowledgebase / What is a DSN?

DSN is used to access databases, e.g. Access, MSSQL, TEXT etc.

There are 2 methods of connecting to a DSN.

Here is the 1st option of connecting to a database with a DSN.

<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "DSN=YourDSN"
Conn.Open
Conn.Close
Set Conn = Nothing
%>

Here is the 2nd option of connecting to a database with a DSN.

<%
Dim myDSN
Dim Conn
myDSN="DSN=YourDSN"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open(myDSN)
Conn.Close
Set Conn = Nothing
%>

YourDSN is the DSN that you create from the control panel

With SYSOL, you can create DSNs from your Windows Control panel 24 hours a day.

Other questions in this category

	500 Error Message
	Using ASPEMAIL to send mails using ASP
	Where can I find more information about Python?
	ASPEMAIL is not working
	How do I stop browsers & proxy servers from caching my web pages?
	Using aspSmartUpload to upload files using ASP
	ASP.NET Test Page
	Active Server Pages error ASP 0131 or Server.MapPath() error 'ASP 0175 : 80004005'