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 Nexus, you can create DSNs from your Windows Control panel 24 hours a day.
