Skip site navigation (1) Skip section navigation (2)

Re: Compiling 09.00.0300 on OS X Snow Leopard

From: Brian Panulla <bpanulla(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Compiling 09.00.0300 on OS X Snow Leopard
Date: 2011-07-15 23:10:47
Message-ID: CANavk+351G1cJKWin4jzQTbC_680kRXsWktt5DXMQ4hGMF6G0A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2011-07-16 04:49:46
Subject: Re: Compiling 09.00.0300 on OS X Snow Leopard
Previous:From: Hiroshi SaitoDate: 2011-07-13 13:28:07
Subject: Re: psqlODBC 09.00.0310 and oids

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group