LDA problem with SQLORA8

[rikjc]

I have a problem, I need to use the SQLORA8 DLL with an Oracle 7.3 database due to various migration problems.

Now the problem is that when I use the SQLORA8.DLL as opposed to the SQLORA32.DLL I find that if I attempt to get the native handle from the BDE and assign it to the LDA of an OracleSession object, I get an access violation the moment any database access occurs. I suspect that the LDA value I'm obtaining from the BDE is incorrect for some reason. It may also be that the handle is being passed from the BDE to an OracleSession object within a DLL.

Now, if I use the SQLORA8.DLL with only BDE based database objects everything is fine, it's only when I use it with any of the DOA components that I run into problems.

Obviously the solution to this would be to convert our whole system over to using the DOA components but that's a very big job and I'd rather find an alternative if I can.

 

[Marco Kalter]

If you are using the BDE and Direct Oracle Access in a single application, then you must make sure that both are using the same SQL*Net or Net8 DLL. Otherwise you can experience all kinds of problems.

For Direct Oracle Access you can set the OracleHomeName or OCIDLL variables (see OracleCI topic in help file).

------------------
Marco Kalter
Allround Automations

 

[rikjc]

Originally posted by mkalter:
If you are using the BDE and Direct Oracle Access in a single application, then you must make sure that both are using the same SQL*Net or Net8 DLL. Otherwise you can experience all kinds of problems.

For Direct Oracle Access you can set the OracleHomeName or OCIDLL variables (see OracleCI topic in help file).

No I've already done this, the problem is definetely with SQLORA8.

I need to use a combination of ORA73 and SQLORA8 because the client machines in my organisation use both Oracle 7.3 and Oracle 8. There are also applications that are unfortunately hard-coded to use ORA73.

The combination of DLLs seems to work for everything bar DLLs with use the DOA components, and have the LDA passed from a BDE session object to an OracleSession object.