This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Connect to Oracle & run scripts
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 24, 2008
02:55 AM
Connect to Oracle & run scripts
Hi all,
I'm pretty new to using InstallShield, and now I would need some assistance using IS 2009.
I'm currently creating an integrated installer to deploy a .NET web app together with the database (tables, SPs, etc) it will be using. The database is in Oracle and likely to be on different machine with the web app. Assume that the database is ready to use.
I'm about to execute some scripts to create tables, procedures, etc to the Oracle database. I have created a connection in "SQL Scripts" view, and ticked Oracle at the "Requirement" tab, but in "General" tab the form doesn't seem fit to enter Oracle database credentials (host, service name, port, role). Did I miss something? What are actually the steps to do such?
I hope my language is not confusing, Thanks 🙂
I'm pretty new to using InstallShield, and now I would need some assistance using IS 2009.
I'm currently creating an integrated installer to deploy a .NET web app together with the database (tables, SPs, etc) it will be using. The database is in Oracle and likely to be on different machine with the web app. Assume that the database is ready to use.
I'm about to execute some scripts to create tables, procedures, etc to the Oracle database. I have created a connection in "SQL Scripts" view, and ticked Oracle at the "Requirement" tab, but in "General" tab the form doesn't seem fit to enter Oracle database credentials (host, service name, port, role). Did I miss something? What are actually the steps to do such?
I hope my language is not confusing, Thanks 🙂
(10) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 24, 2008
08:08 AM
If you press F1 when the General tab is displayed for your SQL connection, you'll see the help topic that describes the General tab. That help topic explains that for the Default Target Server Name field, you can enter the host, port, and service name. It also shows a sample entry.
I hope that helps.
I hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 27, 2008
06:53 AM
Thanks Debbie for information, I have followed the steps given.
Anyway, I got another problem when running the installer. When I click Next on the SQLLogin dialog, an error message appears saying Error 27502, something about Microsoft ODBC Driver Manager. We're currently using ODAC 11 for connecting to Oracle.
Appreciate any help thanks
Anyway, I got another problem when running the installer. When I click Next on the SQLLogin dialog, an error message appears saying Error 27502, something about Microsoft ODBC Driver Manager. We're currently using ODAC 11 for connecting to Oracle.
Appreciate any help thanks
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 27, 2008
09:32 AM
Can you post a screenshot of the error message?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 29, 2008
09:55 AM
Please make sure that you have the Oracle Instant Client software installed on your target machine. Also, make sure that you have the following files in the Oracle Instant Client folder:
ORACORE10.DLL
ORANLS10.DLL
ORAUNLS10.DLL
ORAUTS.DLL
Oracle documents that "To use the Microsoft ODBC and OLEDB driver, ociw32.dll must also be copied from ORACLE_HOME\bin" in the Oracle Call Interface Programmer's Guide. ociw32.dll is included in the the Oracle Instant Client Basic package, but those dependencies are not included.
Hope that helps.
ORACORE10.DLL
ORANLS10.DLL
ORAUNLS10.DLL
ORAUTS.DLL
Oracle documents that "To use the Microsoft ODBC and OLEDB driver, ociw32.dll must also be copied from ORACLE_HOME\bin" in the Oracle Call Interface Programmer's Guide. ociw32.dll is included in the the Oracle Instant Client Basic package, but those dependencies are not included.
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 30, 2008
09:47 AM
Oracle Instant Client? I already have ODAC 11 (Oracle Data Access Components) installed in target machine. Are they different? :confused:
Will Oracle Instant Client install "the whole oracle database" in the target machine? Because the Oracle database will be on remote computer (not in target machine).
Btw, I found this:
http://www.oracle.com/technology/software/tech/dotnet/utilsoft.html
Is that the Oracle Client that you mean?
Thanks in advance. Really sorry if my questions sound stupid.
Will Oracle Instant Client install "the whole oracle database" in the target machine? Because the Oracle database will be on remote computer (not in target machine).
Btw, I found this:
http://www.oracle.com/technology/software/tech/dotnet/utilsoft.html
Is that the Oracle Client that you mean?
Thanks in advance. Really sorry if my questions sound stupid.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 30, 2008
10:23 AM
You need to have the Oracle Instant Client installed on the machine where you run your setup, in order to connect to an Oracle database using InstallShield. Please see the Connecting to an Instance of Oracle and Running SQL Scripts InstallShield help topic to find out how to create a setup prerequisite for the Oracle Instant Client.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 31, 2008
03:53 AM
It works now! Thanks lots for the advise hidenori 🙂
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 13, 2008
04:44 AM
Another question:
If I would use Instant Client 11g, would I need the following files?
ORACORE11.DLL
ORANLS11.DLL
ORAUNLS11.DLL
ORAUTS.DLL
And how can I obtain these?
Thanks.
If I would use Instant Client 11g, would I need the following files?
ORACORE11.DLL
ORANLS11.DLL
ORAUNLS11.DLL
ORAUTS.DLL
And how can I obtain these?
Thanks.
![](/skins/images/3B39CE851FDD5528C393F146EB70A2D0/responsive_peak/images/icon_anonymous_message.png)