Reputation: 77
I am creating a login dextop application in JAVA. For DATABASE I am using MICROSOFT ACCESS 2007. So I need to use ODBC connectivity to use database in my application. Here are the steps I am following to make connection :-
1.Click Start, and then click Control Panel.
2.In the Control Panel, double-click Administrative Tools.
3.In the Administrative Tools dialog box, double-click Data Sources (ODBC).The ODBC Data Source Administrator dialog box appears.
4.Click User DSN, System DSN,
But here, in System DSN, There is no option to choose to select. Please help me out of this and give your valuable suggestions.
Upvotes: 1
Views: 455
Reputation: 77
I have solved the issue, I am using window -7, 64-bit machine so i just did one thing..
right click Data source (ODBC)..go to properties change the folloing thing
target [ %SystemRoot%\SysWOW64\odbcad32.exe ]
start in : [ %SystemRoot%\System32 ]
press enter and continue as admin. :) enjoy.. :)
Upvotes: 1