• The Client/Server ODBC driver allows remote workstations to process worktables using server-side ODBC processing.
• This improves report and form printing performance, particularly over WAN or VPN connections.
• You can run the driver as an application or as a Windows service.
• Proper configuration ensures reliable connectivity and performance.

Run as an Application

1. Access the server where you installed Sage 100 Advanced.
2. Open Windows Explorer and locate pvxiosvr.exe in ..\MAS90\Home.
3. Right-click pvxiosvr.exe and select Run as Administrator.
4. Confirm the "ProvideX File Server" window shows "The Server is Running".

Run as a Service

1. Open an Administrator Command Prompt.
2. Enter the path to pvxiosvr.exe followed by -i (that is, "C:\Sage\MAS90\Home\pvxiosvr.exe" -i).
3. The system creates the service "Sage 100 ERP Client Server ODBC Driver Service" (PVXIOSVR).
4. To uninstall, use -u instead of -i.

Configure the Service

1. Open Control Panel, Administrative Tools, Services.
2. Find Sage 100 Client Server ODBC Driver Service.
3. Set Startup type to Automatic.
4. On the Logon tab, enter Domain Administrator credentials.
5. Start the service and make sure status shows Started.

Fixing Windows Service Issues

1. Update the registry key if you set up the service incorrectly:
   • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\PVXIOSVR.
   • Update ImagePath to the correct Sage path.
2. If prompted for login when running reports:
   • Temporarily disable the firewall to test.
   • Reinstall the Sage 100 Workstation Setup client if needed.

Configure Windows Firewall

1. Open Windows Firewall on the server.
2. Go to Inbound Rules, New Rule.
3. Select Program, browse to ..\MAS90\Home\pvxiosvr.exe.
4. Complete the wizard and name the rule.

Workstation Configuration

1. Log into Sage 100 Advanced.
2. Go to Library Master, Setup, System Configuration.
3. On the ODBC Driver tab, check Enable C/S ODBC Driver.
4. Enter the ODBC Server Name (server name or IP) and Port (default: 20222).
5. To enable for all users, check Enable for All Users; otherwise, enable per user in User Maintenance.

Testing the ODBC Data Source

• For 32-bit systems:
  • Open ODBC Data Source Administrator
  • Select SOTAMAS90 and click Configure
  • In ProvideX ODBC Driver Setup, test the connection
• For 64-bit systems:
  • Run ODBCAD32.exe from C:\Windows\SysWOW64
  • Repeat the steps above

Slow Performance printing Crystal forms or reports since upgrading from a version before Sage 100 2013
How to delete or disable a Service that is no longer in use