Using dotConnect for Oracle from Installshield

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Edward67
Posts: 3
Joined: Thu 27 Dec 2012 08:09

Using dotConnect for Oracle from Installshield

Post by Edward67 » Thu 27 Dec 2012 08:13

Hi,

In my Installshield project, I need to do a direct query to an Oracle database. I've created a managed dll to do the calls. Everything is working, when dotConnect is installed on the target system. However, does anyone know how I can use dotConnect for Oracle if this isn't installed on the target system? I think I need to supply the dll's via supported files, but then?

Thanks in advance.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using dotConnect for Oracle from Installshield

Post by Shalex » Fri 28 Dec 2012 08:20

Please refer to http://www.devart.com/dotconnect/oracle ... yment.html. If this doesn't help, specify the exact text of the error message you are getting.

Edward67
Posts: 3
Joined: Thu 27 Dec 2012 08:09

Re: Using dotConnect for Oracle from Installshield

Post by Edward67 » Mon 07 Jan 2013 09:27

Hi,

Thanks for the reply. Due to holidays a late reply from mine site.

I've added Devart.Data.dll and Devart.Data.Oracle.dll as support files to mine Installshield project. In this case their outside the cab-files, the complete contents of mine setup folder:
  • - devart.data.dll
    - devart.data.oracle.dll
    - OnGuar~1.cab
    - OnGuard Cloud Listener.msi (mine project)
    - setup.exe
    - onguard.setup.dll.config (having the DBProviderFactories)
The onguard.setup.dll is in the binary table from Installshield and holds the calls to oracle (via Devart). This dll is build with VS2012. The project for this has a licenses.config which lists the following entries:
  • Msiexec.exe
    setup.exe
    OnGuard.SetupTest.exe
    OnGuard Cloud Listener.msi

During running the setup, Installshield just ends. Log file has the following lines:
Action start 10:12:52: DBRoutines_CheckDB.
Action ended 10:12:53: DBRoutines_CheckDB. Return value 3.
Info 2896. Executing action DBRoutines_CheckDB failed.
Action ended 10:12:53: InstallWelcome. Return value 3.
Action start 10:12:53: SetupCompleteError.
Action ended 10:12:54: SetupCompleteError. Return value 2.
Action ended 10:12:54: INSTALL. Return value 3.
=== Logging stopped: 07/01/2013 10:12:54 ===
MSI (c) (18:A8) [10:12:54:388]: Product: OnGuard Cloud Listener -- Installation operation failed.

MSI (c) (18:A8) [10:12:54:390]: Windows Installer installed the product. Product Name: OnGuard Cloud Listener. Product Version: 1.00.0000. Product Language: 1033. Manufacturer: OnGuard Nederland BV. Installation success or error status: 1603.

The program OnGuard.SetupTest.exe is a test program for checking the connections. This program also uses the onguard.setup.dll. When I run this program, everything works. So it must be something in combination with Installshield.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using dotConnect for Oracle from Installshield

Post by Shalex » Wed 09 Jan 2013 14:12

Please find out the actual exception, which is generated by our provider, and its stack trace. For this, try using installation logs: http://serverfault.com/questions/61883/ ... stallation.

Edward67
Posts: 3
Joined: Thu 27 Dec 2012 08:09

Re: Using dotConnect for Oracle from Installshield

Post by Edward67 » Wed 16 Jan 2013 09:09

I've tried several things and the logging. I don't get more information in the log. The only lines in the log, are the ones I already noticed :(.

Does someone has a sample (dll, installshield project) on how to used devart.oracle from within the setup project (so no local install of dotconnect)?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Using dotConnect for Oracle from Installshield

Post by Shalex » Thu 17 Jan 2013 15:12

We cannot identify the problem unless we know the exact exception generated by the provider with its call stack.

Please contact InstallShield support team to find the way of enabling detailed logging.

Post Reply