Java, MS Access Database (DNS less connection and more?)
Posted on 2005-03-26
Experts, this is multi-part question, so I'm giving max points:
I am trying to develop some personal software that will allow people to track certain activities during the year. And, I naturally need a database to store the information in. I have chosen MS Access as my database since obviously there won't be multiple user connecting (will be installed on individual pcs), no high volume transactions, and it a simple database. I've searched other articles in EE for Java and database connections, but I haven't found anything on DNS-less java connections. I normally do dnsless connections when I'm doing my ASP programming and wondering if there's anyting similiar. So, can someone straighten me out on these questions:
1) Does java support DNSless connections to an access database? if so, what' the code?
2) If I install my software (compiled code and ms database)on a computer that doesn't have MS Access installed, will the program still know work? Will it still be able to read and write to database w/o the computer knowing it's a database.
3) If I must use a DNS to connect to the database, how do I get the DNS installed on the computer I'm putting my code on w/o having to actually to through the Control Panel and install the DSN? Is there anyway with my installation program that I can add the DNS?
4) Are there any other database options that someone would recommend. I would eventually like to sell this product and don't want the buyer to have to buy any other databases for it to work.
Thanks -- Java Infant