SQL> create database link lnk2 connect to sa identified by sa using 'tg4msql';
Database link created.
SQL> select * from sa.employees@lnk2;
select * from sa.employees@lnk2
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]DRV_InitTdp: errors.h (937): ; [Microsoft][ODBC
SQL Server Driver][SQL Server]Login failed for user 'SA'. (SQL State: 00000;
SQL Code: 18456)
ORA-02063: preceding 2 lines from LNK2
The above is the error I am getting.
I had a few questions in this regard
1. I don't find any Gateway service being created in the services panel. What is the purpose of this inittg4msql.ora?
Is there any utility to create gateway service in oracle10g as it used to be in 8 like
CMD> Set GTW_EXE=TGMSQL80.exe
CMD> GTWSRV80 sid -create | more
2. As Gateway installation and database server is on the same machine with one Listener which reads from
Then what is the function of listener.ora under
Same with Tnsnames.ora file.
Please help me as I have been trying with this for many days and its going nowhere.
Any help is highly appreciated...
Thanks and Regards