Home » RDBMS Server » Networking and Gateways » Connection to MS SQL using ODBC Gateway
Connection to MS SQL using ODBC Gateway [message #683684] Fri, 12 February 2021 10:50 Go to next message
dpditstaff@iowa.gov
Messages: 3
Registered: February 2021
Junior Member
We have a need to connect an instance of Oracle to an MSSQL database that's behind a firewall. Rather than expose the IP of the database, we would like to deploy the ODBC gateway on both sides with the gateway IP externally exposed. Please reference the attached diagram for reference. Is GW-to-GW communication supported?

Thanks in advance
Re: Connection to MS SQL using ODBC Gateway [message #683685 is a reply to message #683684] Fri, 12 February 2021 11:39 Go to previous messageGo to next message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

I do not think that you can use ODBC gateways like that. However, what you could do is replace the gateway in your diagram on the Oracle side with a Connection Manager. You don't have to pay for that, IF you have Enterprise Edition licences.
Re: Connection to MS SQL using ODBC Gateway [message #683686 is a reply to message #683685] Fri, 12 February 2021 12:50 Go to previous messageGo to next message
dpditstaff@iowa.gov
Messages: 3
Registered: February 2021
Junior Member
Thank you for your response and the information.
Re: Connection to MS SQL using ODBC Gateway [message #683687 is a reply to message #683684] Fri, 12 February 2021 14:26 Go to previous messageGo to next message
EdStevens
Messages: 1350
Registered: September 2013
Senior Member
I've never heard of doubing the gateway like that. however, you have left out a key component, and putting it in will resolve your problem. what you've left out is the odbc connection itself. On that second machine, where you have your second gateway behind the firewall, replace that gateway with the odbc admin/driver.

Read this post about the various links between the oracle client and the final mssql, via the gateway for odbc. The location of the ODBC driver can be on any machine .. it does not have to be on the client machine or the server machine, because the link from ODBC to target is also a network connection.

So your connection would be :
client to oracle db
oracle db to gateway
gateway to odbc, via firewall
odbc to mssql.
Re: Connection to MS SQL using ODBC Gateway [message #683711 is a reply to message #683687] Mon, 15 February 2021 09:05 Go to previous message
dpditstaff@iowa.gov
Messages: 3
Registered: February 2021
Junior Member
Thank you for additional clarifying information.

[Updated on: Mon, 15 February 2021 09:05]

Report message to a moderator

Previous Topic: Synonyms for Remote DB
Next Topic: Operation Times out after 30 minutes
Goto Forum:
  


Current Time: Thu Dec 02 21:25:51 CST 2021