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: Remote Oracle Connection using Instant Client (InstallScript)
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
‎Jun 26, 2008
02:39 PM
Remote Oracle Connection using Instant Client (InstallScript)
Is there a connection string option to use to connect to a remote Oracle instance with the Oracle Instant Client that does NOT use ODBC in any way?
In our setup, we originally tried using DRIVER={Oracle in instantclient_10}, set that in the ISSQLDBMetaData table, and that was successful.
Then I was told that we don't want the user to have to install the ODBC driver for the installer to run, because our application doesn't need ODBC, so the installer shouldn't, either. I tried using PROVIDER=MSDAORA and PROVIDER=OraOLEDB.Oracle, and they ONLY worked when the ODBC driver for IC was also installed.
When the driver was not installed, using MSDAORA would throw this:
When the driver was not installed, using OraOLEDB.Oracle would throw this:
Any thoughts on a PROVIDER value that I could use that would work a little better? Or another connection string altogether that I could use?
Any suggestions would be greatly appreciated.
Thanks!
BTW, current connection string as in the ISSQLDBMetaData table is PROVIDER=MSDAORA;Data Source=XXX;User Id=XXX;Password=XXX;
Also, again, this is InstallScript.
In our setup, we originally tried using DRIVER={Oracle in instantclient_10}, set that in the ISSQLDBMetaData table, and that was successful.
Then I was told that we don't want the user to have to install the ODBC driver for the installer to run, because our application doesn't need ODBC, so the installer shouldn't, either. I tried using PROVIDER=MSDAORA and PROVIDER=OraOLEDB.Oracle, and they ONLY worked when the ODBC driver for IC was also installed.
When the driver was not installed, using MSDAORA would throw this:
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
When the driver was not installed, using OraOLEDB.Oracle would throw this:
Provider cannot be found. It may not be properly installed.
Any thoughts on a PROVIDER value that I could use that would work a little better? Or another connection string altogether that I could use?
Any suggestions would be greatly appreciated.
Thanks!
BTW, current connection string as in the ISSQLDBMetaData table is PROVIDER=MSDAORA;Data Source=XXX;User Id=XXX;Password=XXX;
Also, again, this is InstallScript.
(6) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 26, 2008
04:26 PM
The built-in SQL feature uses Microsoft ActiveX Data Objects (ADO) which enable client applications to access and manipulate data from a variety of sources through an OLE DB provider. Therefore, you must have the provider specified in the ISSQLDBMetaData table installed on the target system. You might want to consider using the "Microsoft ODBC for Oracle" driver because it is available on all Windows platforms except clean Windows 95 machines.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 07, 2008
09:04 AM
Thank you for the reply (and sorry for the lateness in getting back, I was out of the office).
The Oracle Instant Client will not work with the "Microsoft ODBC for Oracle" driver as it also always throws this error:
So, you have to also install the ODBC driver for the Instant Client that Oracle provides, and use the "Oracle in Instantclient_10" driver instead (or something similar, I forget, really). This works fine.
However, my post originally noted that we DO NOT want to use ODBC in any way, so I was looking for a different connection string to build using a PROVIDER value instead. I can't seem to find one that works with the Instant Client, and was hoping maybe someone else stumbled onto one.
This appears to be a limitation of the Instant Client, not IS, I just haven't been able to find anything out there that would work, so I thought I'd check here.
Thanks.
The Oracle Instant Client will not work with the "Microsoft ODBC for Oracle" driver as it also always throws this error:
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
So, you have to also install the ODBC driver for the Instant Client that Oracle provides, and use the "Oracle in Instantclient_10" driver instead (or something similar, I forget, really). This works fine.
However, my post originally noted that we DO NOT want to use ODBC in any way, so I was looking for a different connection string to build using a PROVIDER value instead. I can't seem to find one that works with the Instant Client, and was hoping maybe someone else stumbled onto one.
This appears to be a limitation of the Instant Client, not IS, I just haven't been able to find anything out there that would work, so I thought I'd check here.
Thanks.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 08, 2008
12:40 AM
Oracle mentions that "To use the Microsoft ODBC and OLEDB driver, ociw32.dll must also be copied from ORACLE_HOME\bin" in the OCI Instant Client section of the Oracle Call Interface Programmer's Guide. ociw32.dll is included in the the Oracle Instant Client Basic package, but some of dependencies below are not included:
ORACORE10.DLL
ORANLS10.DLL
ORAUNLS10.DLL
ORAUTS.DLL
Once you copy these files from the standard Oracle client, Microsoft ODBC for Oralce will work with the Oracle Instant Client.
ORACORE10.DLL
ORANLS10.DLL
ORAUNLS10.DLL
ORAUTS.DLL
Once you copy these files from the standard Oracle client, Microsoft ODBC for Oralce will work with the Oracle Instant Client.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 08, 2008
10:13 AM
OK, thanks. We *still* do not want to use ODBC in any way, so I'll keep on looking. Maybe your information can lead me in a new direction.
Thanks again.
Thanks again.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 25, 2008
01:46 PM
Does the same info apply for InstallShield 2009?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 28, 2008
09:53 PM
Yes, it does.