|
Hey there fellow tlers!
I was wondering if anyone with some decent experience in programming, particularly in java, could help me out with this one. Basically back in sixth form (British school from ages 16-18) I created a program in java that was a point of sale till program for my fathers business for my computing course. Thing is my dad actually wants to use it now, and it's 3 years later and i cant seem to get the drivers working. I used an access database and spoke to it using SQL using a JDBC to ODBC bridge. Thing is that it doesn't seem to work anymore, i just get errors about not being able to find the ODBC driver, and im programing it on a totally new machine with 64 bit windows 7 as appose to the original xp machine i programmed it on, and now java integrates the bridge these days as well. I think it has something to do with 64 bit operating systems having two ODBC drivers or something but i really cant be bothered to find a solution as none on the Internet Ive found so far work, so unless you have a straight solution to this then perhaps you can help me with picking a new database to use.
Basically the database needs to be easy to speak to from a Java application across a network, and needs to have a good client side program/management frontend, like Microsoft access, as my dad wants to use a program to run reports and such so that he can get information about his stock. Any suggestions of what to use and where to start? There seems to be HUNDREDS of types of databases out there and i really don't know where to start. Is it worth using MySQL? As this seems to be popular on the web, and would look good on my cv if i went for a web design job, and also Orcale owns it so i assume it will work well with Java. Only this is, what good management frontend programs can you get for it?
Thanks for any help 
 
|
You should check out Microsoft SqlServer. I use it for any projects that I write that require a Database engine. Ive no complaints about it. Its a reliable product and there are free versions. SqlServer 2005 should have no qualms about Win7 x64
|
Hyrule19057 Posts
MSSQL is annoying, but maybe that's just because I prefer MySQL. So I recommend MySQL. Unfortunately I haven't used Java in years because I hate it, so that's really all I can recommend.
|
|
|
if it's just for home use, run hibernate with hsqldb in the background. easiest thing in the world, and you don't even have to write any insert queries anymore at all.
|
I actually had to get the ODBC bridge to work on 64-bit windows 7 before - one second while I look for how I did it (I'll edit it in when I find it)
EDIT: found the class page where we set up the bridge, I'll just go ahead and mirror it for you
EDIT2: mirrored here! http://www.public.iastate.edu/~j2pierce/DataSounce.htm
like I said, it was a project for a class - so ignore the references to cs363 :p
|
|
|
When you go to the drivers tab, the only thing that shows up is the SQL server?
Are you positive that you have microsoft access installed on your machine? The only other thing I can think of is that maybe it's a path issue - but looking at my path right now I don't have anything involving office or access and I doubt I would have removed it.
You might have to use odbcconf.exe in the syswow64 folder if nothing else is working - it lets you manually add a driver to the odbc manager. It's command line only, but if you try to run it without any parameters it will give you the syntax for use.
|
On July 01 2011 01:44 Maero wrote:
When you go to the drivers tab, the only thing that shows up is the SQL server?
Are you positive that you have microsoft access installed on your machine? The only other thing I can think of is that maybe it's a path issue - but looking at my path right now I don't have anything involving office or access and I doubt I would have removed it.
You might have to use odbcconf.exe in the syswow64 folder if nothing else is working - it lets you manually add a driver to the odbc manager. It's command line only, but if you try to run it without any parameters it will give you the syntax for use.
Ok i got this part to work so that i could follow your above guide after looking on the internet for while. But my program still wont work, im wondering whether it has to do with the data source name field as i assume this is program specific but im not sure what to put in there.
Edit: actually this only works for the 64 bit driver manager, the 32 bit one doesn't have the drivers it seems :S but 64 bit does!
|
|
|
|
|
|
|
|
|
|
EPT
