Acctivate includes the free Microsoft SQL Server Express Edition. You can easily upgrade to SQL Server Standard Edition for increased capacity and performance when necessary. Instructions Microsoft SQL Server Edition upgrades are handled through the standard SQL Server installer (setup.exe). Please…
You may be required to upgrade to a newer Microsoft SQL Server version and/or edition. For example, SQL Server 2005 Express Edition only supported databases up to 4GB. The size limit in the Express Edition was increased to 10GB in…
Updating ODBC Connection to Use Live Database If you originally setup UPS WorldShip to work with your practice company then you will need to follow these steps to update the ODBC connection to work with your live company. 1. Select…
Acctivate uses a Microsoft SQL Server database. The most common method for connecting to a SQL Server database is via Open Database Connectivity (ODBC). ODBC allows other software, such as the UPS or FedEx shipping workstation to connect to the Acctivate database.…
The following Data Views are available in the Acctivate (SQL Server) database for read-only use in reports, queries and exports. Please read this article for more information on using data views for reports. Data View Description Acctivate Screen Access Contains…
Microsoft SQL Server Express Edition is included with Acctivate and recommended for most new users. You also have the option to use an existing Microsoft SQL Server or install a new SQL Server instance. Microsoft supports a separate SQL Server…
Acctivate is configured to use the TCP/IP network option for connecting to the database server (i.e., Microsoft SQL Server). TCP/IP is a standard, reliable protocol for network connections. However, some computers may have trouble with one or more client workstations…
You may be asked to restart Microsoft SQL Server after an Acctivate installation or upgrade. Please use the following procedure to safely restart the database service. First, make sure that all connections to the SQL Server are closed. Verify that…
Product Inventory Type (Item Type) Inventory Session Type 0 = Non inventoried 1 = Inventoried 2 = Drop Ship only 3 = Special Order only 100 = Labor 101 = Other Charges 102 = Shipping A = Adjustment I =…
Why does Acctivate use Microsoft SQL Server? The choice was clear for us. Microsoft SQL Server is a very stable, fast, extremely popular and affordable database engine. There is a tremendous amount of support and resources available on the web and…
