>> 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.
What do you mean by command line ?
I assume(bear with me) that the sql database just sit there and waits for
commands/requaest and answers them. Am i right here ?? I thought you need
to use you app to pass the requast (vi driver) ect...
What kind of gui apps ?? Do they have a programing language ???
>> 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).
OK thats a start. What do you use to build your local/ws apps ??
I assume you need to write the application /gui ?
What text based options are there besides gui ?
>> 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
>
>
--
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
