RE: [PHP-DB] php/linux/mssql

> >>> > >>> So I don't get an error until I try to select a db. I run tcpdump > >>> at the same time just to make sure that it wasn't trying to connect > >>> to the remote server and there was no attempt to even make a > >>> connection. > > Have you tried running a 'make check' in your FreeTDS directory to run > the library's self-tests? I know I had to tweak a couple of things > before I got PHP to work with a MS SQL server, and most of them came in > the stages of getting FreeTDS working correctly before I even tried to > build it into PHP. Ok you are right make check failed here is a dump of the failure creating t0006 make check-TESTS make[7]: Entering directory `/usr/local/src/freetds-0.51/src/tds/unittests' t0001.c: Testing login, logout connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0001 t0002.c: Test basic submit query, results connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0002 t0003.c: Testing DB change -- 'use tempdb' connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0003 t0004.c: Test large (>512 bytes) queries connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0004 t0005.c: Test large (>512 bytes) replies connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0005 t0006.c: Test SYBREAL, SYBFLT8 values connect: Network is unreachable tds_connect() failed try_tds_login() failed FAIL: t0006 =================== 6 of 6 tests failed =================== I'm not to sure why I would get "Network is unreachable" I can reach the outside network just fine. Where do I find out where it is trying to connect and how? > Is your SYBASE environment variable set correctly? Have you > double-checked the sybase-related settings in your php.ini? Are you > using the --enable-dbmfix flag for configure when building FreeTDS? (If > so, have you made the appropriate changes in PHP's code or applied the > patches from the FreeTDS website?) I did compile FreeTDS with --enable-dbmfix flag, but I can't find any information on this patch that you are talking about. Should I just not use this flag? Miles Scruggs