MSSQL2005
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source =mssql.yourdomain; Initial Catalog = Yourdatabase; User Id = USER; Password=PASSWORD; Network Library=dbmssocn;"
If conn.errors.count = 0 Then
Response.Write "Connected OK"
MSSQL 2008
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source=mssql.yourdomain,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"
If conn.errors.count = 0 Then
Response.Write "Connected OK"
MySQL5 - MySQL Connector/ODBC 3.51
Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
To Know more about Connection Strings open the following link
http://www.connectionstrings.com/
