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