powered by CADENAS

Manual

Manual

5.2.6. Database connection via file DSN

Advantage:

A central place for saving connection data. Changes only need to occur in this place during database or computer changes!

[Note] Note

The ODBC driver must be installed on all clients!

(Not applicable for JDBC drivers)

Example using the database server MySQL:

First create the file mysql_filedsn.dsn in the $CADENAS_DATA directory.

Contents:

[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
Description = PARTsolutions - intelligentes Teilemanagement
SERVER = \\yourDBServerName.yourDomain
PORT =
USER = root
Password =
Database = partlinkdb
OPTION = 3
SOCKET =

In the ODBC data source administrator the file shows up in the DSN file rider:

Configuration in PARTsolutions:

PARTlinkManager:

Extras -> Configure ERP environment -> Rider Database -> Field Database.

Name such as $CADENAS_DATA can also be used in the path.

In the lower left corner in PARTlinkManager the following shows up after successful connection: Connection established.