I am trying to connect sql database with oracle database using the gateways solution.
after doing all necessary settings related to the sql server ,oracle database and oracle gateway.
i create database link as follow:
SQL> CREATE PUBLIC DATABASE LINK dblink CONNECT TO
2 "user" IDENTIFIED BY "password" USING 'tns_name_entry';
when i tried to retrive data using the database link connection:
SQL> SELECT * FROM DUAL@dblink;
an error occured as follow:
ora-28500:connection from oracle to a non-oracle system returned this message:
[oracle][ODBC SQL server wire protocol driver] general error.select failed : 0 {HY000}
02063:preceding 2 lines from dblink
can you help with this error?