Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Java error message when linking to database.
New Posts  All Forums:Forum Nav:

Java error message when linking to database. - Page 3

post #21 of 34
Im assuming your running windows 64 bit then, there is two versions of the odbcad

C:\\Windows\\SysWOW64

Contains the one you want to use. That is where windows stores all your 32 bit stuff, afaik there is no 64 bit access drivers which is why when you run the default odbcad from the control panel(the 64 bit version) it shows no access driver.

If you run the odbcad32 in that folder you should be able to add the driver under there.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #22 of 34
Thread Starter 
Hmmm what would my Data Source Name be??
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
post #23 of 34
Anything you want, just make sure you remember it so you can access it, pretty much just a name link between you and the messages.mdb database.

(E.g. MyMessagesdb) or something that that extent. I dont know if there is a "proper" way to do it.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #24 of 34
Thread Starter 
Okay I've created... something. It says I have to specify it in my code though. Has it already been specified? Or have I gotta add this... I'm really worried this won't work when I send it to my lecturer...
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
post #25 of 34
I understand, looking around it appears a lot of people complained/had/having problems with compatibility with access and 64 bit.

I believe the problem is your program your creating is x64 and when it goes looking for that microsoft access driver, since it is 64 bit, it looks in the system32 folder... finds odbcad32 (the 64 bit version) runs it and cant find the microsoft access driver you specified (as you saw when you opened from control panel).

This is really beyond the scope of my knowledge here, i'm not sure if you an explicitly reference the 32 bit odbcad32 from your program, or if that will even work running it from a 64 bit environment.

Im really sorry i cant be more help here, but i would have to be more familiar with how Windows and the compiler handles all of this behind the scenes.

I would suggest downloading 32 bit jdk on a 32 bit system and rewriting your code on it, i would think that would be the best bet as everything appears to be correctly written.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #26 of 34
I also found this, you can try downloading this driver to see if it may help

http://answers.microsoft.com/en-us/o...6-b95d84135820

Edit, actually its a little farther down

http://www.microsoft.com/downloads/e...displaylang=en


(Grasping for straws here)
If that doesnt work, after you build the solution to the program you could try going to the program you created right clicking, properties, compatibility, then try running it in compatibility mode for say windows XP. Perhaps it will force it to run 32 bit and look for the correct version of the Access driver.
Edited by mykah89 - 3/8/11 at 10:51am
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #27 of 34
Thread Starter 
I've already tried the microsoft download. It wouldn't it me install the 64 bit because my office isn't 64 bit so I installed the 32 bit version. Reinstalled and still nothing in the list. Argh this is an absolute mess :/ I only really have 64 bit machines in my house atm tbh. There's a mac I could use but I doubt that'd be any good lol. There's a 32 bit machine but it's in such a state. I'd soend more time getting it to work that actually doing this programming. I have an older version of this program I could use without the database add ins but I'd be losing like 20% of my marks :S :S :S
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
post #28 of 34
http://social.msdn.microsoft.com/For...e-d2f27fde9db5

Looks like your options are

Uninstall 32 bit office, install 64 bit redist pack that you couldnt install before.

Find a computer with 32 bit jdk on it.


Or try what this user had to do, which im not sure how to do.

Since I can't uninstall 32 bit version of Microsoft office and can't install the 64 bit drivers, how can i turn my java application to be 32-bit ?

FYI:

I had to set data sources ODBC target = %windir%\\syswow64\\odbcad32.exe

and start in = %windir%\\syswow64

in order to create my ODBC source and use MSaccess drivers.

Thanks for your help
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #29 of 34
Thread Starter 
Well I've tried everything I can but I just don't think this old 32 bit system's going to work... It's just too damn slow. Looks like I might have to run boot camp on that Mac. I really can't really rewrite the whole program... :/ then it wouldn't be compatible with my lecturer's computer knowing my luck! Argh... I'll get back to you...
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
Dark Star
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
  hide details  
Reply
post #30 of 34
If your familiar with virtual box you could set up a VB with windows 32 bit and then download the 32bit jdk on that and do it in there as opposed to trying to get an ancient computer working.

That way if you happen to run into this problem in the future you could just boot up the VBox and code away in that anyways.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Java error message when linking to database.