Establish database connection

Via built-in drivers, SQL Uniform provides convenient and fast connection to the following database servers: IBM DB2, Firebird, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase

In addition to the built-in drivers, you can connect to SQL servers via ODBC and JDBC drivers.

A simple setup interface is provided for the connection via ODBC drivers. (The built-in MS Access, dBase (dbf), Excel (xls) drivers also use the ODBC interface.)

Connection via Java JDBC drivers is provided using an interface with detailed parameters. Additionally, you can select drivers from the predefined parameters by pushing a button for the following database types: Adabas D, DaffodilDB, HSQLDB, HXTT, IBM Cloudscape, Intersystems Cache, Java DB, JDataStore, Linter (Relex), McKOI, Mimer, Openlink Virtuoso, Pervasive (Btrive), Pointbase, Solid, StelsCSV

Screenshots:

Firstly, you have to select the type of the database server
You have to enter the name of the connection
The default settings of the previously specified SQL server type will appear.
The connection settings can be modified later

Establish database connection via ODBC:

Please select the "ODBC" item from the list
You have to enter the name of the connection.
You have to enter the name of the ODBC data source. It can be selected using the push button

Establish database connection via JDBC:

JDBC is briefly a programming interface (API), which allows communication with the databases in a standardised way.

JDBC drivers are a set of Java classes, developed for a particular version of a particular database, adjusted to the JDBC standard and providing standard functions, and are located in a directory structure or a file with ZIP or JAR extension in an appropriately organised order. (JAR is basically a file of ZIP type.) .

Please select the "JDBC" item from the list
You have to enter the name of the connection
You can select the most suitable predefined parameter from the list
The program will deploy the fields with the parameters of the selected SQL server type. You have to specify the location of the JDBC driver.
During the connection you can set additional parameters, like the database file name, defined by the URL pattern.