This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,924 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

connection from ORACLE to a non-Oracle system returned this message

JoseLC
JoseLC Member Posts: 2 Green Ribbon

I am having problems in my dblink between oracle xe and sql server, when executing this query

SELECT "codigo" FROM "DBO.CURSOS"@remoto

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from REMOTE

I have already given a thousand turns to the configuration and I can not find the error, can someone help me please

This is my current configuration:

$ cat /etc/odbc.ini

[master]

Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1

Description=DataDirect 5.20 SQL Server Wire Protocol

Database=master

User=SA

Pa

[ODBC]

Trace=ON

TraceFile=/opt/odbc520/odbctrace.out

TraceDll=/opt/odbc520/lib/odbctrac.so

InstallDir=/opt/odb520

ConversionTableLocation=/opt/odbc520/tables

UseCursorLib=0


ssword=Abril2021+

Server=192.168.0.144

$ cat /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File:

XE =

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = asi)(PORT = 1521))

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = XE)

  )

 )

EXTPROC_CONNECTION_DATA =

 (DESCRIPTION =

  (ADDRESS_LIST =

   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

  )

  (CONNECT_DATA =

   (SID = PLSExtProc)

   (PRESENTATION = RO)

  )

 )

master_descriptor=

  (DESCRIPTION=

   (ADDRESS=

     (PROTOCOL=TCP)

     (HOST=192.168.0.100)

     (PORT=1521)

   )

   (CONNECT_DATA=

     (SID=master)

   )

   (HS = OK)

  )

$ cat /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora

# listener.ora Network Configuration File:

SID_LIST_LISTENER =

 (SID_LIST =

  (SID_DESC =

   (SID_NAME = PLSExtProc)

   (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)

   (PROGRAM = extproc)

  )

  (SID_DESC=

   (SID_NAME=master)

   (ORACLE_HOME= /u01/app/oracle/product/11.2.0/xe)

   (PROGRAM=dg4odbc)

   (ENVS=LD_LIBRARY_PATH=/opt/microsoft/msodbcsql17/lib64:/u01/app/oracle/product/11.2.0/xe/lib)

  )

 )


LISTENER =

 (DESCRIPTION_LIST =

  (DESCRIPTION =

   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

   (ADDRESS = (PROTOCOL = TCP)(HOST = asi)(PORT = 1521))

  )

 )

DEFAULT_SERVICE_LISTENER = (XE)

$ cat /u01/app/oracle/product/11.2.0/xe/network/admin/initmaster.ora

# This is a sample agent init file that contains the HS parameters that are

# needed for the Database Gateway for ODBC

#

# HS init parameters

#

HS_FDS_CONNECT_INFO = master

HS_FDS_TRACE_LEVEL = user

HS_FDS_SHAREABLE_NAME = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1

#

# ODBC specific environment variables

#

set ODBCINI=/etc/odbc.ini

set HOME=/u01/app/oracle/product/11.2.0/xe

#

# Environment variables required for the non-Oracle system

#

#set <envvar>=<value>

$ isql -v master SA Abril2021+

+---------------------------------------+

| Connected!              |

|                    |

| sql-statement             |

| help [tablename]           |

| quit                 |

|                    |

+---------------------------------------+