[egenix-users] Installing mxODBC on Solaris 8

[Lars Rehe]

Dear listmembers,

I need to install the mxODBC package on a Sparc/Solaris 8 machine.

I want to use the EasySoft ODBC-ODBC bridge from a python application and 
tried to install mxODBC. I followed the 'Manual Installation Procedure':

1. unpack
2. in mx/ODBC/EasySoft 'make -f Makefile.pre.in boot
3. edited 'Setup' and uncommented lines 417-420 (ODBC interface to EasySoft 
ODBC-ODBC Bridge)
4. make returns the following error:
> gcc -fPIC -DNDEBUG -g -O3 -Wall -Wstrict-prototypes 
> -I/usr/local/projects/e-net_apache_webserver/python-2.3.4/include/python2.3 
> -I/usr/local/projects/e-net_apache_webserver/python-2.3.4/include/python2.3 
> @DEFS@   -DMAL_DEBUG -DWANT_UNICODE_SUPPORT -DMISSING_SETUP
> -c ././mxSQLCodes.c -o ./mxSQLCodes.o  
> gcc: cannot specify -o with -c or -S and multiple compilations
> *** Error code 1
> make: Fatal error: Command failed for target `mxSQLCodes.o'

I tried to follow the instructions that were given in reply to 
http://www.egenix.com/mailman-archives/egenix-users/2004-April/000408.html 
(Problem building egenix-mx-commercial) but that didn't help. When I tried 
'python setup.py install in the root-directory of the source-package, there 
were a lot of gcc errors:
> In file included from mx/ODBC/iODBC/mxODBC.c:33:
> mx/ODBC/iODBC/mxODBC.h:239:19: sql.h: No such file or directory
> mx/ODBC/iODBC/mxODBC.h:240:22: sqlext.h: No such file or directory
> In file included from mx/ODBC/iODBC/mxODBC.c:33:
> mx/ODBC/iODBC/mxODBC.h:682: error: parse error before "SQLHDBC"
> mx/ODBC/iODBC/mxODBC.h:682: warning: no semicolon at end of struct or union
> mx/ODBC/iODBC/mxODBC.h:699: error: parse error before ':' token
<snip>

I admit that this is my first experience with python and its modules and that 
I am not a C-programmer, so think in 'newbie'-terms.

Thanks for your time,
 Lars

-- 
  To boldly go where I surely don't belong.

  Lars Rehe
  Alfred Wegener Institut für Polar- und Meeresforschung