MS SQL DSN Based Connection String - ASP

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • Shane
    Senior Member
    • Jun 2006
    • 264

    MS SQL DSN Based Connection String - ASP

    One can use below mentioned MS SQL DNS Based connection string for ASP Script:

    Dim SqlConn
    Set SqlConn = Server.CreateObject("ADODB.Connection") & _
    SqlConn.ConnectionString = "Provider=sqloledb;" & "DSN=sqltest;Initial Catalog=databasename;" & "User Id=username;" & "Password=password"
    SqlConn.Open
    Response.Write "SQL Connection Successful"
    Last edited by admin; 08-21-2015, 05:03 AM.
Working...
X

Debug Information


test