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

Announcement

Collapse
No announcement yet.

Cadenas conexion para SQL Server 2005

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

  • Cadenas conexion para SQL Server 2005

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