DISE Database Access

Function

DISE Database Access is designed to be used for fetching data from a database and to use a text file as output. This text file can then be used together with the data connection in the DISE system to insert the text from the database into a Text, Ticker or Table Object.

Note: All the features of DISE Database Access have been implemented in DISE Parser, so we recommend you use that instead.

In the main window of the DISE Database Access application you can manage several databases, change the update interval and Start / Stop processing. It is also possible to get the DISE Database Access application to start minimized in the tray.

To be able to edit any of the settings or databases you have to click on the Stop button, the DISE Database Access application will always start in running mode.

To add new databases click on the Add button. To edit a database item click on the Edit button.

Database support

Database Access support connections the following database servers:

• ASA DBLib 7.0, 8.0, 9.0
• Firebird 1.0, 1.5, 2.0 (Embedded 1.5, 2.0)
• IBM DB2
• Interbase 5+, 6+
• Microsoft ADO
• Microsoft SQL 7+
• MySQL 3.20+, 4.x, 5x (Embedded 4.x, 5.x)
• Oracle 9i
• PostgreSQL 6.5, 7.x, 8.x
• SQLite 2.8, 3
• Sybase ASE 12.5

Some database connections may require third party software or that you have installed database client software.

Settings

Test Query

Test the settings and fill the preview box. This function will update the output text file as well.

Database Settings

Name

The name of the database item.

Hostname

The host name, address or IP number of the database host.

Username / Password

User name and password that allows access to the database.

Database

The name of the database you want to access.

Protocol

The type of database server that you want to access.

Test Connect

Test if the connection and parameters is okay.

SQL & File Options

SQL

The SQL query that should be run on the server, it is possible to write several queries, one per row and they will be executed one after the other. The output (if any) of all the queries will be used. For example you could select some data from a table and then delete the data to make sure that you do not show the same data twice.

Output Filename

The path to the file that should be the output from this database item. Click on the Auth button if the path you have entered needs user name and password.

Pre text

Text inserted before the complete text.

Separator

Three fields where you can specify text that is to be inserted before each row, between each column of the row and after each row.

Sub text

Text inserted after the complete text.