NOTE: There are two different attachments for the actual Act! reader itself. If you are using Act! version 20.1 or below, please make sure to download ActReader up to v20.1.zip. If you are using Act! version 21 or above, please make sure to download ActReader v21 and above.zip.
IMPORTANT NOTE: Swiftpage does not provide technical support for the Act! Reader Utility, or for setting up ODBC connections. For guidance on the information contained in this article, please refer to our Developer Forums on the Act! Community
An ODBC (Open Database Connectivity) connection is used to allow read-only access to a SQL database. This connection must be established to allow third-party software to directly connect to an ACT! Premium database using the ACT! Reader utility. The ACT! Reader utility is free and can be downloaded from the File Attachments section near the bottom of this article.
The ACT! Reader Utility can only be used to connect to ACT! Premium databases version 2005 (7.x) and higher.
For information on setting up and using the ACT! Reader Utility, please download the Administrator's Guide to the ACT! Reader Utility found in the File Attachments section of the bottom of this page. The guide indicates that it is for ACT! 2007 (9.0), but the information applies for newer versions as well.
Setting up an ODBC connection
- Do one of the following:
- On Windows® XP (2002) or Server 2003, click Start > Control Panel > Administrative Tools >,then double-click Data Sources (ODBC)
- On Windows Vista®, click Start > Control Panel > System Maintenance > Administrative Tool, then double-click Data Sources (ODBC)
- In the ODBC Data Source Administrator dialog box click Add
- In the Create New Data Source dialog box, scroll to the bottom of the "Select a driver for which you want to set up a data source" list, and select one of the following:
- SQL Server, if connecting to SQL Server 2000 or MSDE (ACT! 2005, 2006)
- SQL Native Client, if connecting to SQL Server 2005 or SQL Express (ACT! 2007 and higher)
- On the Create New Data Source to SQL Server screen, complete the following:
a. Type the desired Name and Description for the data source connection
b. In the Server box, type or select the computer name of the SQL server you would like to connect to.
Note: You can also type "local" when the database is on the same computer as the SQL server. Type "local\ACT7" (ACT7 is the SQL instance name).
c. Click Next
- On the next screen, do the following:
a. Select the "With SQL Server authentication using a login ID password and entered by the user."
b. In the Login ID box, type "ACTREADER."
c. In the Password box, type the password you previously set using the ACTReader utility. Click Next.
Click here for instructions to set or reset the ACT! Reader password
- Open Windows Explorer and browse to the following directory: C:\Program Files\ACT\Act for Windows. If using ACT! Premium for Web, then replace "Act for Windows" with "Act for Web" in the path.
- Locate the file ActReader.exe and double-click on it.
- You will get an ACT! Reader dialog box with a current password and the choice to change the password. If you do not know the current password, then create a new one and click Reset. You must use the TAB key on your keyboard to move between fields in the box in order for the Reset button to light up. Once you have reset the password, use it to set up the ODBC connection with ACT! Reader.
- On the next screen, select the Change the default database checkbox, and then select the database name from the Drop-Down list. Do not change any other default selections. Click Next.
- On the final screen, do not change any of the default options. Click Finish.
- The ODBC Microsoft® SQL Server Setup dialog box appears.
- (Optional) To ensure that you have configured the authentication properly, click Test Data Source. Otherwise, click OK until you close all dialog boxes and wizard screens.