Oracle ODBC Driver Install: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 35: | Line 35: | ||
== Install Instructions == | == Install Instructions == | ||
# Copy zip file from | # Copy zip file from [[Regional Server]]\ICU\Maintenance\Software\Oracle_V9_Client to C:\ and extract, e.g. to C:\92010NT_CLT for these instructions | ||
===Install the Client Software=== | |||
Install the Client Software | |||
# run C:\92010NT_CLT\install\win32\setup.exe to open Oracle Universal Installer | # run C:\92010NT_CLT\install\win32\setup.exe to open Oracle Universal Installer | ||
# click on the "Installed Products" button; the list should be empty. If the list is not empty, you already have Oracle Client software on your system. In that case, the remaining instructions may not work. Abort the install. Find out why Oracle client software is installed and confirm with eHealth that there will be no problems with the other system; suggest that the desktop team should install the client to make sure both applications work afterward. | # click on the "Installed Products" button; the list should be empty. If the list is not empty, you already have Oracle Client software on your system. In that case, the remaining instructions may not work. Abort the install. Find out why Oracle client software is installed and confirm with eHealth that there will be no problems with the other system; suggest that the desktop team should install the client to make sure both applications work afterward. | ||
| Line 55: | Line 51: | ||
# ...(I may be missing a step now since I don't want to re-install as I write these up... fill in the blanks) | # ...(I may be missing a step now since I don't want to re-install as I write these up... fill in the blanks) | ||
Set Up the ODBC Connection | ===Set Up the ODBC Connection=== | ||
# Click on Start Menu --> Programs --> Oracle - OraHome92 --> Configuration and Migration Tools --> Micrsoft ODBC Administrator | # Click on Start Menu --> Programs --> Oracle - OraHome92 --> Configuration and Migration Tools --> Micrsoft ODBC Administrator | ||
# Click the "Add" button | # Click the "Add" button | ||
| Line 66: | Line 62: | ||
# Click "Test Connection", enter your password and click OK; you should get a "connection successful" window - if not, check your entries, if all are correct, contact eHealth | # Click "Test Connection", enter your password and click OK; you should get a "connection successful" window - if not, check your entries, if all are correct, contact eHealth | ||
Link the ODBC Connection into Access | ===Link the ODBC Connection into Access=== | ||
# In Access, click on File --> Get External Data --> Link Tables... | # In Access, click on File --> Get External Data --> Link Tables... | ||
# For file type (bottom box) choose "ODBC Databases()" at the bottom of the list | # For file type (bottom box) choose "ODBC Databases()" at the bottom of the list | ||