English
Deutsch
Español
Français
Hrvatski
Italiano
Polski
Türkçe
Русский
中文
日本語
한국어
Legal notice
powered by CADENAS

Manual

Top Links

Manual

4.2.7. ERP-Anbindung aus PARTsolutions via ODBC/JDBC und ERP-Aktivierung
4.2.7.1. dbproxy.cfg
Zurück   Weiter

4.2.7.1. dbproxy.cfg

[Hinweis] Hinweis

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.

[Hinweis] Hinweis

  • 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!

Zurück  Nach oben  Weiter
4.2.7. ERP-Anbindung aus PARTsolutions via ODBC/JDBC und ERP-Aktivierung  Zum Anfang  4.2.7.2. plinkcommon.cfg -> Block [Common] -> Key "DBName" - Determine ODBC data source name in PARTsolutions