Re: Getting PHP on FreeBSD to talk to MSSQL Server 7...

Glenn Sieb wrote:

Hi.. it's me again :) We have a few different servers here, most of which are FreeBSD, including our internal web server (Apache 1.3.24). We have PHP 4.2.0 installed as well. Currently I'm running my MSSQL query scripts on a Win2k webserver, as I can't seem to get PHP to talk to MSSQL on the FreeBSD side. I'd really prefer to have my PHP scripts all running on the FreeBSD side, rather than on Win2k. We do have Perl able to talk to the MSSQL server using FreeTDS and the DBI::Sybase package on the same FreeBSD machine. My ./configure: ./configure --prefix=/usr/local --with-apache=/home/src/Apache/Apachetoolbox -1.5.56/apache_1.3.24 --enable-exif --enable-track-vars --with-calendar=shared - -enable-safe-mode --enable-magic-quotes --enable-trans-sid --enable-wddx --enabl e-ftp --with-gd=/usr/local --with-zlib --enable-gd-native-tt --with-t1lib=/usr/l ocal --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-zlib-dir=/usr - -with-ttf --with-freetype-dir=/usr/local --with-unixodbc=/usr/local/unixODBC --w ith-openssl=/usr/local --with-curl=/usr/local --enable-apc --with-mysql=/sw/mysq l --with-mssql=/usr/local/etc/freetds --with-sybase=/usr/local/etc/freetds (built using ApacheToolbox, 1.5.56) FreeTDS' interfaces file is located in /usr/local/etc/freetds, which it is/was my understanding that this is what's supposed to be there. Yet not only does PHP give me:

the --with-sybase= line needs to point to where freetds was compiled, not the interfaces file. We don't use the interfaces file, which seems to be primarily a way to map names to IPs. We just use the IP address directly in the mssql_connect() functions and it works. Michael Kimsal http://www.phphelpdesk.com