Oracle 64bit database link to Ms SQL Server 32bit
Posted on 2011-09-22
Hi fellow experts,
- I'm currently in a team working on a project with one of the requirement is to setup a database link from Oracle 10g 64bit (Windows 2008 64bit) to Ms SQL Server 2005 32bit (Windows 2003).
- setting up the dblink from Oracle 32bit to Ms SQL Server 32bit works using Oracle Heterogeneous Services ODBC agent, but using the same method on Oracle 64bit to Ms SQL Server 32bit fail with the following error:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from MSSQL
- the team got the Oracle 64-Ms SQL Server 32bit database link works when using Oracle Gateway 11g but we're trying to make it work without using OG if possible.
- we need some ideas, if any of the experts have got a similar setup working, appreciate if you could share the steps/tweak if available.