Table of Contents
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):
- 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
Connect to mySQL
Connect to ODBC
Please see description of parameters above. Additionally:
- DSN - Data Source Name of ODBC data source you want connect to.
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:
- 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.
- Host – the host of the DB server ON THE REMOTE machine (as usually is 127.0.0.1 ('localhost').
- Port – the port of the DB server ON THE REMOTE machine (as usually is default port of the particular DB server).