12-22-2011, 07:15 PM
|
|
Super Moderator
|
|
Join Date: Dec 2011
Posts: 55
|
|
Cadenas conexion para SQL Server 2008
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:\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
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=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
Quote:
|
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:\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
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;
|
Bridging to SQL Native Client OLE DB
Quote:
|
Provider=SQLNCLI10;Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME; Pwd=PASSWORD;
|
Standard security
Quote:
|
Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME;Pwd=PASSWORD;
|
Trusted Connection
Quote:
|
Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=yes;
|
Connecting to an SQL Server instance
Quote:
|
Driver={SQL Server Native Client 10.0};Server=myServerName\theInstanceName; Database=DATABASE-NAME;Trusted_Connection=yes;
|
Prompt for username and password
Quote:
oConn.Properties("Prompt") = adPromptAlways
Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;
|
Enabling MARS (multiple active result sets)
Quote:
|
Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Trusted_Connection=yes; MARS_Connection=yes;
|
Encrypt data sent over network
Quote:
|
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
Quote:
|
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
Quote:
|
Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=|DataDi rectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
|
Database mirroring
Quote:
|
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
Quote:
|
Driver={SQL Server Native Client 10.0};Server=SERVER-IP;Database=DATABASE-NAME;Uid=USERNAME;Pwd=PASSWORD;
|
Using SQL Server Native Client provider
Quote:
|
Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;Data Source=SERVER-IP;Initial Catalog=DATABASE-NAME;User Id=USERNAME;Password=PASSWORD;
|
Context Connection
Quote:
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
|
|
Linear Mode
