mxODBC installation on Mac OS X

Sat Feb 8 08:26:08 EST 2003

Hi,
 I am trying to install the mxODBC module for python 2.2 on a Mac OS 
10.2.3 system using the default system(darwin) python interpreter(2.2).

I succesfully installed the egenix-mx-base-2.0.4 base package ( a 
prerequisite for mxODBC), but when trying to install the mxODBC module 
by running "sudo python setup.py install" I get the following error 
messsage:
 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

 Has anyone succesfully 
installed mxODBC on Mac OS X yet ? By searching a bit I found out that 
sqlucode.h seems to come with unixODBC. But I had no luck so installing 
it from the source or fink distribution.
 Any help greatly appreciated,

Markus

 a log of the install process follows:
-------------------------

bash-2.05a$ sudo python setup.py install Password: running install
running build running mx_autoconf macros to define: [] macros to 
undefine: [] updated build_ext with autoconf setup running build_ext

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/usr/
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: directory 
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 (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/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 not 
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