Connection Editor

The connection string specifies the configuration values required by the data provider to connect to the database. The content of the connection string depends on the database driver used. The Connection Editor helps build the connection string by offering the most common connection properties depending on the selected connection type.

Samples

SQL Server

  • Not named, Windows authentication

    Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=True;
  • Named server, no Windows authentication
    Data Source=serverNameinstanceName;Initial Catalog=databaseName;Integrated Security=;User ID=username;Password=password;

Oracle

  • Using TNS-names entry

    Data Source=TNSname;User ID=username;Password=password;
  • Without using TNS-names entry
    Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverAddress)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName));User ID=username;Password=password;

OLE DB

  • Windows authentication

    Provider=sqloledb;Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=SSPI;
  • No Windows authentication
    Provider=sqloledb;Data Source=serverAddress;Initial Catalog=databaseName;Integrated Security=;User ID=username;Password=password;

ODBC

  • Microsoft Access database

    Driver={Microsoft Access Driver (*.mdb)};DBQ=databaseFilePath;
  • System Data Source Name, Windows authentication

    DSN=dataSourceName;Trusted_Connection=Yes;
  • System Data Source Name, no Windows authentication
    DSN=dataSourceName;Uid=username;Pwd=Password;

Links

Connection strings