Linux(PHP) + MSSQL 7 (NT)
bill at tcada.state.tx.us
Fri Feb 18 12:24:47 EST 2000
My experience has been with Red Hat 6.1 with PHP3 and Apache 1.3.9, FreeTDS
0.5, MS SQL 7. The following are some of the helpful things I've learned
(hopefully others will contribute their hard-won knowledge as well):
1) Make sure SQL Server 7 has SQL Server and NT authentication turned on
2) Connect to SQL Server with a userid local to SQL Server, not an NT
3) Stick with TDSVER=42 for the time being. Less buggy than 70, and
conversions from other data types seems to work well.
4) Keep a backup httpd handy in case you run into problems with locating
run-time libs. The docs discuss this, but I was dumb enough to run into
this problem anyway.
5) Have someone with Query Analyzer on an NT box verify your queries. It
helps to eliminate SQL Server and data errors before you start debugging
what went wrong in your PHP script.
6) Have sqsh compiled on your web server, to give you an alternate source
for generating SQL queries. This can also help pinpoint problems when
debugging PHP scripts.
More information about the FreeTDS