Cadenas conexion para SQL Server 2005

[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:\mydbfile.m df;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=SQLNCLI;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;

Trusted connection

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

Connecting to an SQL Server instance

Provider=SQLNCLI;Server=myServerName\theInstanceNa me;Database=DATABASE-NAME; Trusted_Connection=yes;

Prompt for username and password

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

Enabling MARS (multiple active result sets)

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

Encrypt data sent over network

Provider=SQLNCLI;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=SQLNCLI;Server=.\SQLExpress;AttachDbFilen ame=c:\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=SQLNCLI;Server=.\SQLExpress;AttachDbFilen ame=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

Database mirroring

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

Bridging to SQL Native Client OLE DB

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

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:\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;