I have read all of the posts here about FreeTDS and none of them have solved my problem.
I am using:
FreeBSD 5.1
PHP 4.3.2
FreeTDS .61
MSSQL 2K (different box)
I did a clean install on FreeTDS.
I edited /usr/local/etc/freetds/interfaces.dist
myserver
query tcp eth0 myWebServer 1433
master tcp eth0 myWebServer 1433
I went into /usr/ports/www/mod_php4/
make clean
make
//chose to build with Sybase/MSSQL (DB-lib) support
I restarted apache
apachectl stop
apachectl start
On my Win2K box, I turned on the TCP/IP support for connections.
but, alas, I get mssql_connect is not defined. I have checked freetds.org and can not find solutions to my problem. I run phpinfo and it doesn't show in FreeTDS in there though. I can't tell where it is going wrong.
I also try to connect with tsql to test the connection
tsql -S myWebServer -U username
but it says that there was a problem connecting
