Database Connection Strings

[neta]

MS SQL

This is a less common alternative to Access databases, most commonly used by large scale websites. Here's our connectionstring to SQL

Code:

set Conn = server.createobject("ADODB.Connection")
Conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=servername;User ID=username;_
Password=password;DATABASE=databasename;"

There's your MS SQL string. Be sure to change servername to the name of the server (localhost, computername, or IP), and to change username, password, and databasename to match those of your database.