Thursday, November 29, 2012

In windows 7 : The specified DSN Contains an architecture mismatch between the Driver and Application

ODBC Driver setup

The following steps show how to access a 32-bit ODBC driver from a 64-bit application on a 64-bit Windows machine. The ODBC driver used is the Microsoft Access ODBC driver. The application used is the SQL Server Integration Services (SSIS) Import and Export Wizard.
  1. In the 32-bit ODBC Data Source Administrator, configure a System data source for the Access ODBC driver. To access the 32-bit ODBC Data Source Administrator, run the following command in the Windows Run dialog box:
    %windir%\syswow64\odbcad32.exe

Sunday, August 26, 2012

Java : Getting no days between dates in java

private static double durationInDays(Date dateFrom, Date dateTo) {


TimeZone tz = Calendar.getInstance().getTimeZone();

/*TimeZone ltz = TimeZone.getTimeZone(tz.getID());

System.out.println(tz.getID());*/

double timeTo = dateTo.getTime();

double timeFrom = dateFrom.getTime();

double duration = timeTo - timeFrom;

if (tz.inDaylightTime(dateFrom)) {

if (!tz.inDaylightTime(dateTo)) {

System.out.println("in daylight saving from: " + dateFrom);

System.out.println("not in daylight saving to: " + dateTo);

duration -= 60 * 60 * 1000;

}

} else {

if (tz.inDaylightTime(dateTo)) {

System.out.println("not in daylight saving from: " + dateFrom);

System.out.println("in daylight saving to: " + dateTo);

duration += 60 * 60 * 1000;

}

}

return duration / (24 * 60 * 60 * 1000);

}

Monday, February 6, 2012

Content Assist (Ctrl + Space) Is Not Working in Eclipse IDE / RAD in Windows 7

In Windows7 the content assist is not working in Eclipse IDE /RAD 7.0. I have Google the same information at not able find right solution.

At last I have changed content assist key to other key settings.


Preference ---> General ---> keys--->

Scheme: Default
Name: Content Assist
binding : Shift+spacebar ( Previous its CTRL +SPACEBAR )



Now short cut changed its working fine.