ODBC Lotus domino
426757Aug 9 2004 — edited Sep 16 2004Hi o-experts.
I'm currently stuck hopelessly - am really not experienced with oracle.
I am developing a Lotus Notes/Domino Application that shall get data from an remote oracle 9.2 db via ODBC. Both systems run on linux boxes. It took quite a time to get the ODBC driver to run - I installed oracle instant client 10.1, unixODBC driver manager and the oracle ODBC-driver from easysoft-inc on the local machine.
Sql-Plus is sucessful in getting data from the db dirctly. UnixODBC provides an tool called isql to test the ODBC-setup - that also works without errors.
Next step was to test the connectivity from lotus domino. IBM ships a tool called dctest. Testing the ODBC-connection with it fails with an memory-access-error (Speicherzugriffsfehler).
Easysoft-support stated, that the cause of the problem lies at oracle. In the logfile of the Oracle Client "OCISessionBegin" seems to cause the crash.
I put two parts of the logfiles to our webserver, so you can see what I mean - links later.
Do you have an advice or tip for me what I can do?
Does anybody have experience with Lotus and ODBC under Linux?
Do you think there is a problem in the versions of oracle 9.2-db and instant-client 10.1?
Thanks,
alex haid
Innsbruck/Austria
The system-environment:
-----------------------
local box: Red Hat 9, Lotus Domino 6.5.1, oracle instant client ver 10.1.0.2 (rpm), unixODBC, oracle odbc driver 2.0;
romote box: Suse 8, Oracle DB 9.2.0.1
LogFiles:
------------
1. ODBC-Log: using IBM ./dctest that crasches
http://81.16.97.156/tmp/odbc.log
2. ODBC-Log: using UnixODBC ./isql that works fine
http://81.16.97.156/tmp/odbc1.log