Skip to Content.
Sympa Menu

freetds - Re: FW: MS SQL Server 2000, FreeTDS, and Cygwin

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: FW: MS SQL Server 2000, FreeTDS, and Cygwin
  • Date: Sun, 19 May 2002 08:43:26 -0400 (EDT)


Daniel,

The TDS provider in libgda uses ctlib IIRC. So, it would not be necessary
to configure freetds with glib at all (glib is used only in the ODBC
module).

I have not ported the code to glib 2 yet, because a) glib/gtk 2.0 only
installations are not very widespread yet. b) I don't have glib 2.0
installed, c) I don't have the time and d) I'm not particularly crazy
about ifdef'ing glib 1/2 all over the place.

Brian

On Sat, 18 May 2002, Daniel Morgan wrote:

> Hi James,
>
> > Do you (or someone else reading) know what's what with glib 1.2/2.0?
> I
> > would tend to think that FreeTDS wouldn't care very much about glib's
> > version, except regarding Makefile issues and such. But I really
> don't
> > know.
>
> Glib 2.0 is a new major version of glib available at http://www.gtk.org/
>
> Glib 1.2 uses glib-config to get the cflags and libraries to use in
> compiling a glib 1.2 program.
>
> Glib 2.0 uses pkg-config to get the cflags and libraries to use in
> compiling a glib 2.0 program.
>
> Many glib like programs dependent on glib 1.2 had their own *-config
> tool. Gtk 1.2 had gtk-config, etc... Well, with 2.0, glib, gtk, etc...
> have moved to one tool named pkg-config.
>
> Since I have glib 2.0 installed on my machine, but I do not have glib
> 1.x, I got the compile error saying it could not find glib-config.
> Maybe, I need to install glib 1.2 to see if that works. I think glib
> 1.2 and 2.0 can co-exist on the same machine.
>
> I don't know anything about Linux building using auto* stuff
> (autogen,autoconf,automake). I sure wish I did. I want to get libgda
> building under cygwin.
>
> >> Since you are intrigued, I will tell you what I am trying to do. I
> >> would like to get FreeTDS to work in libgda (GNU Data Access at
> >> http://www.gnome-db.org/ ) and
> >> Mono C#/CLR ( http://www.go-mono.com/ ).
>
> > I think that would be very cool. I hope we can get you over the glib
> hump
> > so you can get started.
>
> Me too... I have stuff I want to do! ;-) By the way, you can read
> about the ADO.NET (data/database) support in Mono at
> http://www.go-mono.com/ado-net.html
>
> >> You mentioned something about ct-lib. What is the difference between
> >> all those libraries? Which library should I be trying to use in
> >> libgda or Mono?
>
> > db-lib is the oldest and simplest. It's the only API supported by
> both
> > vendors, which is important to people porting applications that used
> the
> > vendors' libraries. Among other places, db-lib is used by PHP.
>
> > ct-lib is Sybase's second-generation API. People who really know
> Sybase
> > stuff rely on ct-lib because it fixes a bunch of implementation and
> > conceptual gaps in db-lib. That's why sqsh and Perl's DBD::Sybase use
> > ct-lib.
>
> > ODBC is our most recent addition. Its chief advantage is that it
> makes
> > FreeTDS servers look like other ODBC servers, a big help to people who
> > know ODBC and/or write applications for several kinds of servers.
>
> > <bias> I like db-lib and have never felt the need to learn ct-lib.
> Maybe
> > it's like great sex and I don't know what I'm missing 'til I've tried
> it,
> > but db-lib has always done what I need. In fact, I've often thought
> about
> > porting db-lib to MySQL or somesuch. </bias>
>
> You recommend me to use db-lib in the Microsoft SQL Server
> implementation in System.Data.SqlClient? I wonder if there is a Sybase
> .NET Data Provider that is open source? If not, we may need to create
> one then. Should db-lib be used for libgda as well?
>
> > There's not much point in using ODBC IMHO, because (1) it involves
> > interaction with driver managers and things you don't need, and (2)
> libgda
> > is aimed at the same problem ODBC is, approximately (and you don't
> need
> > two layers doing the same thing).
> > You probably should use ct-lib if you don't already know db-lib.
> That's
> > what experienced Sybase folks would tell you. If I were doing what
> you
> > are, I'd use db-lib, because that's what I know, and I haven't been
> burned
> > yet.
>
> I'm not crazy about ODBC myself, but there are those who are familiar
> with it and applications that are written for it. ODBC is a generic
> data/database API like: OLE-DB/ADO, Libgda, and .NET's System.Data.
>
> The Goal of Mono System.Data (ADO.NET) and LibGDA is to support "ALL"
> databases. However, this can be very hard. One way to do this - is to
> use libraries or APIs that exist already - unixODBC, FreeTDS, MDB Tools,
> etc. A direct provider to a database is better because it allows use of
> the extra features in that database. But a direct provider takes time
> to reinvent the wheel.
>
> I am interested in using FreeTDS for two things: 1. create the Microsoft
> SQL Server provider in System.Data.SqlClient, and 2. create a Microsoft
> SQL Server in Libgda. Actually, the provider in libgda will be called
> the "freetds" provider.
>
> The ideas behind libgda is to create an ADO/OLE-DB data model for Unix:
> no matter what DBMS or data source you have.
> Remember, libgda is and will be used with non-database as well, such as,
> XML documents and to provide data services for GNOME Office. Someone
> has already created a Sybase provider in libgda, but I don't think it
> uses FreeTDS, I think it uses the Sybase libraries.
>
> > Links to the vendors' library docs are in the FreeTDS User Guide.
>
> > One more thought. I noticed that MDB Tools is a libgda client.
> That's
> > very interesting, because MDB Tools is written by our very own Brian
> > Bruns. I'd imagine he'll be rooting for you, too.
>
> Rodrigo Moya is working on the MDB Tools provider in libgda. You can
> find his email address on the http://www.gnome-db.org/
> web site. If Brian Bruns is interesting in helping on the MDB Tools
> provider, I'm sure Rodrigo would be very happy about that.
>
> Isn't MDB Tools currently read-only? Are there plans for it to be
> modifiable, or able to create new MDB files?
>
> > Hope that's of some help.
> Yes it has!
>
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
>





Archive powered by MHonArc 2.6.24.

Top of Page