powered by CADENAS

Manual

Manual

4.2.5. Configure the data-source for ODBC (exemplified by MSSQL)

ODBC connectivity to the database system regarding software and license has to be ensured by the customer.

[Note] Note

For a Client-Server installation make sure that ODBC is installed on each client!

In the following setting up the ODBC data-sources is explained exemplarily for MSSQL. The description also applies for other database types. Precondition is an ODBC driver compatible with the used database.

  1. Run the ODBC data-sources (preferably directly via exe file, in order to avoid conflicts due to the architecture).

    Run C:\Windows\SysWOW64\odbcad32.exe as administrator.

  2. Under System DSN add a new data source.

  3. For the driver select SQL Server and confirm with Finish.

  4. Enter Name, Description and Server address of the data source and then click on Next.

    [Note] Note

    The name in the field Name can be freely chosen (in above figure exemplarily "PLINKDB_MSSQL"). However, pleas ensure that in PARTlinkManager under Extras > Configure ERP environment > tabbed page Database -> Database -> Name the same entry is set.

  5. Perform settings in the dialog box Create a New Data Source to SQL Server according to the following figure.

  6. Click on Client configuration....

    [Note] Note

    Please ensure that the option Dynamically determine port is NOT set, but the fixed port 1433 is set and the option TCP/IP is selected.

    Close the dialog with click on OK.

  7. Click on Next.

    If now a connection error occurs, regard the following notes:

    • Cancel and quit the data-source Tool.

    • Check whether all ports for TCP/IP are set to 1433 in the SQL Configuration Manager.

    • Stop and restart the SQL Server Service.

    • Disable your firewall or define a complete in & out firewall exception for port 1433.

    • Start the data-source tool again and if your server is local try „localhost\SERVERNAME“ as Server address.

  8. Now change the default database to the just created and click on Next.

  9. In the next dialog perform the desired settings and click on Finish.

  10. Now test the data source:

    The result should look like this:

    The data source should now be displayed under System DSN.