Jasper Server and iReport Presentation

You could find JasperServer and iReport presentation from this link. JASPERv1

Cannot see Oracle ODBC driver in datasource administrator in Windows 64 bit

Problem:

I cannot see Oracle ODBC driver in datasource administrator in Windows 2003 64 bit.

Cause:

64 bit 32 bit incompatibility issue for odbc driver, data source administrator and application.

Solution:

I have Windows 2003 64 bit, Oracle 10.2 32 bit Client and 64 bit application.
After googleing around,

I found that there is two versions of odbc datasource administrator:

The default one, is 64 bit which we use Start menu for opening it.

In order to open the 32 bit version I used: %windir%\SysWOW64\odbcad32.exe.

With the help of 32 bit version datasource administrator, I could see my 32 bit odbc driver listed.

I extracted this rule of thumb: If your application is 32 bit, then your data source must use Oracle 32 bit client as well.

Last words, beware of 3 pieces:
1- your application (which uses DSN definition),
2- Oracle client
3-data source administrator

All pieces must have same version, in my case it is 64 bit and therefore I installed 64 bit client.

Further reading:
http://support.microsoft.com/kb/942976

What is oradiag_oracle directory in /home/oracle in 11.2?

This directory is created in the home directory of the oracle user, after making a local connection.

I had tested it as follows:

[oracle@geoppdb01]:/home/oracle> ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 15621 Jan  5 11:51 db.rsp
[oracle@geoppdb01]:/home/oracle> date
Thu Feb  4 19:52:12 EET 2010

--- made a local sqlplus connection after then

[oracle@geoppdb01]:/u01/app/oracle/product/11.2.0/dbhome_1> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 4 19:52:22 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> !date
Thu Feb  4 19:52:26 EET 2010

-- check the folder, here it comes to life:)

[oracle@geoppdb01]:/home/oracle> ls -ltr
total 20
-rw-r--r-- 1 oracle oinstall 15621 Jan  5 11:51 db.rsp
drwxr-xr-x 3 oracle oinstall  4096 Feb  4 19:52 oradiag_oracle
[oracle@geoppdb01]:/home/oracle>