Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Database Link connecting to ODBC using Heterogeneous Services gets Error

thopevsOct 9 2008 — edited Oct 10 2008

Hello,

I created a database link in Oracle 10gr2 database which is pointing to ODBC DSN.

Below is the command

CREATE PUBLIC DATABASE LINK LOTUSNOTES
USING 'LOTUSNOTES';

I am able to query the tables in LOTUSNOTES database after login as sysdba into sys schema using database link.

But When i try to query the tables in LOTUSNOTES database using the database link from other schemas. I am getting following error message

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: errors.h (2112): ; [Lotus][ODBC
Lotus Notes]Unable to validate userid TEST[Lotus][ODBC Lotus Notes]Invalid
authorization specification (SQL State: S1000; SQL Code: 23341)
ORA-02063: preceding 2 lines from LOTUSNOTES

I created synonyms to the tables in LOTUSNOTES database and try to query same error is displayed.

Please suggest how to overcome this issue. Developers need access to data from lotusnotes database from schemas other than sys.

Thanks
Seshadri Thope

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2008

Added on Oct 9 2008

#heterogeneous-connectivity

4 comments

3,720 views