[freetds] (no subject)
Brian Bruns
brian.bruns at gmail.com
Tue May 17 06:35:44 EDT 2005
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
>
More information about the FreeTDS
mailing list