OraFAQ Forum: Networking and Gateways » Connection to MS SQL using ODBC Gateway

Home » RDBMS Server » Networking and Gateways » Connection to MS SQL using ODBC Gateway

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connection to MS SQL using ODBC Gateway [message #683684]

Fri, 12 February 2021 10:50

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

Attachment: Oracle Gateway Infrastructure.pdf
(Size: 244.31KB, Downloaded 2476 times)

Report message to a moderator

Re: Connection to MS SQL using ODBC Gateway [message #683685 is a reply to message #683684]

Fri, 12 February 2021 11:39

John Watson
Messages: 8880
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.

Report message to a moderator

Re: Connection to MS SQL using ODBC Gateway [message #683686 is a reply to message #683685]

Fri, 12 February 2021 12:50

dpditstaff@iowa.gov
Messages: 3
Registered: February 2021

Junior Member

Thank you for your response and the information.

Report message to a moderator

Re: Connection to MS SQL using ODBC Gateway [message #683687 is a reply to message #683684]

Fri, 12 February 2021 14:26

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: Connection to MS SQL using ODBC Gateway [message #683711 is a reply to message #683687]

Mon, 15 February 2021 09:05

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 21:29:21 CDT 2023