Connect to MS SQL Server Database

 

Connection String
"Provider=SQLOLEDB; " & _
"Data Source = SQLServerIP,SQLServerPortNumber; " & _
"Initial Catalog = YourDatabaseName; " & _
"User ID = YourDatabaseUserID; " & _
"Password = YourDatabasePassword"

 

You can use sample code below to connect to your MS SQL Server's database:

 

ConnectionString = "Provider=SQLOLEDB; Data Source = 72.18.131.233,1533; " & _
"Initial Catalog = Northwind; " & _

"User ID = SampleUser; " & _

"Password = SamplePassword"


Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = ConnectionString
Conn.Open

 

 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.