Announcement

Collapse
No announcement yet.

MS SQL DSN Based Connection String - ASP

Collapse

Ads on showthread pages

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MS SQL DSN Based Connection String - ASP

    WordPress Hosting on SSD Servers
    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, 06:03 AM.
Working...
X
Sign up for a News Letter Click here to sign up