Generally, the version of Oracle Database Client should match the bitness of the client's installed version of Microsoft Office. Oracle provides both 32-bit and 64-bit versions of Oracle Database Client. This client is a prerequisite for several applications like SCOOP and SAS.
Oracle Database Client is used by a range of analysts and managers throughout every department within the VPF senior management area. Using this software, applications such as Excel can interface directly with an Oracle database. that allows client computers to connect to Oracle databases across a network. If you wish to use Windows integrated security speak to your DBA (database administrator).Oracle Database Client is software from Oracle, Inc. You will need to talk to the DBA (database administrator) that manages the Oracle server. Please contact us at if you need to know the latest supported version of the ODBC drivers.Īuthentication errors usually relate to how the Oracle Server you are connecting to is setup.
Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources - always use the 64 bit ODBC Administrator.
Install the latest Oracle ODBC drivers:.Follow the same procedure used for Oracle Easy Connect: Setup the Windows Oracle OCI drivers.The Oracle ODBC package depends on the OCI drivers - so you need to set them up first. Setup the Oracle instant client OCI drivers:.If you need to know which versions of Oracle drivers are supported by the version of Iguana you are using please contact us at set up a new ODBC data source for Oracle Server: This is particularly true if you are not able to use the the latest version of Iguana. Note: Iguana may not always support the very latest version of Oracle drivers, so you can simply download an earlier version if necessary. The name is the name of an ODBC source that you create using the ODBC Administrator.If your script uses connection object methods conn:query Your channel will need a From/To Translator or a Filter component. Name: DB Oracle Connection (or similar).Create a new channel to try out the code:.We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples. We recommend using system DSNs (available to all users).