Category: ASP
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=somepathmydb.mdb;User Id=admin;Password=;"
mySQL
ASP
"Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;"