NET Framework Data Provider for SQL Server connection strings

more

 

• • Standard Security

    Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;

    • SQL Server 2000
    • SQL Server 2005
    • SQL Server 2008
    • SQL Server 2012
    • SQL Server 7.0

  • Trusted Connection

    Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

    • SQL Server 2000
    • SQL Server 2005
    • SQL Server 2008
    • SQL Server 2012
    • SQL Server 7.0

  • Connection to a SQL Server instance

    The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

    Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

    • SQL Server 2000
    • SQL Server 2005
    • SQL Server 2008
    • SQL Server 2012