Adam Keys wrote: > > [EMAIL PROTECTED] 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 > > < > > [EMAIL PROTECTED] | < > `-----------------------------------------------------------------------------' > > -- > Unsubscribe? mail -s unsubscribe [EMAIL PROTECTED] < /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
