Configuring the Client/Server ODBC Driver

Note: This article applies to Sage 100 Advanced.

The Sage 100 Advanced server installs client/server ODBC driver components, which allow remote workstations to process worktables using server-side ODBC processing. Report rendering is completed using a locally cached copy of the form or report and a local SAP Crystal Reports print engine.

Server-Side Configuration

Set up the client/server ODBC driver to run as an application or as a service before configuring the server.

Running as an Application or Service

Determine whether to run the client/server ODBC driver as an application or as a service, and perform one of the following:

  • To run the client/server ODBC driver as an application, in Windows Explorer, locate and double-click the pvxiosvr.exe file in the following location:

    ..\MAS90\Home\pvxiosvr.exe

  • To run the client/server ODBC driver as a service, select File > Run on the server and enter the server’s local path to pvxiosvr.exe followed by the -i parameter. For example:

    X:\Sage\Sage 100 Advanced\MAS90\Home\pvxiosvr.exe -i

  • To uninstall previous versions of the client/server ODBC driver as a service, select File > Run on the server and enter the server’s local path to pvxiosvr.exe followed by the -u parameter. For example:

    X:\Sage\Sage 100 Advanced\MAS90\Home\pvxiosvr.exe -u

Configuring the Server

If you set up the client/server ODBC driver to run as a service, follow the procedure for your server’s operating system to configure the server.

Note: The screens may vary depending on your version of Windows Server.

To configure the server

  1. On the Sage 100 Advanced server, open Server Manager.

  2. In the Server Manager window, on the Tools menu, click Services. The Services window opens.

  3. In the services list, double-click Sage 100 Client Server ODCB Driver Service. The Properties window for the service opens.

  4. In the Properties window, on the General tab, select Automatic in the Startup type field.

  5. On the Log On tab, enter the login and password for a domain administrator-level account.

    Note: In some environments, not having the correct permissions may lead to a "Database logon failure" message when attempting to run reports

  6. Click the General tab, and then click Apply.

  7. Click Start and verify that the service starts successfully.

  8. Click OK.

Workstation Configuration

Use the Library Master System Configuration task to configure the workstation and then test the ODBC data source.

To configure the workstation

  1. In Sage 100 Advanced, select Library Master > Setup > System Configuration. The System Configuration window opens.

  2. On the ODBC Driver tab, select the Enable C/S ODBC Driver check box.

  3. In the ODBC Server Name field, enter the server name or IP address where the client/server ODBC application or service is running.

  4. In the ODBC Server Port field, enter an accessible server port or leave the field blank to use the default port, 20222.

  5. Perform one of the following:

    • If all users (both LAN and remote) will be using the client/server ODBC driver, select the Enable for All Users check box.

    • To enable the ODBC driver for an individual user, select Library Master > Main > User Maintenance. On the Preferences tab, select the Enable C/S ODBC Driver check box.

  6. Close and restart the workstation client.

  7. Access and test the ODBC data source.

    If you're running a 32-bit system, perform the following steps:

    1. Open the Windows Control Panel and double-click Administrative Tools.

    2. Double-click Data Sources (ODBC). The ODBC Data Source Administrator window opens.

    3. On the User DSN tab, double-click SOTAMAS90. The ProvideX ODBC Driver Setup window opens.

    4. Click the Debug tab, and then click Test Connection.

      If a message appears stating that the connection was successful, the client/server ODBC service is running correctly.

    If you're running on a 64-bit system, perform the following steps:

    1. On the Windows desktop, double-click the Computer icon.

    2. In the Computer window, locate the c:\windows\SysWOW64 folder.

    3. Double-click Odbcad32.exe. The ODBC Data Source Administrator window appears.

    4. On the User DSN tab, double-click the SOTAMAS90 item. The ProvideX ODBC Driver Setup window appears. Click the Debug tab, and then click Test Connection.

      If a message appears stating that the connection was successful, the client/server ODBC service is running correctly.

Note: If you encounter problems connecting to the client/server ODBC service, see Configuring the Workstation for the ODBC Driver Service.

Sharing Permissions

On the Sage 100 Advanced server, you can set the share permissions to allow users to print server reports. You can grant permissions at the share point to allow for Read, Change, or Full Control access. When printing a form or report, the user can print to any valid Windows printer, defer reports, or export or e-mail the report.

Users with no access to the Sage 100 Advanced share point on the server will be able to print to Deferred. To print or preview from Deferred Printing, users must have a minimum of Read access to the Sage 100 Advanced server share point.

For more information about setting permissions, see Sage 100 Security Permissions .