Home » RDBMS Server » Networking and Gateways » Gateway to Sybase on UNIX possible? (Sybase UNIX)
Gateway to Sybase on UNIX possible? [message #627053] Thu, 06 November 2014 16:34 Go to next message
Sweat
Messages: 1
Registered: November 2014
Location: Austin TX
Junior Member
I have Oracle 11g on a UNIX server and Sybase ASE 12.5.1 on a separate UNIX (Solaris) server. I want to set up a Database Gateway to access Sybase from Oracle. The Oracle documentation mentions a Windows OS is required to set up DG4ODBC to access Sybase. Am I reading this correctly? Am I out of luck?
Re: Gateway to Sybase on UNIX possible? [message #627054 is a reply to message #627053] Thu, 06 November 2014 17:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
welcome to this forum.

>The Oracle documentation mentions a Windows OS is required to set up DG4ODBC to access Sybase.
Unless & until you post the URL to documentation, I can't decide about correctness or completeness.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Re: Gateway to Sybase on UNIX possible? [message #627370 is a reply to message #627054] Tue, 11 November 2014 07:00 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on the "Unix" flavour somewhat. In Linux it was relatively painless to get Oracle talk to SQL Server (which also uses the TDS-Protocol Sybase uses) with http://www.unixodbc.org/ and http://www.freetds.org/.

I managed to get it working on AIX once, too, but that pretty much took ages and some modifications of the source code. If your Unix has UnixODBC and FreeTDS packages, then it might be easier.

Here is the documentation I used back then.
Previous Topic: ODBC Gateway v. SQL Server Gateway
Next Topic: Oracle and SQLServer DB Link
Goto Forum:
  


Current Time: Thu Mar 28 19:57:09 CDT 2024