Oracle Database link to SQL Server using Oracle Gateway ODBC

Naseer CV
Naseer CV Member, Orion GCS Customer Posts: 1 Green Ribbon


Created the following.

  1. system DSN created at SQL - Machine with name - DSNEMPEXAM
  2. Install "WINDOWS.X64_193000_gateways" on SQL Machine, choose ODBC

At " D:\app\tg\HASQLADMIN\product\19.0.0\tghome_1\hs\admin" change name of the init file initDSNEMPEXAM - values (HS_FDS_CONNECT_INFO = DSNEMPEXAM


3 .Listener configured in SQL Machine

path: D:\app\tg\HASQLADMIN\product\19.0.0\tghome_1\hs\admin




   (ADDRESS=(PROTOCOL=tcp)(HOST=(HOST=IP of the SQL)(PORT=1443))










and getting error for tnsping


C:\Windows\system32>lsnrctl stop LISTENERDSNEMPEXAM

LSNRCTL for 64-bit Windows: Version - Production on 03-MAR-2021 09:08:28

Copyright (c) 1991, 2019, Oracle. All rights reserved.

TNS-01101: Could not find listener name or service name LISTENERDSNEMPEXAM


Please any one support?