Home » RDBMS Server » Networking and Gateways » connect sql database from oracle
connect sql database from oracle [message #612172] Mon, 14 April 2014 00:28 Go to next message
usmanelahi
Messages: 53
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





Re: connect sql database from oracle [message #612228 is a reply to message #612172] Mon, 14 April 2014 15:59 Go to previous message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at this Maaher's walkthrough. I hope it'll help.
Previous Topic: Configuratin Issue
Next Topic: how to connect oracle forms with ms sql server 2008
Goto Forum:
  


Current Time: Sat Oct 25 02:49:17 CDT 2014

Total time taken to generate the page: 0.10058 seconds