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;" 

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.