Skip to Content.
Sympa Menu

freetds - [freetds] (no subject)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot AT earthlink.net>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] (no subject)
  • Date: Mon, 16 May 2005 21:24:39 -0700 (PDT)

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
>






Archive powered by MHonArc 2.6.24.

Top of Page