Thread: RE: [INTERFACES] {OT} interface to MSsql server
> -----Original Message----- > Antonio Mendez wrote: > > > > I know it, but I'm searching a client which will must to > connect with > > Microsoft SQL server 6.5, the client is linux box. The > interface to use > > is OBDC. > > Is unavoidable the use of the data base MS-SQL server :( > > There is a application for to do it?????? > > > > 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. > Search for sometihing called cbt (I think there is/was even a project > to develop free sybase client libs for linux) Sybase has released its 11.5 server as freeware for linux. I've only found it in RPM form but the libs are in there. Should be on the Sybase site (http://www.sybase.com/) or RedHat site (http://www.redhat.com/) somewhere. > Your other alternative is to try running DOS clients (if there are > such) inside DOSEMU on linux and create an interface for them. > Probably not very effective nor easy. > > Or just write to Microsoft and demand client libraries for Linux ;) Heh, that's funny. > Or perhaps they have client libs or command line client for SCO or > Unixware or Solaris that would run with IBCS. Well, I'd be done seen about everything when I see an elephant fly. > ---------------- > Hannu Krosing -DEJ
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 --------------------- Hannu Krosing
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
On Thu, Jan 14, 1999 at 09:51:49AM -0600, Jackson, DeJuan wrote: > I'm almost certain the MSSQL 6.5 was a port of Sybase 9.* or 10.* Sure is. M$ bought that old Sybase kernel and added almost nothing on the internals. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!
> > 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