Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: Compiling 09.00.0300 on OS X Snow Leopard

Posted on 2011-07-08 23:01:50 by Brian Panulla

--00235418776076aaea04a795245e
Content-Type: text/plain; charset=ISO-8859-1

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

--00235418776076aaea04a795245e
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I'm trying to use psqlODBC on OS X 10.6. I compiled from source with=A0=
configure arguments<div><div><br></div><div>  --with-iodbc --with-libpq=
=3D/opt/local/lib/postgresql90</div><div><br></div><div>I installed PG9 via=
MacPorts.</div>
<div><br></div><div>Using the iODBC driver test script gives me the errors:=
</div></div><div><br></div><div>  1: SQLDriverConnect =3D [iODBC][Drive=
r Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): no suitable image found. =
=A0Did find:</div>
<div><span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>/usr/=
local/lib/psqlodbcw.so: mach-o, but wrong architecture (0) SQLSTATE=3D00000=
</div><div>2: SQLDriverConnect =3D [iODBC][Driver Manager]Specified driver =
could not be loaded (0) SQLSTATE=3DIM003</div>
<div><br></div><div>The Makefile appears to have correctly determined my ar=
chitecture (x86_64-apple-darwin10.8.0).</div><div><br></div><div>Any sugest=
ions? Is there a better way to get the ODBC driver for OS X? It didn&#39;t =
appear to be included with any of the various packages in MacPorts.</div>
<div><br></div><div>-B</div>

--00235418776076aaea04a795245e--

Report this message

#2: Re: Compiling 09.00.0300 on OS X Snow Leopard

Posted on 2011-07-09 16:20:50 by Hiroshi Saito

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Report this message

#3: Re: Compiling 09.00.0300 on OS X Snow Leopard

Posted on 2011-07-16 01:10:47 by Brian Panulla

--0015174bebb2852da404a823c204
Content-Type: text/plain; charset=ISO-8859-1

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

--0015174bebb2852da404a823c204
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Sat, Jul 9, 2011 at 7:20 AM, Hiroshi Saito <s=
pan dir=3D"ltr">&lt;<a href=3D"mailto:hiroshi@winpg.jp">hiroshi@winpg.jp</a=
>&gt;</span> wrote:<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
..8ex;border-left:1px #ccc solid;padding-left:1ex;">

<br>
When it looks normal.<br>
2. please build the 09.00.0310<br>
It is correcting a little uneasy portion.<br></blockquote><div><br></div><d=
iv>Same problem with 0310.</div><div><br></div><div>I think there&#39;s som=
ething 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:</di=
v>
<div><br></div><div>=A0 =A0 =A0 ./configure --with-iodbc --without-libpq CC=
=3D&quot;gcc -arch x86_64&quot; CXX=3D&quot;g++ -arch x86_64&quot;</div><di=
v><br></div><div><div>=A0 =A0 =A0 ./configure --with-iodbc --without-libpq =
CC=3D&quot;gcc -arch i386&quot; CXX=3D&quot;g++ -arch i386&quot;</div>
</div><div><br></div><div>and stitching the two versions together with lipo=
(1).=A0I still couldn&#39;t load the driver successfully but the error mess=
age changed:</div><div><br></div><div><div>[iODBC][Driver Manager]dlopen(/u=
sr/local/lib/psqlodbcw.so, 6): Symbol not found: _CreateDataSource</div>
<div>=A0 Referenced from: /usr/lib/libiodbcinst.2.dylib</div><div>=A0 Expec=
ted in: flat namespace</div><div>=A0(0) SQLSTATE=3D00000</div></div><div><b=
r></div><div>I was able to get the driver to work by building against unixO=
DBC (installed from MacPorts) instead of iODBC. This works fine, though I n=
eeded to do a custom build of PHP to use it since the build included with 1=
0.6 is not built with unixODBC support.</div>
<div><br></div><div>-B</div></div>

--0015174bebb2852da404a823c204--

Report this message

#4: Re: Compiling 09.00.0300 on OS X Snow Leopard

Posted on 2011-07-16 06:49:46 by Hiroshi Inoue

Hi Brian,

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


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

regards,
Hiroshi Inoue



--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Report this message