How to create connection form my sql server

Question

how to create connection object for my sql server

Vijaya Kadiyala · Answer

Hi Check out the below link http://www.connectionstrings.com/?carrier=sqlserver Thanks -- Vj

Bechir Bejaoui · Answer

System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(); sqlConnection.ConnectionString = Data Source=YourProviderName Initial Catalog=yourDataBaseName Integrated Security = true;

Sudheendra Desai · Answer

Driver = {SQL Native Client} ; Server = myServerAddress ; Database = myDataBase ; Uid = myUsername ; Pwd = myPassword ; Provider = SQLNCLI ; Server = .\SQLExpress ; AttachDbFilename = c:\asd\qwe\mydbfile.mdf ; Database = dbname ; Trusted_Connection = Yes ; for mysql ----------------------------------- Driver = {mySQL} ; Server = myServerAddress ; Port = 3306 ; Option = 131072 ; Stmt = ; Database = myDataBase ; Uid = myUsername ; Pwd = myPassword ;

Scott Lysle · Answer

MySQL or SQL Server?