Search our database

MSSQL (Microsoft SQLServer) ConnectionString in ASP/ASP.net:

SQL ODBC connection strings:

Standard Security

"Driver=;
Server=Your_Server_Name;
Database=Your_Database_Name;
Uid=Your_Username;
Pwd=Your_Password;"

SQL OLE DB connection strings:

"Provider=SQLOLEDB;
Data Source=127.0.0.1;
Initial Catalog=Your_Database_Name;
UserId=Your_Username;
Password=Your_Password;"

SQL SqlConnection .NET strings:

"Server=127.0.0.1;
Database=Your_Database_Name;
UserID=Your_Username;
Password=Your_Password;
Trusted_Connection=False"

SQL SqlConnection for SQL 2008:

"Provider=SQLNCLI10;
Server=127.0.0.1;
Database=database_name;
UId=user_id;
Pwd=password;"

Tags: , ,