Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Connect to External DB

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Connect to External DB

Parameters: PathToDB, TableName

Connects to an external database for data exchange.

The PathToDB parameter should contain a path to the database (for example, "C:\Doc1.xls" or "C:\MyDBs\db1.mdb") or a connection string. For example to connect to MySQL database installed on the local computer with MySQL ODBC driver you should use the follwoing connection string:

odbc;DRIVER=Unknown block: MYSQL ODBC 3;SERVER=127.0.0.1;DATABASE=database_name_here;UID=user_name_here;PWD=password_here;OPTION=3;

In case this parameter is empty the Microsoft Windows Database Connection Wizard will be displayed.

In the TableName you can define the name of the table (spreadsheet) with which you want to work. If this parameter is skipped, the first table will be selected by default.

To work with the database after connecting, use the External DB Operation or External DB SQL Query actions.

View an example of work with an external database...

RETURN VALUE: Returns 1 if connection complete successfully



All topics in the "Import/Export/Send Operations" section: