FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Matt Davies wrote:
> cd freetds-0.64/
> ./configure --prefix=/usr/local/freetds 

With that prefix, sqlfront.h is installed in /usr/local/freetds/include.  

> make
> sudo make install
> cd ../pymssql-0.8.0/
...
> building '_mssql' extension
> gcc -arch ppc -arch i386 -isysroot /Developer/SDKs/MacOSX10.4u.sdk
> -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd
> -fno-common -dynamic -DNDEBUG -g -O3 -I/usr/include -I/usr/local/include
> -I/usr/include/freetds -I/usr/local/include/freetds
> -I/usr/pkg/freetds/include
> -I/Library/Frameworks/Python.framework/Versions/2.4/include/python2.4 -c
> mssqldbmodule.c -o build/temp.macosx-10.3-fat-2.4/mssqldbmodule.o
> mssqldbmodule.c:45:24: error: sqlfront.h: No such file or directory

See the -I options?  None of them is where sqlfront.h was installed, and
marabilis dictu the compiler can't find it.  ;-)

You're almost home free.  Probably the easiest thing is to leave off the
--prefix option when you configure freetds:

        $ rm -rf /usr/local/freetds
        $ ./configure --enable-msdblib
        $ make && sudo make install

which will put sqlfront.h in /usr/local/include (the default).  Then the
above gcc command will succeed.  

Btw the Sybase variable isn't used to build FreeTDS and I don't think it's
used to build the python mssql extension either.  

HTH.  

--jkl