powered by CADENAS

Manual

Manual

1.1.6.7.6. dbproxy.cfg

[Note] Note

If for testing purposes or by mistake a JDBC driver is selected during the PARTsolutions setup, here, the respective entry is made.

If however an ODBC driver shall be used, set the correct driver here.

Determine ODBC or JDBC database interface for each operating system. 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

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

This configuration file is only available if a link database with the required driver is used.

[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 you determine the default interface and then refer to the selection <default> in the list field.

[Note] Note
  • If no dbproxy.cfg is available in C:\ProgramData\cadenas\partsolutions\setup, the ODBC driver will be 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!