I need a simple solution (read on inside)

  • Thread starter Thread starter Jay King
  • Start date Start date
J

Jay King

I have a program that needs to keep records in a table format somewhat
like the one below

# date message server author
1 06032004 AbCDEFABAC irc.winbeta.org matt


So lets pretend I don't know anything about databases, What is my
first step? I want to use something free, so I'm thinking MySQL?
Most importantly this program is NOT GOING TO BE HOUSED ON A SERVER.
It's a stand alone app that will be installed on a users machine, so I
guess I want a solution that doesnt require me having to install the
database engine on the users machine.

If anyone has a tutorial or something that can get me started that
would be great!
 
It's a stand alone app that will be installed on a users machine, so I
guess I want a solution that doesnt require me having to install the
database engine on the users machine.
Click to expand...

Options:

1. Microsoft Access
2. Firebird Embedded Server (.NET compatible)
3. XML File?


You probably don't want to use MySQL or MS SQL as those require a database
server to be loaded.

Before you continue... you should read up on database design so you'll
build a solid data model in your database.
 
So something like this is what I need to use?

http://firebird.sourceforge.net/index.php?op=files&id=netprovider
Click to expand...

Yes... and you'll also need the Embedded Server DLLs. Add a reference to
the DLLs in your project.

I believe you'll need to use version 1.6 Beta 1 if you wish to use the
Embedded server support.

Also, MSDE is another database engine choice, but MSDE requires end user
installation (or a silent installation in your install program).

Anyhow, maybe you should stick with Microsoft Access? Access is simple...
and works well as a standalone database.
 
Would Access be free for me to utilize? If so whats my first step to
using it.

Ive got the nessecary files for firebird, but I need to design a db
table and an create an empty database. What tool can I use to do
this. If I drop firebird and goto access will I need to purchase MS
access do do this?
 
I downloaded MSDE and its asking me to make a strong SA password and
it wont install untill I do so. This is getting too complicated.

If I were to use XML what classes should I be looking at and what
program (free) should I be using to create my initial tables?
 
Back
Top