Topic
  • 5 replies
  • Latest Post - ‏2014-04-03T12:57:30Z by Rohit Katiyar
Rohit Katiyar
Rohit Katiyar
4 Posts

Pinned topic Error when connecting to database using unixODBC on IBM AIX.

‏2014-04-02T12:04:36Z |

I am facing an error while connecting to database using unixODBC on IBM AIX 64bit

DB2 client V9.7 is installed on the machine.

Found on net that it can be due to library file:' libdb2o.so ' missing and in that case update to DB2 V9.7 Fix Pack3.

Updated DB2 client to DB2 V9.7 Fix Pack 4 but still no success.

 

On trying to connect to database using: isql -v <databaseName> it gives following error:

 

[01000][unixODBC][Driver Manager]Can't open lib '/opt/IBM/db2/V9.7/lib64/db2o.o' : file not found

[ISQL]ERROR: Could not SQLConnect

 

Details of .odbc.ini :

[databaseName]

Driver=db2_odbc_driver

 

Details of .odbcinst.ini :

[db2_odbc_driver]

Description = IBM DB2 ODBC driver

Driver      = /opt/IBM/db2/V9.7/lib64/db2o.o

FileUsage   = 1

DontDlClose = 1

 

Environment variables DBINSTANCE and ODBCINI are set.

 

Your help will be greatly appreciated.

Thanks.

Attachments

Updated on 2014-04-03T12:53:59Z at 2014-04-03T12:53:59Z by Rohit Katiyar
  • nivanov1
    nivanov1
    53 Posts

    Re: I am facing an error when connecting to database using unixODBC on IBM AIX.

    ‏2014-04-02T18:06:57Z  

    What happens when you try to list the file:

    ls -l 
    /opt/IBM/db2/V9.7_01/lib64/db2o.o
    
  • Rohit Katiyar
    Rohit Katiyar
    4 Posts

    Re: I am facing an error when connecting to database using unixODBC on IBM AIX.

    ‏2014-04-03T05:00:15Z  
    • nivanov1
    • ‏2014-04-02T18:06:57Z

    What happens when you try to list the file:

    <pre dir="ltr">ls -l /opt/IBM/db2/V9.7_01/lib64/db2o.o </pre>

    -r--r--r--    1 bin      bin        43075217 Feb 20 2013  /opt/IBM/db2/V9.7/lib64/db2o.o

  • nivanov1
    nivanov1
    53 Posts

    Re: I am facing an error when connecting to database using unixODBC on IBM AIX.

    ‏2014-04-03T12:42:31Z  

    -r--r--r--    1 bin      bin        43075217 Feb 20 2013  /opt/IBM/db2/V9.7/lib64/db2o.o

    Looks like a botched installation. This should be readable/executable by the ID that runs the program. Besides, you're showing the wrong file anyway -- you've configured ODBC to look in /opt/IBM/db2/V9.7_01, not opt/IBM/db2/V9.7

    Updated on 2014-04-03T14:45:36Z at 2014-04-03T14:45:36Z by nivanov1
  • Rohit Katiyar
    Rohit Katiyar
    4 Posts

    Re: I am facing an error when connecting to database using unixODBC on IBM AIX.

    ‏2014-04-03T12:55:41Z  
    • nivanov1
    • ‏2014-04-03T12:42:31Z

    Looks like a botched installation. This should be readable/executable by the ID that runs the program. Besides, you're showing the wrong file anyway -- you've configured ODBC to look in /opt/IBM/db2/V9.7_01, not opt/IBM/db2/V9.7

    Sorry In actual file it is /opt/IBM/db2/V9.7 that was by mistake as i tried with /opt/IBM/db2/V9.7_01 also.

  • Rohit Katiyar
    Rohit Katiyar
    4 Posts

    Re: I am facing an error when connecting to database using unixODBC on IBM AIX.

    ‏2014-04-03T12:57:30Z  

    Sorry In actual file it is /opt/IBM/db2/V9.7 that was by mistake as i tried with /opt/IBM/db2/V9.7_01 also.

    And we also tried by making the file executable but it still same error was coming.