Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

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