Oracle 10g ODBC Installation Guide
Oracle 10g ODBC InstallationGuideVoyager 7.2.1
CONFIDENTIAL INFORMATIONThe information herein is the property of Ex Libris Ltd. or its affiliates and any misuse or abusewill result in economic loss. DO NOT COPY UNLESS YOU HAVE BEEN GIVEN SPECIFICWRITTEN AUTHORIZATION FROM EX LIBRIS LTD.This document is provided for limited and restricted purposes in accordance with a bindingcontract with Ex Libris Ltd. or an affiliate. The information herein includes trade secrets and isconfidential.DISCLAIMERThe information in this document will be subject to periodic change and updating. Please confirmthat you have the most current documentation. There are no warranties of any kind, express orimplied, provided in this documentation, other than those expressly agreed upon in theapplicable Ex Libris contract. This information is provided AS IS. Unless otherwise agreed, ExLibris shall not be liable for any damages for use of this document, including, without limitation,consequential, punitive, indirect or direct damages.Any references in this document to third‐party material (including third‐party Web sites) areprovided for convenience only and do not in any manner serve as an endorsement of that third‐party material or those Web sites. The third‐party materials are not part of the materials for this ExLibris product and Ex Libris has no liability for such materials.TRADEMARKSʺEx Libris,ʺ the Ex Libris bridge , Primo, Aleph, Alephino, Voyager, SFX, MetaLib, Verde,DigiTool, Preservation, URM, ENCompass, Endeavor eZConnect, WebVoyáge, Citation Server,LinkFinder and LinkFinder Plus, and other marks are trademarks or registered trademarks of ExLibris Ltd. or its affiliates.The absence of a name or logo in this list does not constitute a waiver of any and all intellectualproperty rights that Ex Libris Ltd. or its affiliates have established in any of its products, features,or service names or logos.Trademarks of various third‐party products, which may include the following, are referenced inthis documentation. Ex Libris does not claim any rights in these trademarks. Use of these marksdoes not imply endorsement by Ex Libris of these third‐party products, or endorsement by thesethird parties of Ex Libris products.Oracle is a registered trademark of Oracle Corporation.UNIX is a registered trademark in the United States and other countries, licensed exclusivelythrough X/Open Company Ltd.Microsoft, the Microsoft logo, MS, MS‐DOS, Microsoft PowerPoint, Visual Basic, Visual C ,Win32,Microsoft Windows, the Windows logo, Microsoft Notepad, Microsoft Windows Explorer,Microsoft Internet Explorer, and Windows NT are registered trademarks and ActiveX is atrademark of the Microsoft Corporation in the United States and/or other countries.Unicode and the Unicode logo are registered trademarks of Unicode, Inc.Google is a registered trademark of Google, Inc.Copyright Ex Libris Limited, 2011. All rights reserved.Document released: July 2011Web address: http://www.exlibrisgroup.com
Table of ContentsUpdates to This Guide. 5Chapter 1Introduction . 7About This Guide . 7Automation Tool .8Microsoft XP, Vista, or Windows 7 .8Before You Start . 8Terminology . 9Why All the Reboots?. 9Chapter 2Downloading the Installation Packages. 11Before You Start . 11Confirm Disk Space .11Directories .11Downloading. 11Extracting . 12Chapter 3Backing Up the Current Oracle Configuration . 13Backing Up . 13Chapter 4Uninstalling Previous Versions of Oracle . 17Removing a Previous Version . 17Chapter 5Installing Oracle 10g ‐ XP/Vista . 21Installing Oracle 10g for XP/Vista . 21Chapter 6Installing Oracle 10g ‐ Windows 7. 23Installing Oracle 10g for Windows 7 . 23Chapter 7Configuring Oracle. 31Before You Start . 31Upgrade Instructions . 32New Installation Instructions . 33Completing the Configuration. 35Chapter 8Prepackaged Reports . 37Before You Start . 37Linking Prepackaged Reports. 38July 20113
Oracle 10g ODBC Installation GuideTable of ContentsChapter 9Troubleshooting. 49First Steps. 49Error Codes. 50Other Possible Errors . 514July 2011
Updates to This GuideThis guide contains the following updates:July 2011 Updated the Downloading section on page 11. Updated the guide format (headers and so forth)5
Oracle 10g ODBC Installation GuideUpdates to This Guide6July 2011
1IntroductionThis section includes: About This Guide on page 7 Before You Start on page 8 Terminology on page 9 Why All the Reboots? on page 9About This GuideThe purpose of this guide is to provide direction for the following componentsof the Oracle 10g ODBC installation: Preinstallation considerationsSee Before You Start on page 8, Terminology on page 9, and Why All theReboots? on page 9. Downloading the Installation Packages Running the Ex Libris automation tool (BEAT)See Automation Tool on page 8 for details about the tool.July 2011 Backing Up the Current Oracle Configuration Uninstalling Previous Versions of Oracle Installing Oracle 10g ‐ XP/Vista or Installing Oracle 10g ‐ Windows 7 Configuring Oracle Prepackaged Reports Troubleshooting7
Oracle 10g ODBC Installation GuideChapter 1: IntroductionAutomation ToolTo simplify completing your installation, Ex Libris designed a tool to automateas much of the process as feasible. The following .bat files are provided forrunning the automated installation process: BEAT.bat(Microsoft Windows XP version from the package download10201 client win32.zip) BEAT.bat(Microsoft Windows Vista version from the package download10203 client vista-win7.zip) BEAT-win7.bat(Microsoft Windows 7 version from the package download10203 client vista-win7.zip)Specifically with the Microsoft Windows 7 version of the automated tool, youmay need to perform some manual steps. The instructions in Installing Oracle10g ‐ Windows 7 on page 23 guide you through using the automated tool,performing the manual steps, and returning to the tool to complete yourinstallation.Microsoft XP, Vista, or Windows 7The installation instructions are divided by operating system environment. ForMicrosoft XP and Microsoft Vista, see Installing Oracle 10g ‐ XP/Vista onpage 21; and for Microsoft Windows 7, see Installing Oracle 10g ‐ Windows 7on page 23.Before You Start8 If you run into problems at any point, stop and seek assistance from ExLibris Global Customer Support. The Oracle 10g client replaces any pre‐existing client and is backwardscompatible with Oracle 8i and Oracle 9i servers. Make sure your Windows logon has local administrator rights before youbegin. Your IT department can assist you if you are unsure or do not havelocal administrator rights. Once the uninstall process has started, do not leave it unattended or startworking on a different application until you have completed the process.Doing either may cause the application to freeze and require a reboot toresolve any problem. Rebooting at the wrong time could greatly complicatethe uninstall process.July 2011
Oracle 10g ODBC Installation GuideChapter 1: Introduction Shut down all other applications. Temporarily, disable any PC firewall andvirus software before running the applications. If you are running Norton AntiVirus 2006 or later, ODBC linking does notwork by default. Read Microsoftʹs knowledge base article 329820 for help.Otherwise, consult with your IT department. The Ex Libris automation tool (BEAT.bat or BEAT-win7.bat) is designedand tested for use with Voyager. If you have other Ex Libris applications, contact Ex Libris Global CustomerSupport for assistance. If you have non‐Ex Libris applications that use ODBC, check with your ITdepartment before proceeding. If this is a new installation of the ODBC drivers, you can skip Backing Upthe Current Oracle Configuration that starts on page 13 and UninstallingPrevious Versions of Oracle that starts on page 17.Terminology You may read or hear a reference to a driver CD. Years ago, the ODBCdrivers were shipped out on a CD, but the prevalence of high‐bandwidthnetwork connections has made CD distribution obsolete. You can burn the contents of the downloaded zip file to a CD for archivalpurposes or for intra‐library installation. If persistent network issues prevent you from downloading the zip file, youcan request a physical CD from Ex Libris. Specify the Windows version youneed.Why All the Reboots?For a cleaner and faster uninstall (and install) process, rebooting the PC:July 2011 Just before critical work helps minimize services competing for systemresources. And then shutting down all the other programs minimizes programfragments and memory leaks. After making registry changes ensures that the link between PC files and theprevious registry data no longer exists.9
Oracle 10g ODBC Installation GuideChapter 1: Introduction10July 2011
2Downloading the Installation PackagesThis section includes: Before You Start on page 11 Downloading on page 11 Extracting on page 12Before You StartConfirm Disk SpaceThe download requires 500MB of free space.The installation requires an additional 500MB of free space.DirectoriesCreate a directory such as C:\Oracle10g on your PC to which you can extractthe package.DownloadingThe packages available for download can be accessed from the Ex Libris FTPserver (downloads.exlibrisgroup.com). You need the odbc password, whichcan be obtained from the eService knowledge base.The package you need to download is determined by your operating systemenvironment. For Microsoft XP, download the 10201 client win32.zippackage. For Microsoft Vista and Microsoft Windows 7, download the10203 client vista-win7.zip package.July 201111
Oracle 10g ODBC Installation GuideChapter 2: Downloading the Installation PackagesExtractingExtract the downloaded file to the directory you created. The WinZip software is commonly used for this process. Check with your IT department if you are unsure which program to use.Ensure you preserve the folder names when you extract the file. In WinZip, select the Use folder names option. Check with your IT department or software vendor if using othersoftware.The Oracle 10g ODBC package is ready to install.12July 2011
3Backing Up the Current OracleConfigurationThis section includes: Backing Up on page 13NOTE:The Oracle backup configuration step should only be run if there isalready a working Voyager ODBC configuration. If your PC has neverhad Oracle ODBC drivers on it, you can skip to Installing Oracle 10g ‐ XP/Vista on page 21 or Installing Oracle 10g ‐ Windows 7 on page 23.Backing UpTo back up your current Oracle configuration:1Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool. BEAT.bat located in C:\Oracle10g\10201 client win32 (MicrosoftXP) BEAT.bat located in C:\Oracle10g\10203 client vista-win7(Microsoft Vista) BEAT-win7.bat located in C:\Oracle10g\10203 client vista-win7(Microsoft Windows 7)For the Microsoft Windows 7 environment only, run the BEAT tool asAdministrator from the command line as follows:July 2011aClick Start All Programs Accessories Command Prompt.bRight click Command Prompt.13
Oracle 10g ODBC Installation GuideChapter 3: Backing Up the Current Oracle ConfigurationcClick Run as administrator.The command line window opens.dChange the directory (cd) to the location of the unzipped files,specifically, the location of the BEAT-win7.bat file.Figure 1:eRun BEAT-win7.bat from the command line.IMPORTANT:Using this method to run BEAT in the Windows 7 environment isnecessary to insure that the BEAT tool is able to access all the files that itneeds.4Back up TNSNAMES.ORA with option 1, Backup 9i tnsnames.ora.Figure 2:Notepad opens to display the tnsnames.ora file.14July 2011
Oracle 10g ODBC Installation GuideChapter 3: Backing Up the Current Oracle ConfigurationFigure 3:56Compare your tnsnames.ora file with the file in the above illustration. If your file and the above illustration look similar, close Notepad. If your file is blank or significantly different from the above illustration,stop and contact Ex Libris Global Customer Support before proceeding.Press any key to return to the Ex Libris automation tool.The Oracle ODBC configuration is now backed up.July 201115
Oracle 10g ODBC Installation GuideChapter 3: Backing Up the Current Oracle Configuration16July 2011
4Uninstalling Previous Versions of OracleThis section includes: Removing a Previous Version on page 17Removing a Previous VersionTo remove the previous version of your current Oracle client:1Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool. BEAT.bat located in C:\Oracle10g\10201 client win32 (MicrosoftXP) BEAT.bat located in C:\Oracle10g\10203 client vista-win7(Microsoft Vista) BEAT-win7.bat located in C:\Oracle10g\10203 client vista-win7(Microsoft Windows 7)For the Microsoft Windows 7 environment only, run the BEAT tool asAdministrator from the command line as follows:aClick Start All Programs Accessories Command Prompt.bRight click Command Prompt.cClick Run as administrator.The command line window opens.dJuly 2011Change the directory (cd) to the location of the unzipped files,specifically, the location of the BEAT-win7.bat file.17
Oracle 10g ODBC Installation GuideChapter 4: Uninstalling Previous Versions of OracleFigure 4:eRun BEAT-win7.bat from the command line.IMPORTANT:Using this method to run BEAT in the Windows 7 environment isnecessary to insure that the BEAT tool is able to access all the files that itneeds.4Remove Oracle clients.aSelect option 2, Remove Oracle 9i Client.Figure 5:You are prompted to Press any key to continue.CAUTION:Do not press any key.b18Type remove and press Enter.July 2011
Oracle 10g ODBC Installation GuideChapter 4: Uninstalling Previous Versions of OracleFigure 6:cEnter Y and press Enter if you are sure you want to remove all existingOracle clients.Figure 7:You see a number of errors on the screen. These are normal and can beignored.Figure 8:d5When prompted, press any key.Restart your computer.Log on to the PC and ensure that there are no open programs.6Repeat this procedure starting at Step 3.If this is the second time reaching this step, you are done.The pre‐10g Oracle ODBC is now successfully uninstalled.July 201119
Oracle 10g ODBC Installation GuideChapter 4: Uninstalling Previous Versions of Oracle20July 2011
5Installing Oracle 10g - XP/VistaThis section includes: Installing Oracle 10g for XP/Vista on page 21NOTE:Confirm that you have the correct version, from Ex Libris, of the Oracle10g installation software for your version of Microsoft Windows. TheOracle 10g CD from Oracle cannot be used with this procedure. SeeDownloading the Installation Packages on page 11 regardingdownloading the installation materials that you need.Installing Oracle 10g for XP/VistaThis section provides installation instructions for the Microsoft XP or MicrosoftVista operating system environments. For Microsoft Windows 7, see InstallingOracle 10g ‐ Windows 7 on page 23.To install:July 20111Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool, BEAT.bat, located inC:\Oracle10g\10201 client win32 (Microsoft XP) orC:\Oracle10g\10203 client vista-win7 (Microsoft Vista).21
Oracle 10g ODBC Installation GuideChapter 5: Installing Oracle 10g - XP/Vista4Install Oracle 10g.aSelect option 3, Install Oracle 10g Client.Figure 9:bWhen prompted, answer Y to install the Oracle 10g client.CAUTION:Do not attempt to change the window focus during this process.cWait for a message indicating that the installation has completed.NOTE:This may take up to 10 minutes.Figure 10:dPress Enter to close the install windows.ePress Enter to return to the Ex Libris automation tool.Oracle 10g ODBC is now successfully installed.22July 2011
6Installing Oracle 10g - Windows 7This section includes: Installing Oracle 10g for Windows 7 on page 23NOTE:Confirm that you have the correct version, from Ex Libris, of the Oracle10g installation software for your version of Microsoft Windows. TheOracle 10g CD from Oracle cannot be used with this procedure. SeeDownloading the Installation Packages on page 11 regardingdownloading the installation materials that you need.Installing Oracle 10g for Windows 7This section provides installation instructions for the Microsoft Windows 7operating system environment. For Microsoft XP or Microsoft Vista, seeInstalling Oracle 10g ‐ XP/Vista on page 21.NOTE:For the Microsoft Windows 7 version of the installation, there are somemanual steps that you need to complete in addition to running theautomated tool to install the Vista ODBC drivers on your MicrosoftWindows 7 system. Installing Oracle 10g for Windows 7 below describeshow to use the Ex Libris automation tool and what manual steps toperform.To install:July 20111Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool, BEAT-win7.bat, located inC:\Oracle10g\10203 client vista-win7.23
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7For the Microsoft Windows 7 environment only, run the BEAT tool asAdministrator from the command line as follows:aClick Start All Programs Accessories Command Prompt.bRight click Command Prompt.cClick Run as administrator.The command line window opens.dChange the directory (cd) to the location of the unzipped files,specifically, the location of the BEAT-win7.bat file.Figure 11:eRun BEAT-win7.bat from the command line.IMPORTANT:Using this method to run BEAT in the Windows 7 environment isnecessary to insure that the BEAT tool is able to access all the files that itneeds.4Install Oracle 10g.Select option 3, Install Oracle 10g Client.24July 2011
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7Figure 12:The Welcome screen displays.Figure 13:5Click Next.The Available Product Components screen displays.July 201125
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7Figure 14:6Click Next.The Product‐Specific Prerequisite Checks screen displays.26July 2011
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7Figure 15:NOTE:The operating system version check fails. This is okay. However, youneed to select the check box to the right of the highlighted error message(manual check) and click Next to continue with the installation.7Click Yes to continue processing when you receive the warning message.Figure 16:The Summary screen displays with the correct products selected.July 201127
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7Figure 17:8Click Install.The installation takes a few minutes. A patch is also installed.The Oracle Net Configuration Assistant: Welcome screen displays.28July 2011
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 7Figure 18:9Select the Perform typical configuration check box and click Next.Another Welcome screen displays.Figure 19:10 Click Next.July 201129
Oracle 10g ODBC Installation GuideChapter 6: Installing Oracle 10g - Windows 711 Click Finish when the Oracle Net Configuration Complete screen displays.12 Click Exit when the End of Installation screen displays.13 Click Yes when prompted with the exit warning.30July 2011
7Configuring OracleThis section includes: Before You Start on page 31 Upgrade Instructions on page 32 New Installation Instructions on page 33 Completing the Configuration on page 35Before You StartIf this an upgrade from Oracle 9i and the steps in the Backing Up the CurrentOracle Configuration on page 13 were followed, proceed to the UpgradeInstructions on page 32.If this is a new installation of Oracle 10g, proceed to the New InstallationInstructions on page 33.After either section, continue to Completing the Configuration on page 35.After completing either the new or upgrade instructions, the PC should have atnsnames.ora file in C:\oracle\product\10.2.0\client\NETWORK\ADMIN\with the following stanza:July 201131
Oracle 10g ODBC Installation GuideChapter 7: Configuring OracleVGER (DESCRIPTION (ADDRESS LIST (ADDRESS (PROTOCOL TCP)(HOST xxx.xxx.xxx.xxx)(PORT 1521)))(CONNECT DATA (SID VGER)))Upgrade InstructionsTo upgrade:1Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool (BEAT).4Restore TNSNAMES.ORA.aSelect option 4, Update tnsnames.ora.Figure 20:b32Select option 7, Restore backup TNSNAMES.July 2011
Oracle 10g ODBC Installation GuideChapter 7: Configuring OraclecEnter Y if you are sure you want to restore.Figure 21:d5Press Enter to return to the Ex Libris automation tool.Continue to Completing the Configuration on page 35.New Installation InstructionsTo configure a new installation of Oracle:1Restart your computer.2Log on to the PC and ensure that there are no open programs.3Start the Ex Libris automation tool (BEAT).4Create a TNSNAMES.ORA.aSelect option 4, Update tnsnames.ora.Figure 22:bJuly 2011Select option 1, Add VGER Instance ‐ Voyager.33
Oracle 10g ODBC Installation GuideChapter 7: Configuring OracleFigure 23:cEnter the IP Address of your Voyager server.Figure 24:534dEnter Y to confirm when prompted.ePress Enter to return to the Ex Libris automation tool (the Updatetnsnames.ora section).fEnter option B, Back, to return to the Ex Libris automation tool mainmenu.Continue to Completing the Configuration on page 35.July 2011
Oracle 10g ODBC Installation GuideChapter 7: Configuring OracleCompleting the ConfigurationTo update ODBC Configuration:1Select option 5, Update ODBC Configuration.Figure 25:2Select option 6, Save and Clear System ODBC Configuration.CAUTION:Under Windows XP Professional SP2, the option 6, Save and Clear SystemODBC Configuration, may remove all System DSNs. Instead of selectingthis option, proceed to Step 3.3July 2011(Alternative) Use the Registry Editor, regedit.exe, to make the followingregistry changes:aIn HKEY LOCAL MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC DataSources, delete the key‐value pair voyager Microsoft ODBC forOracle and replace it with VGER Microsoft ODBC for Oracle.bIn HKEY LOCAL MACHINE\SOFTWARE\ODBC\ODBC.INI, rename thevoyager key to VGER.cSkip to Step 7 to quit the BEAT, and follow Step 8 to make additionalregistry changes.35
Oracle 10g ODBC Installation GuideChapter 7: Configuring OracleFigure 26:4Select option 1, Add VGER Instance ‐ Voyager.5Enter Y to confirm when prompted.6Press Enter to return to the Ex Libris automation tool (Update ODBCConfiguration).7Select option Q, Quit, to quit the Ex Libris automation tool.8Open the Registry Editor, regedit.exe, and search for NLS LANG.9For any occurences of NLS LANG, change the data value to:AMERICAN AMERICA.US7ASCIIOracle 10g ODBC is now successfully configured.36July 2011
8Prepackaged ReportsThis section includes: Before You Start on page 37 Linking Prepackaged Reports on page 38Before You StartThe procedures for linking tables with different versions of Microsoft Access aresimilar, but there are some differences. Instructions are provided for bothAccess 2007 and Access 2003.Record the following information on Table 1 to use in Linking PrepackagedReports on page 38: Your database nameFor example: xxxxdb Your read‐only ID and password (usually written as logon/password)Username ro xxxdbPassword ro xxxdbro xxxdb/ro xxxdb Database server name or IP address Oracle SIDFor Voyager 5.0 or higher, your SID is VGER.For Image Server, your SID is VGER.For an earlier version of Voyager or Endeavor Heritage Digital Products,contact Ex Libris Global Customer Support.July 201137
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportsTable 1. Access for Linking Prepackaged ReportsVoyager Database Name:Read‐Only User ID:Read‐Only User Password:Server Name or IP Address:Oracle SID:Contact Ex Libris Global Customer Support if you need assistance with any ofthis information.Linking Prepackaged ReportsTo link prepackaged reports for Access 2007:1Open the Voyager Access Reports file.This is also referred to as the Reports.mdb file.NOTE:If this file does not exist, confirm that Voyager Access Reports wasinstalled.You may see the security warning mentioned in Step e on page 39.2Get the external data to initiate the linking.aClick the External Data tab.Figure 27:b38Specify the ODBC databases. Under the More button, select ODBCDatabases.July 2011
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportsFigure 28:cSelect Link to data source by creating a linked table.Figure 29:The Select Data Source screen displays.dClick the Machine Data Source tab, select the data source name thatmatches your Oracle SID, and click OK.Figure 30:eJuly 2011Approve the security warning.39
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportsFigure 31:Figure 32:The Microsoft ODBC for Oracle Connect dialog box displays.fEnter the read‐only user ID, your read‐only user password, your OracleSID, and click OK.Figure 33:The Link Tables dialog box displays.40July 2011
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportsNOTE:It may take a few minutes to display.Figure 34:gFor Voyager, click Deselect All and click OK.For Endeavor Heritage Digital Products, highlight the first through thelast table (using SHIFT/Click), click OK, and contact Ex Libris GlobalCustomer Support for assistance in completing your installation.July 201141
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged Reports3Build database links.aUnder Objects, select the Forms option.Figure 35:bDouble‐click Build database links to Voyager.The Build links to Voyager screen displays.42cEnter the Oracle SID for the ODBC Name, the Oracle SID for theConnect String, the read‐only user ID for DB User ID, the read‐onlyuser password for Password, and the Voyager database name for theTablespace.dConfirm that the Relink check box is selected.July 2011
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportseClick Connect.Figure 36:Each table is listed as it is successfully linked.The ALL TAB COLUMNS table does not link.NOTE:This is not an error.fOnce the tables have completed linking, click Close.The prepackaged reports are now successfully linked.To link prepackaged reports for Access 2003:1July 2011Set the security level.aStart MS Access.bSelect Tools ‐ Macro ‐ Security ‐ Security Level.cSelect the Low option.dClick OK.eWhen prompted, click Yes.43
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged Reportsf2Close and restart MS Access.Open the Voyager Access Reports file.This is also referred to as the Reports.mdb file.NOTE:If this file does not exist, confirm that Voyager Access Reports wasinstalled.3Get the external data to initiate the linking.aSelect File ‐ Get External Data ‐ Link Tables.Figure 37:b44Specify the ODBC databases by clicking the Files of Type drop‐downlist located at the bottom of the screen and selecting ODBC Databases.July 2011
Oracle 10g ODBC Installation GuideChapter 8: Prepackaged ReportsFigure 38:The Select Data Source screen displays.cClick the Machine Data Source tab, select the data source name thatmatches your Oracle SID, and click OK.Figure 39:The Microsoft ODBC for Oracle Connect dialog box displays.July 201145
Oracle 10g ODBC Installation GuideChapter 8: P
The Oracle backup configuration step should only be run if there is already a working Voyager ODBC configuration. If your PC has never had Oracle ODBC drivers on it, you can skip to Installing Oracle 10g ‐ XP/
C. Shahabi 12 Database Interaction ODBC : ODBC (Open Database Connectivity) )provides a way for client programs (eg Visual Basic, Excel, Access, Q E etc) to access a wide range of databases or data sources ODBC stack )ODBC Application :Visual Basic, Excel, Access )Driver Manager :ODBC.DLL )ODBC Driver :ODBC Driver varie
IBM DB2/UDB for zSeries 9.1 DB2 Client 9.1 Yes IBM Informix Dynamic Server 10.0 IBM Informix ODBC SDK 2.90 Yes DataDirect ODBC 5.3 (3) Yes IBM Informix Dynamic Server 11.1 IBM Informix ODBC SDK 3.50 Yes DataDirect ODBC 5.3 (3) Yes IBM Informix Dynamic Server 11.5 IBM Informix ODBC SDK 3.50 Yes DataDirect ODBC 5.3 (3) Yes
Oracle 12c client or the Oracle 12c ODBC Driver (or both). Some report writing tools, such as SAS or Crystal Reports, can use either the Oracle client to access the database directly in its own language, or use the Oracle 12c ODBC Driver to access the database indirectly using ODBC as a type of middle-layer “translator”. For example, Microsoft
Dell PowerEdge R630 Intel E5-2650 v4 2x12x2 2.2 10G Intel 82599ES (ixgbe) 10G Chelsio T520-CR (cxgbe) 10G Mellanox ConnectX-3 Pro (mlx4en) 10-50G Mellanox ConnectX-4 LX (mlx5en) HP ProLiant DL360p Gen8 Intel E5-2650 v2 8x2 2.6 10G Chelsio T540-CR (cxgbe) 10G Emulex OneConnect be3 (oce) SuperMicro 5018A-FTN4 Intel Atom C2758 8 2.4 10G Chelsio .
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters
including Oracle Express Edition 11g and 10g; as well as Oracle Cloud. ODBC Driver for Oracle supports both x86 and x64 versions of the following Oracle Clients: 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, Oracle Instant Client. Note that support for x64 versions of Oracle Clients is available for 64-bit Windows. High Performance
weekend, your pet will be kept at the airport due to customs duty hours. If possible pets should arrive during weekday/daytime hours to prevent unnecessary stress for the pet or owner. Commercial Airline Transport . If flying commercially, contact the airline prior to purchasing tickets to ensure pets will actually be able to fly on the day of travel (e.g. ask about the airline’s regulations .
