Re: SQL packages
Adam Keys wrote:
>
> joshua.kaldon@amd.com wrote:
> >
> > All,
> > Does anyone know if there are any SQL database servers that are MS
> > SQL 6.5 compatible and work with Debian? Also, would it support integrated
> > security and if not how hard do you expect it to be to write something like
> > that?(I assume most of the work has already been done by the samba package.)
> > If I can find something that does basically everything our current server
> > does (or pretty close even), then I'm going to replace it with a Debian box
> > that I can rely on.
>
I'm looking for the same thing... a replacement for my (4) NT 4.0/SQL
6.5 boxes.
I have PostgreSQL loaded on a Redhat box (I couldn't get the Debian
package running, Debian 1.3.1). I was able to run some of my SQL 6.5
scripts to create a database, tables, and insert data with the psql
utility. The scripts had to be modified a little (psql didn't like
using NULL in create tables statement).
With the PostODBC driver on an NT workstation (I think it will work on
Win95), I was able to connect to the PostgreSQL database from Access97.
Unfortunately, my custom application that is the reason for the SQL 6.5
database servers would not talk to the database (I think it is the
syntax of the OBDC calls).
I am also looking at Sybase ASE that can be downloaded from the Redhat
and Caldera sites. I have it installed but have not had time to try it
out (babysitting NT, SQL 6.5, and the application). I read that a
reviewer of Redhat 5.2 tried it and was able to use the Microsoft ODBC
driver (MS ODBC saw it as an older MS SQL server).
I favor PostgreSQL (if I can get it to work or can talk my vendor to
support it) because of the open source aspect. I haven't tried mysql but
don't not think my application would do well with flat text files.
> --
> a) compatible with sql server? so far as odbc, mysql and postgreSQL offer odbc,
> which is probably how you connect to your server. the tables, however, are
> stored in a binary format in sql server (AFAIK), while mysql stores the data in
> flat text files. you're going to need to do some SQL trickery to move the data
> across; the data files cannot be copied from one system to another. my
> recommendation is to go with mysql, both for its enormous speed advantage, and
> also for it's great security.
>
> b) samba doesn't really do much you would want to do with a database, in all
> instances i've seen
>
> ,-----------------------------------------------------------------------------.
> > Adam Keys | That rug really brought the room together <
> > akeys@mail.smu.edu | <
> `-----------------------------------------------------------------------------'
>
> --
> Unsubscribe? mail -s unsubscribe debian-user-request@lists.debian.org < /dev/null
--
Greg Frye, APS
California Environmental Protection Agency
Air Resources Board
Monitoring and Laboratory Division
1927 13th Street
P. O. Box 2815
Sacramento, CA 95812-2815
voice: 916-324-8892
fax: 916-327-8217
Reply to: