Forum Stats

  • 3,875,832 Users
  • 2,266,974 Discussions
  • 7,912,352 Comments

Discussions

Oracle ODBC Gateway to CData for QuickBooks: Error [ORA-00600]

2956286
2956286 Member Posts: 3
edited May 26, 2015 12:24PM in ODBC

I am trying to integrate Oracle DB with QuickBooks DB via CData ODBC driver.

currently im using oracle gateway to connect 2 databases.

here is the setup:

machine1: Oracle <==>Cdata ODBC(quickbooks)

machineServer: QuickBooks database(remoteconnection)

CData ODBC access the quickbooks data remotely, and i want to access the data using oracle.

listener.ora -------------------------------------------------------------------------------------------------------------

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = BLPTEST.hitachitransport.com)(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

  )

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME=QB)

(ORACLE_HOME=D:\app\Administrator\product\11.2.0\tg_1\)

(PROGRAM=dg4odbc)

)

)

ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\tg_1

-------------------------------------------------------------------------------------------------------------------------------

tnsnames.ora-------------------------------------------------------------------------------------------------------------

ORACLE.11G.BLPTEST =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ORACLE.11G.BLPTEST)

      (SID = ORCL)

    )

  )

QB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID=QB))

      (HS=OK)

  )

-------------------------------------------------------------------------------------------------------------

sqlnet.ora-------------------------------------------------------------------------------------------------------------

SQLNET.AUTHENTICATION_SERVICES= (NONE)

-------------------------------------------------------------------------------------------------------------

lsnrctl working ok

tnsping is also ok

created the database link called QB to connected and run the query

select * from [email protected]

but everytime i try to query, I get:

Error ORA-00600: Internal error code, arguments: [HO define: Long fetch], [],[],[],[],[],[],[],[],[],[]....

please see the attachment(log file)

looking at the logfile it kind of retrieve the table information(which matches with the quickbooks DB).

Please advise.

Chris

Tagged:

Answers

This discussion has been closed.