Switch to: V12V11V10V9V8V7V6V5

Connect Dialog Help

This dialog allows you to establish a new connection to some remote DB Server, local database or ODBC datasource.

  • On the left side you can see the list of supported connections (in alphabetic order):
    • MSSQL
    • MySQL
    • ODBC
    • PostgreSQL
    • Valentina Files
    • Valentina Server
    • SQLite Files
    • SQLite Server
  • On the top you can see menu with existed bookmarks and menu to manage bookmarks.
  • At bottom of the dialog you can see checkbox to specify if you want save password of the new connection in the list of Recent Items.
  • Other options of this dialog depends on the type of connection you chose, but most of the are the same. See description below.
  • For Valentina, MySQL and PostgreSQL servers you can establish connection using SSH tunnel. For this purpose you should set SSH Settings for the connection.

Connect to Valentina Server

  • Host - This is the host or IP address of Server.
  • Port - This is the port number that Server do listen.
  • User - This is your Server used ID.
  • Password - This is your password to Server.
  • Signature - This is embedded signature, required only if you connect to Valentina Embedded Server.
  • Use SSL - Specify if you want SSL connection to Server.

Connect to PostgreSQL

Please see the description of the parameters above.

Connect to mySQL

Please see description of parameters above.

Connect to ODBC

Please see description of parameters above. Additionally:

  • DSN - Data Source Name of ODBC data source you want connect to.

SSH Settings

The Connection dialog provides the ability to set up the connection to the remote database server through SSH tunnel.

There are two ways to establish the SSH tunnel:

Authentification by Password Authentification by Public Key
Connect dialog -- SSH Authentication by PasswordConnect dialog -- SSH Authentication by Key
  • Connection Method – If Standard TCP/IP over SSH, then the connection will be established using SSH tunnel.
  • Host – The host address of the remote SSH server.
  • Port – The port of SSH service on the remote server.
  • User – The user name for connecting to SSH ssh server.
  • Authentification – The kind of authentification on the SSH server.
  • By Password
    • Password – The password for connecting to the ssh server.
  • By Public Key
    • Key File – The path to the Private Key, that corresponds to the Public Key registered on the SSH server.
    • Passphrase – The code phrase to decipher the Private Key. If the passphrase is not required skip the field.
Supported key types are DSA, RSA, ECDSA and Ed25519.
If you connect to the database server using SSH the purpose of some fields in the GENERAL tab is changing:
  • Host – the host of the DB server ON THE REMOTE machine (as usually is ('localhost').
  • Port – the port of the DB server ON THE REMOTE machine (as usually is default port of the particular DB server).