elizabeth baker wrote:
We are building an application for myths of the world. It started out in Access, but when we decided to distribute it via CD to attendees at an art retrospective (about myths of the world), we began looking for an alternative db, since not everyone has Access on their computer. There will be no charge for the retrospective or the application CD. The application will eventually be web-based and available on the internet.
MySQL was recommended to us, as was developing in C#. i have read that MySQL can be embedded in applications. Is this an advisable route for us? to develop and C# and embed MySQL in the application?
i'm somewhat at a loss as how to proceed, and time is running out. Any help/advice is greatly appreciated.
--elizabeth
If you want a quick_and_dodgy way of doing it, you can do the front-end in MS Access developer, and have the data in MySQL.
I can't tell you about licensing issues with MySQL - I suppose it depends on whether your app is commercial or not, but you should track down the answer to this before going any further.
The developer version of Access lets you create installation packages that will put a 'runtime' version of MS Access on Windows computers - without the need for an Access or Office license. In reality, it's a pretty tricky thing to get working right. We had a bad enough time on our network, and we're all using Windows 2000. We had even more issues getting the thing to run on Windows NT4, and I hate to think what you'd have to go through to get it to install on other versions of Windows. But if you're familiar with Access already and you're pushed for time ( but you can handle testing your installation package on all different types of Windows installs ), then this may be the way to go. REMEMBER: this is the quick and dodgy solution, and I suppose you have to actually have the developer version of Access to start with.
If you don't like this option, I would go with either Perl or PHP. You can make an installer to get a LAMP system up and runnning fairly easily. I haven't done it, but I've read about it, and it doesn't look too hard.
If you don't like a web-based interface, you could look at http://gtk2-perl.sourceforge.net/ - I've been using this setup for Rapid Application Development under Linux for quite some time now. It's a very nice system. Just grab Gtk2 for Windows, ActiveState Perl, and the Gtk2-Perl binaries and you're off.
As for C#, I've never used it, but I don't think you'll find too many MySQL users recommending it somehow - it's better to stick with open source solutions. MySQL gets far more testing with open source languages than with C#, and your tech support for open source systems is going to be far better as well.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
