Dctest fails - odbc oracle

HCL Domino Domino Forum
1

Hi experts.

I’m currently stuck hopelessly.

I am developing a Lotus Notes/Domino Application that shall get data from an remote oracle 9.2 db via ODBC. I want to write the app in Lotus Script using LSX.

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. Easysoft provides an tool called isql to test the ODBC-setup - that also works without errors.

Next step was to test the connectivity from domino with dctest. Testing the ODBC-connection with it fails with an memory-access-error (Speicherzugriffsfehler).

So far the situation. Easysoft stopped supporting me - they’d rather send an consultant for 1600 euros per day. They stated, that the cause of the problem lies at oracle. In the logfile of the ODBC manager OCISessionBegin seems to cause the crash - I attached a part of the log at the end.

Do you have an advice or tip for me, what I can do?

Does anybody have experience with Lotus and ODBC under Linux?

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

ODBC manager Logfile:

[snip]

11:20:29 2004 63603 Calling OCIEnvCreate( 805afc4 3 0 0 0 0 0 0)

11:20:29 2004 69738 OCIEnvCreate returned 0

11:20:29 2004 82860 Params 0 1 0 1 1 0 0 0

11:20:29 2004 82951 Entering OCIServerAttach ( 80673c8 807bea8 805afd0 orcl 4 0 )

11:20:29 2004 107747 OCIServerAttach returned ( 0 )

11:20:29 2004 107942 Entering OCIAttrSet ( 8085b74 3 807cc5c 0 6 807bea8 )

11:20:29 2004 108010 OCIAttrSet returned ( 0 )

11:20:29 2004 108054 Entering OCIAttrSet ( 80858d4 9 80599c0(lan12004) 8 22 807bea8 )

11:20:29 2004 108112 OCIAttrSet returned ( 0 )

11:20:29 2004 108156 Entering OCIAttrSet ( 80858d4 9 8059a40 8 23 807bea8 )

11:20:29 2004 108202 OCIAttrSet returned ( 0 )

11:20:29 2004 108246 Entering OCISessionBegin( 8085b74 807bea8 80858d4 1 0 )

[end of file]

2

Subject: dctest fails - odbc oracle

Have you tried to create a DCR and connect to oracle?

I could not get dctest to work when I wanted to connect domino to MySQL. I was able to verify that the ODBC MySQL connection work with the native tools. So I just had Domino try to connection with the ODBC data source name. As I tested I found it was working, though dctest was reporting failures.

This was my obversation from my experience. I am thinking you may have success if you know the ODBC driver works on the domino back via the other tools you spoke of?

Also did you check out the Red Book on the LINUX install? Within that it sited that there was a need to do a symbolic link for the odbc driver in the domino program directory. I am wondering if this would hold true for you in your situation?

HTH

3

Subject: dctest fails - odbc oracle

If you use connector from domino to oracle9 on linux try to create link on directory ORACLE_HOME/lib, with command:ln -s libclntsh.so.9.0 libclntsh.so.8.0

usiing oracle user.

This is needed cause Oracle install library file libclntsh.so.9.0, but domino LSX try to use file with name libclntsh.so.8.0.

Hope this can help you

Regards

FAB