Cadenas conexion para SQL Server 2008 - Foro Support - Manuales tecnicos

Announcement

Collapse
No announcement yet.

Cadenas conexion para SQL Server 2008

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cadenas conexion para SQL Server 2008

    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
Working...
X