From: Hannu Krosing <hannu@trust.ee>
To: Jackson, DeJuan <djackson@cpsgroup.com>
To: Antonio Mendez <antonio@unbol.bo>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] {Maybe not so OT} interface to MSsql server
Date: Fri, 15 Jan 1999 16:02:25 +0200
Message-ID: <369F4A71.3C03496@trust.ee> (raw)
References: <F10BB1FAF801D111829B0060971D839F5DE742@cpsmail>
<369F3EE1.41FD5A21@trust.ee>
Hannu Krosing wrote:
>
> Jackson, DeJuan wrote:
> >
> > > You may have some luck using SyBase client libraries, AFAIK the
> > > early MSSQL used the same protocols (was probably a port of SyBase)
> > I'm almost certain the MSSQL 6.5 was a port of Sybase 9.* or 10.*
> > And the Sybase drivers will connect with it.
>
> The FreeTDS drivers are at http://metalab.unc.edu/freetds/index.html
And they are planning a TDS Gateway - a program that provides TDS
(ie MSSQL and SyBase) clients with access to other databses, the
first one being - surprise! - PostgreSQL.
From that on - maybe we could contemplate moving our FE-BE protocol
over to TDS. I suspect they are currently implementing much more of
ANSI standard SQL CLI than the current (IMHO not very elegant) protocol.
I have not looked at it, but I guess that they already have things
like prepare statements, standard binary format for data (which should
of course be made extendable for PGSQL), column bindings, getting
column info, and possibly other things needed to make effective
interactive client apps.
-------------
Hannu Krosing
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@trust.ee, djackson@cpsgroup.com, antonio@unbol.bo
Subject: Re: [INTERFACES] {Maybe not so OT} interface to MSsql server
In-Reply-To: <369F4A71.3C03496@trust.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox