Users who process shipments on a computer that isn't on the same network as the Server in which your SQL Database is stored will need to setup a VPN Connection on the Shipping Workstation. The ODBC is not available on a different network.
For our users who may process shipments on a computer that isn't on the same network as the Server in which your SQL Database is stored, you will need to configure networking in order to be able to communicate with the SQL Server Database. UPS WorldShip and FedEx Ship Manager both use an ODBC Connection in order to connect to the SQL Server Database. The ODBC Connection is not available if your Shipments are processed in a location that is NOT on your network.
In order to work around this, you will need to provide some way for UPS/FedEx to communicate with your server. This can be accomplished by setting up a VPN Connection on the Workstation. Once the VPN Connection is configured, you will be able to continue with setting up the import/export of Acctivate Orders. You will then be able to import in Orders/Packages into UPS/FedEx.
You will need to have the VPN running each day in order for UPS/FedEx to import Orders and export Shipment information back to Acctivate.