Connecting to an Instance of Oracle and Running SQL Scripts
InstallShield 2020
Project:This information applies to the following project types:
| • | Basic MSI |
| • | InstallScript |
| • | InstallScript MSI |
Note:If you want your installation to download the Oracle 11g Instant Client whenever it needs to be installed on a target system, check with Oracle to ensure that it is allowed. If it is allowed, you must host the download on your own Web site and add its download path to the InstallShield prerequisite. Revenera does not make this installation available for download.
Connecting to an instance of Oracle requires the following elements on the end-user machine that is running the installation:
| • | Microsoft ODBC for Oracle |
| • | 32-bit version of the Oracle Instant Client software (even on 64-bit target systems) |
The latest Microsoft Data Access Components (MDAC) include support for the Microsoft ODBC for Oracle drivers. However, the Microsoft ODBC for Oracle driver requires Oracle Instant Client software to communicate with Oracle database servers. Therefore, you may want to include the Oracle 11g Instant Client prerequisite to help configure the Oracle Instant Client on target machines upon installation. Oracle does not provide an installation for the files; you can do so easily by using the Oracle Instant Client installation project that is available in the InstallShield Program Files folder. For instructions, see Downloading the Oracle Instant Client and Creating an .msi Package for It.
Note that if your SQL script contains Unicode characters, you may want to use the Oracle ODBC Instant Client, since it has support for running SQL scripts that contain Unicode characters, but Microsoft ODBC for Oracle does not. You may want to include an ODBC Instant Client installation with the Oracle 11g Instant Client prerequisite to help configure the Oracle Instant Client on target machines, and to also set up the ODBC Instant Client. For more information, see Downloading the Oracle Basic Instant Client and the Oracle ODBC Instant Client and Creating an .msi Package and InstallShield Prerequisite for Both. If you plan on using the ODBC Instant Client instead of Microsoft ODBC for Oracle, ensure that you configure your project accordingly. For more information, see Running SQL Scripts with Unicode Characters on an Oracle Database Server.