Re: [Iodbc-macosx] Have problem using 64-bit DB2 ODBC driver from GUI panel of iODBC Driver Manager

[Patrick v. K. <io...@op...>]

Hi,

>   On Mac OS X 10.8, we are trying to use DB2 ODBC Driver configured in iODBC Driver Manager GUI panel from OpenOffice Excel.
> DB2 ODBC Driver is of 64-bit driver. iODBC DM SDK installed from http://www.iodbc.org/downloads/iODBC/iodbc-sdk-3.52.7-macosx-10.5.dmg.
> I have configured one DB2 ODBC DSN in iODBC DM GUI panel.  When i do the test connection from GUI panel, i am getting the following error.
> 
> 
>  [iODBC][Driver Manager]dlopen(/Applications/dsdriver/lib/libdb2.dylib, 6): no suitable image found.  Did find:
>     /Applications/dsdriver/lib/libdb2.dylib: mach-o, but wrong architecture (0) SQLSTATE=00000
> 
> Does ODBC DM GUI panel support 64-bit Driver ?

Unfortunately at this time the iODBC DM GUI panel is written in Carbon, which only exists in 32bit mode. We are working on a new UI based on Cocoa but this is not finished yet.

For now this means you can configure a DSN to a 64bit driver, but you cannot make a UI test connection from within the DM to verify the connection. You can use the iodbctest commandline program to test the DSN you created.

As the OpenOffice Excel is a 64bit app, you will be able to use the iODBC DM and your DB2 ODBC driver since the rest of the iODBC DM is build in both 32 and 64bit mode.

Ideally you need a DB2 ODBC driver that contains both 32bit and 64bit component.

Patrick