FreeTDS Development Group

[Brian Bruns <brian.bruns AT gmail.com>]

OSG came with Sybase ASA beginning with 5.5.03.  It'll be available in
the upgrade which was still available on the Sybase site as of about 2
years ago.  Not sure if it still is.

Brian

On 5/17/05, Igor Korot <ikorot AT earthlink.net> wrote:
> Thank you for that clarification Brian.
> Now, if I understood you correctly, all I need is an OSG, which will be a 
> bridge between the Sybase 5.5 engine and FreeTDS in order to get the 
> FreeTDS running with my version of SQL Anywhere 5.5.01, or at least try to 
> configure it to see if it will work.
> Now if this is correct, where I could find the OSG? I personally using the 
> Gentoo Linux, so will try to check their packet database, but just in case 
> I will not found it there, could you point me to the right direction.
> 
> Thank you in advance.
> 
> Igor, a couple of things.
> 
> The old Watcom database (which ASA is derived from) had a proprietary
> protocol that it used.  When you say "have an ODBC driver" on Windows,
> it is likely using this proprietary protocol, which FreeTDS does not
> support.
> 
> Once Sybase bought Watcom, they started transitioning to the TDS
> protocol and the T-SQL language.  ASA 5.5 was mostly T-SQL compliant,
> but still used the proprietary protocol.  As a short term solution,
> Sybase introduced OSG, which listens on for TDS connection on a port
> you specify and translates that back to the proprietary protocol.
> Later versions went fully native TDS.
> 
> Now, regarding use of FreeTDS ODBC and the OSG.  It should be possible
> to use the ODBC-only or DSN-less connection without configuring
> FreeTDS via the freetds.conf file.  However, your path of least
> resistance will be to get tsql working first and then attempt the
> unixODBC setup.  That way you'll know for certain that the server is
> configured correctly, and what the settings are.
> 
> Brian
> 
> On 5/16/05, Igor Korot <ikorot AT earthlink.net> wrote:
> > Ok, I got the part about upgrading. Now the problem with that is, that on 
> > XP
> I do have an ODBC driver that connects me to the database, and it's native 
> Sybase
> ODBC driver. Now I do have a unixODBC installed on my Linux box. And as far 
> as I
> understand from the documentation on both, I have to have a connection from 
> the
> FreeTDS in order to connect with ODBC. Is this true? Or ot's posible 
> without working
> FreeTDS connection?
> >
> > Could somebody please clarify?
> >
> > Bryan Bruns wrote:
> >
> > I had to upgrade to 5.5.03 to get it working, I believe that is the
> > correct minimum version.  OSG has no default port number, as it is an
> > add-on and doesn't come configured by default.
> > Later ASA (6.0+) comes with TDS enabled by default and that port
> > number is accurate for those.
> >
> > Brian
> >
> > On 5/16/05, James K. Lowden <jklowden AT freetds.org> wrote:
> > > Igor Korot wrote:
> > >
> > > > What would be the default port to connect to Sybase SQL Anywhere
> engine
> > > > version 5.5.01 that is located on the XP machine from the LINUX box
> with
> > > > FreeTDS? From Linux  I could see the XP share.
> > >
> > > http://www.freetds.org/userguide/freetdsconf.htm#TAB.FREETDS.CONF
> > >
> > > Port 2638, according to the best information we have.  But, per the link
> > > you cited, you need OpenServer Gateway (OSG) with at least 5.5.03.  Or
> so
> > > I'm told.  If you get it working with something less than that, tell us
> > > and I'll update the UG.
> > >
> > > > As I read on the documentation:
> > > > http://www.freetds.org/userguide/choosingtdsprotocol.htm, the correct
> > > > protocol version for that would be 5.0. Is it correct?
> > >
> > > Yes, 5.0 is what you'd want.
> > >
> > > --jkl
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>