I'm trying to insert and select data from Lotus Notes database through a Oracle database link for heteregeneous database. See he database link's source code below:
create public database link SATI
CONNECT TO "Notes_Common_User_Name"
IDENTIFIED BY "Passowrd_Notes_User_Name"
USING 'Connection_string';
ex: create public database link SATI
CONNECT TO "remedy"
IDENTIFIED BY "123456"
USING 'Notes.world';
I have NotesSQl installed and a DSN named NOTES where are specified the server, the database, the user and his password.
The problem is that when I try to insert or select the data using the oracle link it is present the erro below :
Link SATI.US.ORACLE.COM error: ORA-28500: conexão do ORACLE com um sistema não-Oracle retornou esta mensagem:
[Generic
Connectivity Using ODBC]
DRV_InitTdp: [Lotus][ODBC Lotus Notes]Unable to validate userid remedy (SQL State: S1000; SQL Code: 23341)
ORA-02063: precedendo 2 lines a partir de SATI
I've tried specified on the link script the hierarchical user name:
ex: create public database link SATI
CONNECT TO "remedy/SIN/SC"
IDENTIFIED BY "123456"
USING 'Notes.world';
but oracle identify the caracter "/" as divisor between username and password.
Someone have any suggestion ?
Print this page
