The direct connection method allows you to connect to most popular databases
(MS SQL Server,
Oracle, Interbase/Firebird, MySQL,
PostgreSQL and DB2).
Enter the server name and the database name, if required. The user name and password are optional. Their necessity depends on the settings of your database. The owner name (schema) is optional too. The list of visible database objects depends on the choice of the owner. If the owner is empty, you will access all objects. There is important that schema/owner name is case sensitive.
If you do not find the required database type in the list or cannot connect directly, use a connection through the predefined data source. If DBMS is in the list, but unavailable, it means that either the required ODBC driver is not installed or it is not configured properly.
During its use, the program stores the entered values of server names, users and owners. You can select a value from the stored list using the corresponding combo box. For some DBMS types (MS SQL, for example), the program can fill the list of available databases. Use the button with two arrows for this purpose.
Use connect string for the Oracle Server that you want to access as a Server name.
Important: it is strongly recommended to use native Oracle Call Interface (OCI) instead of direct connection.