Doa & DataBase

[llz]

I use DOA & DataBase in the same DataModule
of Delphi, it is error when I use query of database after I logon DOA
Error Message:
Access violation at 0x4d622ee5: read of address 0x388b5708 83 3A 00 74 63 E8 39 10 00 00 64 8B

How Should I do?
Thanks

 

[Marco Kalter]

You must make sure that the BDE and Direct Oracle Access are using the same SQL*Net or Net8 DLL. You can force Direct Oracle Access to use a specific DLL by setting the global OCIDLL variable before connecting to a database. This variable is located and documented in the OracleCI unit. At design time you can set the OCIDLL in the Oracle Preferences menu.

If, for example, the BDE uses ora73.dll (SQL*Net 2.3), then you need to set OCIDLL to 'ora73.dll'.

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

 

[llz]

Thanks your help, and I still have a
little doubt:
I set OCIDLL in BDE, but I have to logon
OracleSession before open a Database,why?

Originally posted by mkalter:
You must make sure that the BDE and Direct Oracle Access are using the same SQL*Net or Net8 DLL. You can force Direct Oracle Access to use a specific DLL by setting the global OCIDLL variable before connecting to a database. This variable is located and documented in the OracleCI unit. At design time you can set the OCIDLL in the Oracle Preferences menu.

If, for example, the BDE uses ora73.dll (SQL*Net 2.3), then you need to set OCIDLL to 'ora73.dll'.