Using dialog

To run a Add Database Connection Information dialog, select [Add Store] from the right mouse click popup menu on the DATABASE in OZ data window.

To establish database connection using Add Database Connection Information dialog, enter the vendor name, database server IP address, port number, user name and password.

ODBC connection

Various databases providing ODBC driver such as MS Access can be connected by ODBC connection. Correct ODBC driver should be installed and your database should be registered as DSN(data source name) using the ODBC Data Source Administrator dialog of Windows system.

To establish ODBC database connection, enter your string for "Name" - the database connection ID, and select odbc for "Vendor", and enter the DSN registered in Windows for "Data Source Name".

DBMS connection

Set connection to database such as MS-SQL, Oracle, Sybase, Informix, Uni-SQL, DB2, tibero, tibero5, mariadb, etc.

Enter your string for "Name" - the database connection ID, and select your database for "Vendor", and enter Database server IP Address, Database server port number, Database server name, Database name.

Enter database user name and password. If check "Use param" option, password value comes from a user defined parameter.

When connect to sybase,  Enter "Tds" for "Data source name" to use jConnect - JDBC driver for  sybase. Tds(Tabular Data Stream) is a native communication protocol for sybase Adative Server.

OLEDB connection

Set connection to OLEDB such as MSSQL-OLEDB, ORACLE-OLEDB, SYBASE-OLEDB, DB2-OLEDB, INFORMIX-OLEDB, etc.

Enter your string for "Name" - the database connection ID, and select your oledb(mssql-oledb, oracle-oledb, sybase-oledb, db2-oledb, informix-oledb, etc.) for "Vendor", and enter Database server IP Address, Database server port number, Database name, and Data source name, etc.

Enter database user name and password. If check "Use param" option, password value comes from a user defined parameter.

User-Definded connection

If your database is not in the built-in DB list, you can set your JDBC driver by yourself.

Enter your string for "Name" - the database connection ID, and select "user" for "Vendor", and enter Driver Class Name of your JDBC driver and Connection URL.

Enter database user name and password. If check "Use param" option, password value comes from a user defined parameter.