SQL/odbc

[Jeremy Fowler]

Don't forget Sybase and Progress...

Patrick, I would like to tell you that all databases are created equal and it's
up to the administrator to choose what he wants. However, SQL databases of today
are so proprietary that unless the application was designed to use strict ANSI
SQL standards only, you really need to choose the RDBMS the application was
designed for. Everyone pretty much includes the standards in their
implementations, but its the extensions that will come back to haunt you.
PL/SQL, Transact-SQL, Access SQL, everyone has their own flavor. Check with the
application manufacture and ask what they require. If they say that any ANSI SQL
server will work, well then you can pick and choose at will. However, if they
say they only work with MS SQL server, it's probably because the developers use
MS proprietary SQL extensions in the application itself and that limits your
choices quite a bit.

Hope that helps. -Jeremy

> -----Original Message-----
> From: owner-kclug at marauder.illiana.net
> [mailto:owner-kclug at marauder.illiana.net]On Behalf Of Brian Densmore
> Sent: Thursday, July 18, 2002 8:50 AM
> To: Patrick Miller; kclug at kclug.org
> Subject: RE: SQL/odbc
>
>
> Oracle
> IBM db2
> Postgresql
> [they are all probably faster and more powerful than MS SQL]
>
> Are all excellent powerful fast comprehensive and stable databases.
> Plus Oracle 9i runs on Linux and has good training, easily available
> most anywhere and a very large installed base.
>
> So if support and training are big issues go Oracle.
> If you want to recommend purely OSS go postgresql. They have sales and
> support,
> but not as much in the way of training and installed base.
>
> HTH and my $0.02,
> Brian
>
> > -----Original Message-----
> > From: Patrick Miller [mailto:pert at tas-kc.com]
> > Sent: Thursday, July 18, 2002 8:17 AM
> > To: kclug at kclug.org
> > Subject: SQL/odbc
> >
> >
> > I have used a few databases including MySql, but I am by no
> > means a db guy.
> > We are getting some software that is is requesting MS SQL
> > 2000 or other odbc compliant database. The thing is I don't
> > know comperable alternitaves.
> >
> > I asked a few people at computer stores and no one could
> > offer one. I have heard a db's have odbc modules available,
> > but don't know what to ask for or whats comperable.
> >
> > --
> > Patrick Miller -- Telephone Answerette Systems Inc.
> > IS/Telecom Tech. -- EVE Soon to be Infinity
> > Kansas City, MO
> > Ofc 816-753-7332 -- Cell 816-210-4077
> >
> >
> >
> >
> > majordomo at kclug.org
> >
>
>