From owner-freebsd-questions@FreeBSD.ORG Wed Oct 22 12:23:00 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 996C516A4B3 for ; Wed, 22 Oct 2003 12:23:00 -0700 (PDT) Received: from magidesign.com (w178.z064001046.atl-ga.dsl.cnc.net [64.1.46.178]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5A48743F85 for ; Wed, 22 Oct 2003 12:22:58 -0700 (PDT) (envelope-from payne@magidesign.com) Received: from magidesign.com ([64.25.7.78])h9MJ9HNm000922; Wed, 22 Oct 2003 15:09:28 -0400 Message-ID: <3F96D8CA.9070708@magidesign.com> Date: Wed, 22 Oct 2003 15:21:46 -0400 From: Payne User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030912 Thunderbird/0.3a X-Accept-Language: en-us, en MIME-Version: 1.0 To: "E. J. Cerejo" References: <3F96D018.6050806@netscape.net> In-Reply-To: <3F96D018.6050806@netscape.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-questions Subject: Re: Databases X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Oct 2003 19:23:00 -0000 E. J. Cerejo wrote: > I have a small business and I'm looking to setup a freebsd server. I > want to connect about 4 clients to this server running windows XP. > The Freebsd server will keep a database of every customer address, > phone number, what services that were performed, how much was charged, > etc etc. This is basically all I need for now and I was wondering > which opensource database would do this in the easiest possible way. > Also what software would I use in the client boxes to access this > database (input and output). > > Best regards to all > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > As other have written, MySQL is the way to good. If you buy the FreeBSD CD MySQL is on the CD. All you need to is down load 3.51 ODBC drivers which work great with MS Office, or you can use PHP to write your own web base apps. We are currently using MySQL with ODBC and PHP and really love the fact that we can custom our web apps to the way we want them to work vs. the way out of the box apps work. Also take a look at phpMyAdmin or MySQL Center Control these are great apps to help admin the database. Plus, there are thousand of Open Source programs and code that you can find to help you. Payne