On Tue, Apr 13, 1999, Samy Elashmawy <[EMAIL PROTECTED]> wrote:
>
> I would like to set up an sql server on linux for the widows apps to acess .
>
> 1/ can this be done ?
Absolutely.
> 2/ I am looking at 2 to 3 users with a max of 5 users. two or three apps.
There a number of Databases available. Adabas, MySQL, mSQL, PostreSQL
are 4 that come off the top of my head. Also, Oracle, Informix and all
of the other major Database vendors have Linux versions as well.
For your purposes, one of the first 4 should be good.
> 3/ I want to keep it simple and basic nothing fancy.
MySQL, mSQL and PostreSQL are all free and basic enough. They are mostly
command line (there are GUI apps as well) and provide good performance.
> 4/ I will nees jdbc support as I am looking to move to java
I dunno about JDBC but I think all of the above have JDBC and ODBC
support.
> 5/ how hard / easw is it to set up the server ?
I'm most familiar with MySQL. It was very easy to install (install the
package, create the database and go).
> 6/ how hard / easy ios it to get the windows apps to see the server ?
> Do you just need to set up the driver . or give the ipaddress ???
The driver will most likely need a hostname or IP address. Maybe a
database name (I'm not very familiar with JDBC or ODBC)
> any pitfalls in what I want to do ??
Well, you don't want to do any pitfalls if you can avoid it :) There is
a wealth of documentation out there for all of them. Here's some of the
URL's:
MySQL: http://www.mysql.com
mSQL: http://www.hughes.com.au
PostgreSQL: http://www.postgresql.org
are the ones off the top of my head
JE
--
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
