| connect sql database from oracle [message #612172] |
Mon, 14 April 2014 00:28  |
usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi
|
Member |
|
|
Hello gurus
I am trying to connect sql server from oracle via db link with below options
Option 1:
1. Oracle db 11.12 on AIX 64 bit
2. Sql server 2008 on Windows 7 64 bit (seperate machine)
i installed oracle software only on sql server machine from oracle 11g installation with 32 bit
and configured the 32-odbc,listner,tns,hssql with dg4odbc and create db link and add tns on db server this is working fine..
Option 2:
using as bridge
1. Oracle db 11.12 on AIX 64 bit
2. Sql server 2008 on Windows 7 64 bit (seperate machine)
3. Another machine on windows 2003 having oracle software only from oracle 11g installation ((separate machine)
i configure the odbc,listner,tns,hssql with dg4odbc on machine 3 as used will be bridge but error showing 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 MICRO i searched and found the mixing of 32 or 64 drivers what is the resolution do i need to install oracle database gateway driver is that the same install sofware only please advise
thnaks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
