Installing SAS ODBC Driver to Use MS Access with Data Warehouse

The SAS driver for ODBC connects your computer to Data Warehouse reports when using MS Access.

Note: The ODBC driver is available for Windows only. Mac users can access historical BASIS data using the SAS Web Application.

Step 1: Getting Started

If you are off campus, you must connect to the campus VPN to download the driver and complete the setup. VPN is also required whenever accessing Data Warehouse from off campus.

Administrative access is required to install this driver. For assistance, contact your department tech support.

Step 2: Download ODBC Driver

1. Map a drive to gizmo using the address:
   \\gizmo\dfs\applications\SAS-BI\SAS94M7
2. Double-click the odbc folder, and then double-click setup.exe. 
3. Click Yes to allow SDW Bootstrap in d4deploy to make changes to the device. If required to log in, use your full UARK email address and password.
   Note: Please allow up to several minutes for the installer to load. 
4. Click OK to Choose Language.
5. In Select Deployment Task, select Install SAS software. Click Next.
6. Check the box for "SAS Drivers for ODBC." Click Next.
7. Confirm that the path and filename in the SAS installation data file field is:
   \\gizmo\dfs\applications\SAS-BI\SAS94M7\odbc\sid_files\SAS94_9CKJRM_70206997_Win_X64_Wrkstn.txt
   Note: You might have to click in the SAS installation data file field and select this path from the dropdown.
8. Click Next.
9. In Select Language Support, click Clear All and then click Next.
10. In Select Regional Settings, click Next.
11. When Checking System is complete, click Next.
12. In Deployment Summary, click Start. Allow several minutes for installation to complete. Click Next.
13. In the Select Support Option window, click Next.
14. In the Additional Resources window, click Finish.

Step 3: Edit the Registry File

1. Map a drive to gizmo using the address:
   \\gizmo\dfs\applications\SAS-BI
2. Copy the dwh32WhareHouse.reg file to the c:\users\username folder on your local computer.
3. Right-click the local dwh32WhareHouse.reg file, and click Edit.
4. Scroll to the bottom of the file to the line:
   "UserName"=”YOUR ID”
5. Change “YOUR ID” to your UARK username, for example:
   "UserName"="jdoe"
6. Save the file and exit.
7. Right-click the dwh32Wharehouse.reg file, and click Merge.
8. Click Yes to update the Registry Editor.