UMDW Manual Installation
(If the UMDW installer does not work, you experience problems, or you would like to manually check or install UMDW; here at some things to check)
Log onto the machine using a account that has admin privileges on the computer
Run UMDW Installer:
Download the UMDW Installer and 'Run as Administrator'
(Be sure to reboot after running the installer)
Install ODBC Drivers:
Check whether Microsoft Access is 32-bit or 64-bit and navigate to either:
-
c:\instantclient_18_5\odbc_install.exe
-
c:\instantclient_18_5_64\odbc_install.exe (for 64-bit versions of Office)
Right click the odbc_install.exe and 'Run as Administrator'
Set Environment Variables:
(These should be set already from running the installer)
Navigate to Control Panel->System->Advanced System Settings->Environment Variables
Set PATH:
(Edit Path) Look in 'System Variables' for Path.
Use 'Edit', 'New', and add the proper variable below to the path, then move to the top or font of the list:
- For 32 bit Access Users: c:\instantclient_18_5
- For 64 bit Access Users: c:\instantclient_18_5_64
Set TNS_ADMIN:
Look in 'System Variables' for TNS_ADMIN
IF this is a computer joined to the UM domain, set TNS_ADMIN to: \\ummso1\banner\orant\network\admin
(Make sure the user has access to this path, this is the most common cause of the TNS error below)
Note: If user logs into windows from non UM domain and cannot access the path above.
set TNS_ADMIN to: c:\instantclient_18_5 or set TNS_ADMIN to: c:\instantclient_18_5_64
When all is set correclty, the Path and TNS_ADMIN System Variables should look like this:
- Path = C:\instantclient_18_5_64\...
- TNS_ADMIN = \\ummso1\banner\orant\network\admin
Set the System DSN:
- Open either the 32-bit or 64-bit ODBC Data Source Administrator, depending on the version of Microsoft Access you have installed.
- Select the System DSN Tab. You should see UMDW.WORLD in the list, if not:
- Click the 'Add' button
- Select 'Oracle in instantclient_18_5, click Finish
- Enter 'UMDW.WORLD' in the first three text boxes
- Click 'OK'
Create Shortcut on users desktop:
- Navigate to C:\Users\Public\UMDW
- Right click on a2bfinancials32.accdb for the 32 bit version
- Or
- Right click on a2bfinancials64.accdb for the 64 bit version
- Create Shortcut and place this shortcut on users desktop
- Change the shortcut icon to C:\Users\Public\UMDW\umdw.ico
- Rename the icon UMDW
- Remove other UMDW icons from the users� desktop.
To Login:
- Double Click on the desktop icon to open UMDW
- Click Open if you see a Microsoft Access security notice
- If a yellow security warning bar is across the top of the application make sure you click 'Enable Content' before you continue.
- Type umdw.world for the Data Source Name (DSN)
- Log In with User Name and password.
Note: This is a separate account that you should have received, not linked to the NetID password. To Request a UMDW account download the Account Request Form.