powered by CADENAS

Manual

Manual

4.2.7.1.  dbproxy.cfg

[Note] Note

The configuration file dbproxy.cfg is only available if a link database with the required driver is used.

In this file you can specify the ODBC or JDBC database interface for each used operating system.

The driver selection during the PARTsolutions setup (Database connection selection) results in a setting in dbproxy.cfg.

Database connection selection

Database connection selection

If for testing purposes or by mistake a wrong driver has been selected, set the correct driver in the configuration file or in the corresponding user interface.

  • Setting via user interface:

    Under PARTadmin -> category PARTsolutions -> ERP environment, in the Database interface dialog area, you can make settings easily via user interface:

    Select database interface in the list field

    Select database interface in the list field

    Either you determine ODBC or JDBC specifically for each operating system. Or you determine the default interface and then refer to the selection <default> in the list field.

  • Setting via configuration file:

    [COMMON]
    Driver=DATABASE.ODBCDB
    
    [x86]
    Driver=DATABASE.JDBCDB
    
    [Linux]
    Driver=DATABASE.ODBCDB
    
    [AIX]
    Driver=DATABASE.JDBCDB

    Either you determine ODBC or JDBC specifically for each operating system or the one specified in the block [Common] is taken.

[Note] Note
  • If there is no dbproxy.cfg available in C:\ProgramData\cadenas\partsolutions\setup, the ODBC driver will be used.

  • If there is no specific entry available, the entry under [Common] (Default) is used.

  • Which driver should be used when CreateObject("DATABASE.ODBCDB") is called?

    Platform depending driver is taken before the common one.

  • Calling CreateObject("DATABASE.JDBCDB") will definitively use the JDBC driver, if installed.

  • ODBC/JDBC installation packages may change these settings, depending on there need!