.Net Connection Strings

Enes Pekkaya    .Net, Asp.Net, MsSql, SQL     .Net, Asp.Net, Connection String, MsSql

.Net teknolojisini kullanarak yapacağınız yazılımlarda size uygun olan aşağıdaki veritabanı bağlantı yollarını kullanabilrisiniz.

SqlConnection (.NET)

Standard Security

Data Source=myServerAddress;Initial Catalog=myDataBase;UserId=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;

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;

Kaynak : Pinal Dave