OCPE - Create ODBC Data Source for Aceware

OCPE uses an application named "AcewareSM" that needs an ODBC Data Source to run. This guide shows how to set up the data source.

AcewareSM

BigSky

 NOTE: An administrator password is needed to install and make changes to some files.  Also, the system requires the "ODBC Driver 11 for SQL Server" found here. 

CREATE ODBC SOURCE

1. In File Explorer, go to: C:\\Windows\Syswow64 folder.  Open Odbcad32.exe.
2. Click on User DSN tab.  Then click on the "Add" button.
3. Select ODBC Driver 11 for SQL Server.  Click the "Finish" button.
4. A new window, "Create a New Data Source to SQL Server" will open.  Fill out the following fields then click the "Next" button:
   1. Name: AcewareSM
   2. Description: Leave Blank
   3. Server: bigsky.vcu.edu
5. Click the button "With SQL Server authentication using a login ID and password entered by the user".  Enter Login ID as: acewareuser (no password is needed) . Click the "Next" button.
6. Click the button "Change the default database to:" and enter the name: Aceware . Click the "Next" button.
7. No changes are needed.  Click the "Finish" button.
8. A summary window will appear.  If all fields are correct, click the "OK" button.  If any changes are needed, click the "Cancel" button and make changes as needed.
   1. Note:  There is a "Test Data Source" button, but it will fail the test.  To verify the connection is okay, test in Aceware.