Menu options: 'Administration', 'Bookkeeping'

This type of connection uses an ODBC driver to connect to the database in which the financial information is stored.

 

 

To connect to a database by means of an ODBC driver, open the window 'Bookkeeping' and select the appropriate accounting program.

Then enter the following information to complete the configuration:

 

Select the name of the (System) DSN that must be used to connect to the database of the accounting administration.        

 

Enter the username and password of a user that is allowed to connect to the database of the accounting administration by means of an ODBC driver.        

 

Various techniques can be used to connect to a database. By default d-basics uses an ADO connection. Because some older databases do not support ADO connections d-basics can use the RDO connection as an alternative. Because RDO is slower than ADO, it is recommended only to use RDO if ADO does not work.

 

This setting is used to define during which events the log on window of the ODBC driver must be shown. The default setting is: 'Complete required', only change this setting in consultation with the d-basics helpdesk

 

Enter or select the name of the database or library in which the financial administration is stored (this setting is not always required).

 

Enter the name of the financial administration that must be imported (this setting is not always required).