OP_Zaharin
asked on
Oracle 64bit database link to Ms SQL Server 32bit
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.
- 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.
Regarding the connection to SQL 32bit you have to use the 32bit driver on the Oracle 64 machine.
Unless you upgrade your SQL environment to 64 bits (which is free by the way) and same SQL/OS licenses can be used as far as I'm aware. Other than the pain of the upgrade process itself you should only benefit from running 64 bit SQL Server on 64bit OS.
ASKER
georgekl,
- we have tried both the 32bit and 64bit odbc, both produce the above error mention.
Icohan,
- upgrade the sql server to 64bit is not possible as we have to upgrade our OS too.
- we have tried both the 32bit and 64bit odbc, both produce the above error mention.
Icohan,
- upgrade the sql server to 64bit is not possible as we have to upgrade our OS too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As I mentioned above - and sorry if I wasn't clear enough - you can't use 64 bit to connect to 32 bit and they should be both the same 64 biit.
On Windows 64bit I know you can use 32 bit driver to connect to ORACLE but not viceversa.
On Windows 64bit I know you can use 32 bit driver to connect to ORACLE but not viceversa.
ASKER
- Icohan thanks for the reply however as i've posted in ID: 36901069, Oracle 10g Heterogenous Services itself is not available for 64bit Windows. therefore no dblink can be done except by using Oracle Gateway 11g.
ASKER
as per the oracle doc, Oracle 10g's HS on Windows 64bit is not made available. therefore the workaround is to use Oracle Gateway or Oracle 11g database.