pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] {Maybe not so OT} interface to MSsql server
2+ messages / 2 participants
[nested] [flat]
* Re: [INTERFACES] {Maybe not so OT} interface to MSsql server
@ 1999-01-15 14:02 Hannu Krosing <hannu@trust.ee>
0 siblings, 1 reply; 2+ messages in thread
From: Hannu Krosing @ 1999-01-15 14:02 UTC (permalink / raw)
To: Jackson, DeJuan <djackson@cpsgroup.com>; Antonio Mendez <antonio@unbol.bo>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] {Maybe not so OT} interface to MSsql server
@ 1999-01-19 03:04 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
parent: Hannu Krosing <hannu@trust.ee>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas G. Lockhart @ 1999-01-19 03:04 UTC (permalink / raw)
To: Hannu Krosing <hannu@trust.ee>; +Cc: Jackson, DeJuan <djackson@cpsgroup.com>; Antonio Mendez <antonio@unbol.bo>; pgsql-interfaces
> > 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.
And we'll get to figure out how to mix LGPL and BSD licenses in our code
base...
- Tom
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-01-19 03:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-15 14:02 Re: [INTERFACES] {Maybe not so OT} interface to MSsql server Hannu Krosing <hannu@trust.ee>
1999-01-19 03:04 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
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