ODBC database transfer

The data transfer between external database and M3 SWB can be managed using ODBC. ODBC provides the advantage of allowing ODBC logic when retrieving data. ODBC uses the PSDB.DLL to communicate with the external database.

Variables in the M3 SWB ODBC INI file

These variables defined in the M3 SWB INI file PSDB.INI are used by the PSDB.DLL:
  • uid

    This variable states the user ID.

  • pwd

    This variable states the password for the user.

  • dsn

    This variable states the data source name.

  • level

    This variable states the log level. (0=No logging and 10=Log everything)