note 76168 added to ref.mssql

Having trouble connecting to a MS SQL Server from Windows server with Apache + PHP, or some other server-configuration? As Tom at mazzotta dot com wrote further down on this page; too old MDAC in Windows may be your problem. Here is a summary for those working on Windows-plattform: 1. Update your Microsoft MDAC (search for Microsoft Data Access Components on www.microsoft.com). Some older Microsoft servers (or workstations) contain old and crappy MDAC-installations. This solved our problem after two days of work.. 2. Make sure ntwdblib.dll (version 8.00.194) is in the correct place(s). I only placed it in Apache bin directory and it worked fine, but apparently some Microsoft installations need it in several locations.. this is indeed very confusing! 3. You may have to set mssql.secure_connection = off in your php.ini 4. Make sure needed ports are configured in your firewall. Hope this helps - now, back to coffee! ---- Server IP: 128.39.198.38 Probable Submitter: 84.234.133.92 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/76168 Del: integrated -- https://master.php.net/note/delete/76168/integrated Del: useless -- https://master.php.net/note/delete/76168/useless Del: bad code -- https://master.php.net/note/delete/76168/bad+code Del: spam -- https://master.php.net/note/delete/76168/spam Del: non-english -- https://master.php.net/note/delete/76168/non-english Del: in docs -- https://master.php.net/note/delete/76168/in+docs Del: other reasons-- https://master.php.net/note/delete/76168 Reject -- https://master.php.net/note/reject/76168 Search -- https://master.php.net/manage/user-notes.php