One trouble we had in SQL Server is that it doesn't support Oracle hierarchy query like "CONNECT BY". Unfortunately our application has to support Oracle and SQL Server at the same time. My email id is A help in this would be highly appreciated. ORA-02063: preceding 2 lines from AVANTIACCESS Unable to retrieve text of NETWORK/NCR message 12564 ORA-28545: error diagnosed by Net8 when connecting to an agent
(ADDRESS=(PROTOCOL=tcp)(HOST=STRATSOURCING)(PORT=1521)) My initavantiaccess.ora file in HSadmin folder and Tnsnames.ora in network/admin folder are in place. I have a access database and another UNIDATA database for which I 'm trying to access using Heterogenious services. Its a shame oracle does'nt have a simple method to get this done ( I was heckled by MS Access users with the ease with which they can set it up :( ) I have been trying to get this working on my oracle 9i rel 2.0 datawarehouse database. I am still trying ot find where i went wrong. I am running this test from the Oracle Server (8.1.7) and has the SQL server 2000 Client installed on it. The init file for HS has been modified and named appropriately I have run the HS script C:\Oracle\Ora81\RDBMS\ADMIN\caths.sql Microsoft SQL Server ODBC Driver (Version ) Listener Log File C:\Oracle\Ora81\network\log\listener.logģ.SID=name in the service name definition (in the TNSNAMES.ORA file) must match the value in the LISTENER.ORA file for the responding listener. Listener Parameter File C:\Oracle\Ora81\network\admin\listener.ora Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc ROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=2481))(P Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc Log messages written to C:\Oracle\Ora81\network\log\listener.log System parameter file is C:\Oracle\Ora81\network\admin\listener.ora TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
protocol-specific information in the service name definition is the same as in the The USING clause in the DB link and TNSNAMES is the same as in the TNSNAMES file
#ERROR 42000 MICROSOFT ODBC VISUAL FOXPRO DRIVER SYNTAX ERROR MANUAL#
Looking the error up in the error manual i have checked the followingġ. ORA-28509: unable to establish a connection to non-Oracle system I went through the URL and related chapters/pages butstill getting the select authid from