Connection Strings

SQL Server 2005

from .NET

"Data Source=Aron1;Initial Catalog=pubs;User Id=myUsername;Password=myPassword;" 

from ASP

"Provider=SQLNCLI;Server=Aron1;Database=pubs;UID=myUsername;PWD=myPassword;" 

SQL Server 2000

from .NET SQLConnection

"Data Source=Aron1;Initial Catalog=pubs;User Id=myUsername;Password=myPassword;" 

from ASP

"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=myUsername;Password=myPassword;" 

Access

ASP and .NET

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" 

mySQL

ASP

"Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;"