Stringhe di connessione ai database

Questo post illustra le varie possibili connessioni che possono essere effettuate su Database Sql Server 2000 e 2005:

SQL Server

• ODBC

Connessione Standard Security:
"Driver={SQL Server};Server=Zues;Database=Northwind;Uid=sa;Pwd=prova;" Connessione Trusted connection:
"Driver={SQL Server};Server=Zeus;Database= Northwind;Trusted_Connection=yes;"

• OLE DB, OleDbConnection (.NET)

Connessione Standard Security:
"Provider=sqloledb;Data Source=Zeus;Initial Catalog= Northwind;User Id=sa;Password=prova;" Connessione Trusted connection:
"Provider=sqloledb;Data Source=Zeus;Initial Catalog= Northwind;Integrated Security=SSPI;" Connessione tramite indirizzo IP:
"Provider=sqloledb;Data Source=100.100.200.300,1433;Network Library=DBMSSOCN;Initial Catalog= Northwind;User ID=sa;Password=prova;"
(1433 è la porta di default di connessione di Sql Server)

• SqlConnection (.NET)

Connessione Standard Security:
"Data Source=Zeus;Initial Catalog= Northwind;User Id=sa;Password=prova;"
- or -
"Server=Zeus;Database= Northwind;User ID=sa;Password=prova;Trusted_Connection=False"
Connessione Trusted connection:
"Data Source=Zeus;Initial Catalog= Northwind;Integrated Security=SSPI;"
- or -
"Server=Zeus;Database= Northwind;Trusted_Connection=True;"
Connessione tramite indirizzo IP:
"Data Source=100.100.200.300,1433;Network Library=DBMSSOCN;Initial Catalog= Northwind;User ID=sa;Password=prova;"

-------------------------------------------

SQL Server 2005

• SQL Native Client ODBC Driver

Connessione Standard Security:
"Driver={SQL Native Client};Server=Zeus;Database= Northwind;UID=sa;PWD=prova;" Connessione Trusted connection:
"Driver={SQL Native Client};Server=Zeus;Database= Northwind;Trusted_Connection=yes;"

• SQL Native Client OLE DB Provider

Connessione Standard Security:
"Provider=SQLNCLI;Server=Zeus;Database= Northwind;UID=sa;PWD=prova;" Connessione Trusted connection:
Provider=SQLNCLI;Server=Zeus;Database= Northwind;Trusted_Connection=yes;"

• SqlConnection(.NET)

Connessione Standard Security:
"Data Source=Zeus;Initial Catalog= Northwind;User Id=sa;Password=prova;"
- or -
"Server=Zeus;Database= Northwind;User ID=sa;Password=prova;Trusted_Connection=False" Connessione Trusted connection:
"Data Source=Zeus;Initial Catalog= Northwind;Integrated Security=SSPI;"
- or -

"Server=Zeus;Database= Northwind;Trusted_Connection=True;"