12-27-2011, 04:17 PM
|
|
Member
|
|
Join Date: Dec 2011
Posts: 38
|
|
Cadenas conexion para SQL Server 2005
Standard Security
Quote:
|
Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;User Id=USERNAME;Password=PASSWORD;
|
Standard Security alternative syntax
Quote:
|
Server=SERVER-IP;Database=DATABASE-NAME;User ID=USERNAME;Password=PASSWORD;Trusted_Connection=F alse;
|
Trusted Connection
Quote:
|
Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;Integrated Security=SSPI;
|
Trusted Connection alternative syntax
Quote:
|
Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=True;
|
Connecting to an SQL Server instance
Quote:
|
Server=myServerName\theInstanceName;Database=DATAB ASE-NAME;Trusted_Connection=True;
|
Trusted Connection from a CE device
Quote:
|
Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;
|
Connect via an IP address
Quote:
|
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)
Quote:
|
Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=True; MultipleActiveResultSets=true;
|
Attach a database file on connect to a local SQL Server Express instance
Quote:
|
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
Quote:
|
Server=.\SQLExpress;AttachDbFilename=|DataDirector y|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
|
Using an User Instance on a local SQL Server Express instance
Quote:
|
Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\mydb.mdf;User Instance=true;
|
Database mirroring
Quote:
|
Data Source=SERVER-IP;Failover Partner=myMirrorServerAddress;Initial Catalog=DATABASE-NAME;Integrated Security=True;
|
Asynchronous processing
Quote:
|
Server=SERVER-IP;Database=DATABASE-NAME;Integrated Security=True;Asynchronous Processing=True;
|
Standard security
Quote:
|
Provider=SQLNCLI;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;
|
Trusted connection
Quote:
|
Provider=SQLNCLI;Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=yes;
|
Connecting to an SQL Server instance
Quote:
|
Provider=SQLNCLI;Server=myServerName\theInstanceNa me;Database=DATABASE-NAME; Trusted_Connection=yes;
|
Prompt for username and password
Quote:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Provider=SQLNCLI;Server=SERVER-IP;DataBase=DATABASE-NAME;
|
Enabling MARS (multiple active result sets)
Quote:
|
Provider=SQLNCLI;Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;MARS Connection=True;
|
Encrypt data sent over network
Quote:
|
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
Quote:
|
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
Quote:
|
Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilen ame=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
|
Database mirroring
Quote:
|
Provider=SQLNCLI;Data Source=SERVER-IP;Failover Partner=myMirrorServerAddress;Initial Catalog=DATABASE-NAME;Integrated Security=True;
|
Bridging to SQL Native Client OLE DB
Quote:
|
Provider=SQLNCLI;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;
|
Standard security
Quote:
|
Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;
|
Trusted connection
Quote:
|
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
Quote:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Provider=SQLNCLI10;Server=SERVER-IP;DataBase=DATABASE-NAME;
|
Enabling MARS (multiple active result sets)
Quote:
|
Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME; Trusted_Connection=yes;MARS Connection=True;
|
Encrypt data sent over network
Quote:
|
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
Quote:
|
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
Quote:
|
Provider=SQLNCLI10;Server=.\SQLExpress;AttachDbFil ename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
|
Database mirroring
Quote:
|
Provider=SQLNCLI10;Data Source=SERVER-IP;Failover Partner=myMirrorServerAddress;Initial Catalog=DATABASE-NAME;Integrated Security=True;
|
|
Linear Mode
