Re: Compiling 09.00.0300 on OS X Snow Leopard - Mailing list pgsql-odbc

From Brian Panulla
Subject Re: Compiling 09.00.0300 on OS X Snow Leopard
Date
Msg-id CANavk+351G1cJKWin4jzQTbC_680kRXsWktt5DXMQ4hGMF6G0A@mail.gmail.com
Whole thread Raw
In response to Re: Compiling 09.00.0300 on OS X Snow Leopard  (Hiroshi Saito <hiroshi@winpg.jp>)
Responses Re: Compiling 09.00.0300 on OS X Snow Leopard  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
On Sat, Jul 9, 2011 at 7:20 AM, Hiroshi Saito <hiroshi@winpg.jp> wrote:

When it looks normal.
2. please build the 09.00.0310
It is correcting a little uneasy portion.

Same problem with 0310.

I think there's something wrong with iODBC support on Mac OS X 10.6. I made a 32bit/64bit fat binary by building the driver twice with different configure arguments:

      ./configure --with-iodbc --without-libpq CC="gcc -arch x86_64" CXX="g++ -arch x86_64"

      ./configure --with-iodbc --without-libpq CC="gcc -arch i386" CXX="g++ -arch i386"

and stitching the two versions together with lipo(1). I still couldn't load the driver successfully but the error message changed:

[iODBC][Driver Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): Symbol not found: _CreateDataSource
  Referenced from: /usr/lib/libiodbcinst.2.dylib
  Expected in: flat namespace
 (0) SQLSTATE=00000

I was able to get the driver to work by building against unixODBC (installed from MacPorts) instead of iODBC. This works fine, though I needed to do a custom build of PHP to use it since the build included with 10.6 is not built with unixODBC support.

-B

pgsql-odbc by date:

Previous
From: Hiroshi Saito
Date:
Subject: Re: psqlODBC 09.00.0310 and oids
Next
From: Hiroshi Inoue
Date:
Subject: Re: Compiling 09.00.0300 on OS X Snow Leopard