note 103783 added to mssql.setup

mssql install-setup as so on linux: get freetds package 1. wget ftp://ftp.ibiblio.org/pub/Linux/ ALPHA/freetds/stable/freetds-stable.tgz 2. uncompress and cd 2 sources folder 3. ./configure --enable-msdblib --prefix=/usr/local/freetds 4. make 5. make install copy some supplementary files 6. cp include/tds.h /usr/local/freetds/include 7. cp src/tds/.libs/libtds.a /usr/local/freetds/lib get php devel sources if you don't have it and install it get php sourcers files, uncompress it, chdir 8. chdir ext/mssql 8. phpize 9. ./configure --with-mssql=/usr/local/freetds 10. make 11. cp modules/mssql.so phpextensionpath, or make install 12. echo "/usr/local/freetds/lib" >> /etc/ld.so.conf and echo "export FREETDSCONF=/usr/local/freetds/etc/freetds.conf" >> /etc/profile add in extension section 13. extension=mssql.so to php.ini add in httpd.conf right above "Include /etc/httpd/mod_php.conf" 14.SetEnv FREETDSCONF /usr/local/freetds/etc/freetds.conf 15. set you server connection in /usr/local/freetds/etc/freetds.conf for testing w/o reboot server: 16. export FREETDSCONF=/usr/local/freetds/etc/freetds.conf 17. restart apache 18. verify mssql enabled with phpinfo() 19. run your test script. 20. other fine tunnigs and settings pls. keep in mind: - your ms SQL must be setup with socket listing ;) - check windoze box firewall to accept TCP 1433 connection. Enjoy! Dragos ---- Server IP: 69.147.83.197 Probable Submitter: 89.120.120.115 ---- Manual Page -- http://www.php.net/manual/en/mssql.setup.php Edit -- https://master.php.net/note/edit/103783 Del: integrated -- https://master.php.net/note/delete/103783/integrated Del: useless -- https://master.php.net/note/delete/103783/useless Del: bad code -- https://master.php.net/note/delete/103783/bad+code Del: spam -- https://master.php.net/note/delete/103783/spam Del: non-english -- https://master.php.net/note/delete/103783/non-english Del: in docs -- https://master.php.net/note/delete/103783/in+docs Del: other reasons-- https://master.php.net/note/delete/103783 Reject -- https://master.php.net/note/reject/103783 Search -- https://master.php.net/manage/user-notes.php