ODBC Connectivity issue

 

Hi,

We are getting ODBC connectivity issue while establish the connectivity between Interbase  and Oracle 11g 

System Details:

OS - Windows 2008 r2 64Bit

Database:  Oracle 11g 11.2.0.1.0

                  Interbase 2011 10.0.1.355

Processed Steps:

1. Odbc executed file

     c:\windows\syswow64\odbcad32.exe 

2. Created DNS names as 'SMT32' (Test connection success)

3. Added code in Listener File

    SID_LIST_LISTENER =

    (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = \app\ERPadmin\product\11.2.0\dbhome_2)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\ERPadmin\product\11.2.0\dbhome_2\bin\oraclr11.dll")

     )

    (SID_DESC =

     (SID_NAME = hsodbc)

     (ORACLE_HOME = \app\ERPadmin\product\11.2.0\dbhome_2)

     (PROGRAM = dg4odbc)

     )

     )

4. Stop and start Listener

5. Configuration in Oracle HS file 'Iinitdg4odbc.ora'