FreeTDS Development Group

[will ezell <will AT dotmarketing.com>]

Hey all:

Couple of issues with php 4.03p1 on a standard RedHat 6.2 Intel box.

I had a lot of trouble compiling freetds into PHP.  I configured and made
freetds with:
./configure --with-tdsver=4.2 --enable-msdblib --enable-dbmfix --with-gnu-ld
--enable-shared --enable-static 
which worked ok.

Then I configured PHP with 

./configure --with-sybase-ct=/usr/local/freetds --with-imap=../imap-4.7

When I go to make php, it dies looking for -linsck. 

make[1]: Entering directory `/tars/php-4.0.3pl1'
/bin/sh /tars/php-4.0.3pl1/libtool --silent --mode=link gcc  -I.
-I/tars/php-4.0.3pl1/ -I/tars/php-4.0.3pl1 -I/tars/php-4.0.3pl1/main
-I/tars/php-4.0.3pl1/Zend -I/tars/php-4.0.3pl1 -I/tars/imap-4.7c/c-client
-I/tars/php-4.0.3pl1/ext/mysql/libmysql -I/usr/local/freetds/include
-I/tars/php-4.0.3pl1/ext/xml/expat/xmltok
-I/tars/php-4.0.3pl1/ext/xml/expat/xmlparse -I/tars/php-4.0.3pl1/TSRM
-DXML_BYTE_ORDER=12 -g -O2   -o php -export-dynamic     stub.lo libphp4.la
/usr/bin/ld: cannot find -linsck
collect2: ld returned 1 exit status
make[1]: *** [php] Error 1
make[1]: Leaving directory `/tars/php-4.0.3pl1'
make: *** [all-recursive] Error 1


Anyhow, I copied any missing sybase libs from my sybase/lib dir to my
freetds/lib dir, which allowed me to compile PHP+freetds.

Here is the catch.  This rig seems to work, except that I have to explicitly
set up a database connection before any query I run.  This means I have
pages that have 10+ sybase_pconnects.  The standard behavior for PHP+
xxx_pconnect() is to make that connection available to any following
database calls.  It does not matter if I set the connection to a variable
and use the var in the sybase_query() args.


Any help with the above issues would be greatly appreciated.



Thanks,


Will
will AT dotmarketing.com