Skip to Content.
Sympa Menu

freetds - Re: [freetds] (no subject)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <brian.bruns AT gmail.com>
  • To: Igor Korot <ikorot AT earthlink.net>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: Re: [freetds] (no subject)
  • Date: Tue, 17 May 2005 06:35:44 -0400

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
>




Archive powered by MHonArc 2.6.24.

Top of Page