Background:
I am fetching data from a database on SQL Server 2008 (SQLA
) over to Oracle (ORCLA
) . The data is pulled using a database link, via HS ODBC connection. Both the SQL and Oracle databases were 32-bit editions.
Now, we moved the Oracle database onto faster 64-bit servers(ORCLB
), the 32-bit Oracle database remained on the older system, and this system (ORCLA
) was still used as the "gateway" between the 2 databases. Today, the 32-bit Oracle server (ORCLA
) was scrapped.
This broke interface between the 2. I tried to setup the HS ODBC connection on the 64-bit Oracle server (ORCLB
) I started getting the above error message. Upon further researching
I found that the HS ODBC gateway is not supported on a 64-bit system. So I setup the HS ODBC connection on another 32-bit Oracle server(ORCLC
) that we have. The HS ODBC setup ( listeners, et al) on 64-bit server (ORCLB
) were scrapped.
Problem:
I can ping SQLA
, using tnsping
. lsnrctl
shows that listNer is correct.
I can connect to a database on ORCLC
and fetch data from SQLA
. However, while trying to fetch data from SQLA
onto ORCLB
results in the above error message being thrown.
I have no idea what I can do to fix this. Any help would be appreciated.
The 32-bit systems use Oracle 10gR2, the 64-bit edition uses Oracle 10.2.0.4.
(Pardon me if I posted incorrectly here, I felt this is more of a server side issue)