[DB-SIG] mxODBC installation on Mac OS 10.2.3

Sun, 09 Feb 2003 12:40:03 +0100

Markus D=F6ring wrote:
> Hi,
> I am trying to install the mxODBC module for python 2.2 on a Mac OS=20
> 10.2.3 system using the default system(darwin build) python=20
> interpreter(2.2).
>=20
>=20
> I succesfully installed the egenix-mx-base-2.0.4 base package, but when=
=20
> trying to install the mxODBC module by running "sudo python setup.py=20
> install" I get the following error messsage:
>=20
>=20
> In file included from mx/ODBC/unixODBC/mxODBC.c:33:=20
> mx/ODBC/unixODBC/mxODBC.h:387:24: sqlucode.h: No such file or directory=
=20
> error:
> command 'gcc' failed with exit status 1
>=20
>=20
> Where does this header come from?
> Is "sqlucode.h " part of  unixODBC and do I have to install it too?
> iODBC is installed on my system.

sqlucode.h comes with unixODBC. If you only have iODBC
installed you can safely comment out the unixODBC part in
mxCOMMERCIAL.py of the package.

> Have you had reports about succesful installations of mxODBC on Mac OS =
X=20
> systems ?

Yes and many other Unix derivatives as well, e.g. AIX, HP-UX,
Solaris, etc. At most they needed a bit of tweaking in the
mxCOMMERCIAL.py file and sometimes mxSetup.py.

> Any help greatly appreciated,
>=20
> Markus
>=20
>=20
>=20
>  a log of the install process follows:
> -------------------------
>=20
> bash-2.05a$ sudo python setup.py install
> running install
> running build running mx_autoconf macros to define:
> macros to undefine:
> updated build_ext with autoconf setup running build_ext
>=20
> building extension "mx.ODBC.iODBC.mxODBC" (required) building 'mx.ODBC.
> iODBC.mxODBC' extension creating build creating build/temp.darwin-6.3-
> Power Macintosh-2.2 creating build/temp.darwin-6.3-Power Macintosh-2.2/
> mx creating build/temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC creating
> build/temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC/iODBC creating build/
> temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC/iODBC/mxODBC gcc -DNDEBUG -=
g -
> O3 -Wall -Wstrict-prototypes -no-cpp-precomp -DiODBC -Imx/ODBC/iODBC -I=
/
> usr/local/iODBC/include -I/usr/include/python2.2 -I/usr/include -I/usr/
> local/include -c mx/ODBC/iODBC/mxODBC.c -o build/temp.darwin-6.3-Power
> Macintosh-2.2/mx/ODBC/iODBC/mxODBC/mxODBC.o cc1: warning: changing
> search order for system directory "/usr/local/include" cc1: warning:
> as it has already been specified as a non-system directory cc1: warning=
:
> changing search order for system directory "/usr/include" cc1: warning:
> as it has already been specified as a non-system directory gcc -DNDEBUG=
 -
> g -O3 -Wall -Wstrict-prototypes -no-cpp-precomp -DiODBC -Imx/ODBC/iODBC=
 -
> I/usr/local/iODBC/include -I/usr/include/python2.2 -I/usr/include -I/us=
r/
> local/include -c mx/ODBC/iODBC/mxSQLCodes.c -o build/temp.darwin-6.3-
> Power Macintosh-2.2/mx/ODBC/iODBC/mxODBC/mxSQLCodes.o cc1: warning:
> changing search order for system directory "/usr/local/include" cc1:
> warning:   as it has already been specified as a non-system directory
> cc1: warning: changing search order for system directory "/usr/include"
> cc1: warning:   as it has already been specified as a non-system
> directory creating build/lib.darwin-6.3-Power Macintosh-2.2 creating
> build/lib.darwin-6.3-Power Macintosh-2.2/mx creating build/lib.darwin-6.
> 3-Power Macintosh-2.2/mx/ODBC creating build/lib.darwin-6.3-Power
> Macintosh-2.2/mx/ODBC/iODBC gcc -arch i386 -arch ppc -bundle -flat_
> namespace -undefined suppress build/temp.darwin-6.3-Power Macintosh-2.2=
/
> mx/ODBC/iODBC/mxODBC/mxODBC.o build/temp.darwin-6.3-Power Macintosh-2.2=
/
> mx/ODBC/iODBC/mxODBC/mxSQLCodes.o -L/usr/local/iODBC/lib -L/usr/lib -L/
> usr/local/lib -liodbc -o build/lib.darwin-6.3-Power Macintosh-2.2/mx/
> ODBC/iODBC/mxODBC.so ld: for architecture i386 ld: warning -L: director=
y
> name (/usr/local/iODBC/lib) does not exist ld: warning /usr/lib/bundle1.
> o cputype (18, architecture ppc) does not match cputype (7) for
> specified -arch flag: i386 (file not loaded) ld: warning build/temp.
> darwin-6.3-Power Macintosh-2.2/mx/ODBC/iODBC/mxODBC/mxODBC.o cputype (1=
8,
> architecture ppc) does not match cputype (7) for specified -arch flag:
> i386 (file not loaded) ld: warning build/temp.darwin-6.3-Power Macintos=
h-
> 2.2/mx/ODBC/iODBC/mxODBC/mxSQLCodes.o cputype (18, architecture ppc)
> does not match cputype (7) for specified -arch flag: i386 (file not
> loaded) ld: warning /usr/lib/libiodbc.dylib cputype (18, architecture
> ppc) does not match cputype (7) for specified -arch flag: i386 (file no=
t
> loaded) ld: warning /usr/lib/libgcc.a archive's cputype (18,
> architecture ppc) does not match cputype (7) for specified -arch flag:
> i386 (can't load from it) ld: warning /usr/lib/libSystem.dylib cputype =
(
> 18, architecture ppc) does not match cputype (7) for specified -arch
> flag: i386 (file not loaded) ld: for architecture ppc ld: warning -L:
> directory name (/usr/local/iODBC/lib) does not exist
>  building extension
> "mx.ODBC.unixODBC.mxODBC" (required) building 'mx.ODBC.unixODBC.mxODBC'
> extension creating build/temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC/
> unixODBC creating build/temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC/
> unixODBC/mxODBC gcc -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -no-cpp-
> precomp -DunixODBC -Imx/ODBC/unixODBC -I/usr/local/unixODBC/include -I/
> usr/include/python2.2 -I/usr/include -I/usr/local/include -c mx/ODBC/
> unixODBC/mxODBC.c -o build/temp.darwin-6.3-Power Macintosh-2.2/mx/ODBC/
> unixODBC/mxODBC/mxODBC.o cc1: warning: changing search order for system
> directory "/usr/local/include" cc1: warning:   as it has already been
> specified as a non-system directory cc1: warning: changing search order
> for system directory "/usr/include" cc1: warning:   as it has already
> been specified as a non-system directory In file included from mx/ODBC/
> unixODBC/mxODBC.c:33: mx/ODBC/unixODBC/mxODBC.h:387:24: sqlucode.h: No
> such file or directory
> error: command 'gcc' failed with exit status 1
>=20
>=20
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig

--=20
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
_______________________________________________________________________
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/