note 98743 added to function.mssql-connect

If you have an application which requires MSSQL as interface (and not the new SQLSRV) you have to look for an alternative method. The old (now rightly unsupported) way from Microsoft does not work with PHP 5.3. After spending several days and nights with trying to connect here is an easy solution which worked great with all applicatins expecting mssql: FreeTDS for Windows. Here is a great how to with installer links on the Moodle site: http://docs.moodle.org/en/Installing_MSSQL_for_PHP Couple of hints: - Make sure you have set up a user with "SQL SERVER authentication" who has rights to connect. - Also make sure after you install and still have problems to run PHPinfo and check that you find the below: PHPINFO: mssql MSSQL Support enabled ... Library version FreeTDS That works perfect for me on Windows 2003 with IIS6 and PHP 5.3 (non threadsafe, VC9). Hope this is helpful ---- Server IP: 69.147.83.197 Probable Submitter: 65.44.83.34 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/98743 Del: integrated -- https://master.php.net/note/delete/98743/integrated Del: useless -- https://master.php.net/note/delete/98743/useless Del: bad code -- https://master.php.net/note/delete/98743/bad+code Del: spam -- https://master.php.net/note/delete/98743/spam Del: non-english -- https://master.php.net/note/delete/98743/non-english Del: in docs -- https://master.php.net/note/delete/98743/in+docs Del: other reasons-- https://master.php.net/note/delete/98743 Reject -- https://master.php.net/note/reject/98743 Search -- https://master.php.net/manage/user-notes.php