SQL Native Client ODBC Driver
Standard security
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;
Trusted Connection
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
Trusted_Connection=yes;
Connecting to an SQL Server instance
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;
Trusted_Connection=yes;
SQL Native Client OLE DB Provider
Standard security
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;
Uid=myUsername;Pwd=myPassword;
Trusted connection
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;
Trusted_Connection=yes;
Connecting to an SQL Server instance
Provider=SQLNCLI;Server=myServerName\theInstanceName;Database=myDataBase;
Trusted_Connection=yes;
SqlConnection (.NET)
Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Trusted Connection
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Connecting to an SQL Server instance
Server=myServerName\theInstanceName;Database=myDataBase;
Trusted_Connection=True;
Connecting to an SQL Server instance via an IP address
Data Source=192.168.1.100,1433;Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Reference : Pinal Dave (http://www.SQLAuthority.com), ConnectionStrings
pinaldave
Could u pls let me know how to connect with mysql and dotnet.
There’s a useful site at http://www.connectionstrings.com that shows connections string for lots of different database types and configurations. It’s very useful if you can’t quite remember the exact format for each.