ActiveX-Control using OCI7 with Oracle InstantClient

[Sherlock]

Hi,
I have a rather exotic configuration in which my ActiveX-Control should run:
-OracleInstant Client
-Calling App runs OCI7 using homemade librarys

The problem is this: When one of my own applications calls my ActiveX, everythings just fine. But as soon as the designated application uses my ActiveX, there is no DB connect.

I narrowed down the problem to the incapability of the InstantClient to run both OCI-versions in one Application. So I tried OracleSession.Preferences.UseOCI7 := true, but to no avail. My ActiveX still can't connect.

Is there anything else I can try?

Thanks in advance!

Regards,
Sherlock

 

[Marco Kalter]

What exactly goes wrong (e.g error messages)?
Do both use the same Oracle Home?

 

[Sherlock]

The Oracle InstantClient is a special thing by Oracle. Check out this link: http://www.oracle.com/technology/tech/oci/instantclient/index.html
The client is not installed in the classical sense. It is simply copied to a directory.
As a result there is no oracle home.

Problem is, that my OCI8-ActiveX can not establish a connect to the database, as soon as the MainApp uses OCI7.

Edit: The Session.Logon is in a try...except-block. There are no errormessages, probably because the oracle-dlls can't be loaded.

Edit2: The DOA Version is 4.0.7.

Regards,
Sherlock

 

[Sherlock]

Hi,
Any news or insight on this subject?

Regards,
Sherlock

 

[Marco Kalter]

If the Oracle Client Library cannot be loaded, then the exception will have a corresponding message. For the try/except block, did you inspect the Exception.Message property? Or the class of the exception?

 

[Sherlock]

I get an EOracleError without Message.

Sherlock

 

[Marco Kalter]

What is the EOracleError.ErrorCode?

 

[Sherlock]

Oh, I'm sorry. The Errorcode is 0 (Zero).

Sherlock

 

[Marco Kalter]

That is a strange error. I'm not sure what could cause this, but apparently there is some conflict between the 2 components.