Database Program (drivers & Stuff)
Hey Everyone,
I'm a 3rd yr student in Computer Science, and I'm doing a little project for my co-op work term. I've worked out that for the program I want to create, to work, It would be the best idea to implement the use of a database, where I would store a lot of information.
The basic function of the program is to display information, but there are three levels (3 objects) and a bunch of sub catagories of data to be displayed.
The problem I'm having is this:
With any DB work I've done so far (with MS Access) I've had to go into control panel and set all that junk with the driver in the ODBC : JDBC ... bla bla bla, Anyway,I'd like to know, if some kind of script has to be writtin, or some code, so when poeple install my software, it can create that driver automatically, and use the database. Thanks a million,
Angus
[884 byte] By [
Kngus] at [2007-9-26 1:19:39]

The DB you choose should be dependent upon your requirements. Do base your choice on convenience.
However, you have been using MSAccess and probably using the JDBC:ODBC bridge. This requires the setup that your trying to avoid.
Several options: MSAccess if very primative. You will want to avoid this anyway. If you choose to stick with MS use the MSDE or full blown SQL. To us a MS database you will need to acquire a JDBC driver from a 3rd party vendor (they are listed on the Sun websight). Most have developer programs or trial periods which will allow you to work with their products for free. Then if you sell your applications, you pay a small licensing fee.
Or you can use Oracle which provides the DB and the drivers to the developer for free. Again you pay the fees upon selling of the applications. Not to mention it is great stuff. It has emphasis on the java language.