Ask the Expert

Accessing SQL Server through transparent gateway

Is it necessary the Oracle server should be on a Windows OS to connect to Oracle Gateway installed on a Windows machine where MS SQL Server is also installed? What I mean is, can we access SQL Server from the Oracle server database installed on Linux through a transparent gateway installed on a Windows machine? If so how do we do that?

    Requires Free Membership to View

Yes, you can access SQL Server from Oracle running on any server as long as you have the Gateway product for that server. Once installed you can access other non-Oracle databases in exactly the same way, irrespective of platform type.

This was first published in October 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: