Cadenas conexion para SQL Server 2008

[soporte]

Standard Security

Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;User Id=USERNAME;Password=PASSWORD;

Standard Security alternative syntax

Server=SERVER-IP;Database=DATABASE-NAME;User ID=USERNAME;Password=PASSWORD;Trusted_Connection=F alse;

Trusted Connection

Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;Integrated Security=SSPI;

Trusted Connection alternative syntax

Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=True;

Connecting to an SQL Server instance

Server=myServerName\theInstanceName;Database=DATAB ASE-NAME;Trusted_Connection=True;

Trusted Connection from a CE device

Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DATABASE-NAME;User ID=USERNAME;Password=PASSWORD;

Enabling MARS (multiple active result sets)

Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=True; MultipleActiveResultSets=true;

Attach a database file on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\my dbfile.mdf;Database=dbname; Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=|DataDirector y|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Using an User Instance on a local SQL Server Express instance

Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\mydb.mdf;User Instance=true;

Database mirroring

Data Source=SERVER-IP;Failover Partner=myMirrorServerAddress;Initial Catalog=DATABASE-NAME;Integrated Security=True;

Asynchronous processing

Server=SERVER-IP;Database=DATABASE-NAME;Integrated Security=True;Asynchronous Processing=True;

Standard security

Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;

Trusted connection

Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;

Connecting to an SQL Server instance

Provider=SQLNCLI10;Server=myServerName\theInstance Name;Database=DATABASE-NAME; Trusted_Connection=yes;

Prompt for username and password

oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Provider=SQLNCLI10;Server=SERVER-IP;DataBase=DATABASE-NAME;

Enabling MARS (multiple active result sets)

Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;MARS Connection=True;

Encrypt data sent over network

Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;Encrypt=yes;

Attach a database file on connect to a local SQL Server Express instance

Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFil ename=c:\asd\qwe\mydbfile.mdf; Database=dbname; Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFil ename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Database mirroring

Provider=SQLNCLI10;Data Source=SERVER-IP;Failover Partner=myMirrorServerAddress;Initial Catalog=DATABASE-NAME;Integrated Security=True;

Bridging to SQL Native Client OLE DB

Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;

Standard security

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME;Pwd=PASSWORD;

Trusted Connection

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=yes;

Connecting to an SQL Server instance

Driver={SQL Server Native Client 10.0};Server=myServerName\theInstanceName; Database=DATABASE-NAME;Trusted_Connection=yes;

Prompt for username and password

oConn.Properties("Prompt") = adPromptAlways

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;

Enabling MARS (multiple active result sets)

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=yes; MARS_Connection=yes;

Encrypt data sent over network

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;Encrypt=yes;

Attach a database file on connect to a local SQL Server Express instance

Driver={SQL Server Native Client 10.0};Server=.\SQLExpress; AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=|DataDi rectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Database mirroring

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Failover_Partner=myMirrorServerAddress;Database =DATABASE-NAME; Trusted_Connection=yes;

Bridging to SQL Native Client 10.0 ODBC Driver

Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME;Pwd=PASSWORD;

Using SQL Server Native Client provider

Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;User Id=USERNAME;Password=PASSWORD;

Context Connection

C#
using(SqlConnection connection = new SqlConnection("context connection=true"))
{
connection.Open();
// Use the connection
}

VB.Net
Using connection as new SqlConnection("context connection=true")
connection.Open()
' Use the connection
End Using