Re: Compiling 09.00.0300 on OS X Snow Leopard

I'm trying to use psqlODBC on OS X 10.6. I compiled from source
with configure arguments

--with-iodbc --with-libpq=/opt/local/lib/postgresql90

I installed PG9 via MacPorts.

Using the iODBC driver test script gives me the errors:

1: SQLDriverConnect = [iODBC][Driver
Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): no suitable image found.
Did find:
/usr/local/lib/psqlodbcw.so: mach-o, but wrong architecture (0)
SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be
loaded (0) SQLSTATE=IM003

The Makefile appears to have correctly determined my architecture
(x86_64-apple-darwin10.8.0).

Any sugestions? Is there a better way to get the ODBC driver for OS X? It
didn't appear to be included with any of the various packages in MacPorts.

-B

Hi Brian-san.

Please try the following,

1. relation is investigated by ldd.
ldd /usr/local/lib/psqlodbcw.so

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

although verification is impossible by me. sorry, I don't have MAC
machine. However, More information may be able to obtain someone's
suggestion.

Regards,
Hiroshi Saito

(2011/07/09 6:01), Brian Panulla wrote:
> I'm trying to use psqlODBC on OS X 10.6. I compiled from source
> with configure arguments
>
> --with-iodbc --with-libpq=/opt/local/lib/postgresql90
>
> I installed PG9 via MacPorts.
>
> Using the iODBC driver test script gives me the errors:
>
> 1: SQLDriverConnect = [iODBC][Driver
> Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): no suitable image found.
> Did find:
> /usr/local/lib/psqlodbcw.so: mach-o, but wrong architecture (0)
> SQLSTATE=00000
> 2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not
> be loaded (0) SQLSTATE=IM003
>
> The Makefile appears to have correctly determined my architecture
> (x86_64-apple-darwin10.8.0).
>
> Any sugestions? Is there a better way to get the ODBC driver for OS X?
> It didn't appear to be included with any of the various packages in
> MacPorts.
>
> -B

On Sat, Jul 9, 2011 at 7:20 AM, Hiroshi Saito <hiroshi(at)winpg(dot)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

Hi Brian,

(2011/07/16 8:10), Brian Panulla wrote:
> On Sat, Jul 9, 2011 at 7:20 AM, Hiroshi Saito <hiroshi(at)winpg(dot)jp
> <mailto:hiroshi(at)winpg(dot)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 found the following page iODBC does not work under Mac OSX 10.6.4

http://stackoverflow.com/questions/3905093/iodbc-does-not-work-under-mac-osx-10-6-4

regards,
Hiroshi Inoue