note 95100 deleted from function.mssql-connect by cmb
| From: | cmb@php.net | Date: | Sun, 11 Aug 2019 12:48:58 +0000 |
| Subject: | note 95100 deleted from function.mssql-connect by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211864@lists.php.net to get a copy of this message | ||
Note Submitter: thornhawk
----
After months of searching, I have discovered the most simple way of connecting Php to MS Sql Express
/ Enterprise:
-- Use the Microsoft SQL Server Driver for PHP! --
1) Download from http://tiny.cc/fkGzf
2) Place php_sqlsrv_ts.dll in your php extensions folder.
3) Enable php_sqlsrv_ts.dll in your php.ini -> extension=php_sqlsrv_ts.dll
4) Follow the documentation and api reference at http://msdn.microsoft.com/en-us/library/cc296152%28SQL.90%29.aspx
This works on apache, lighttpd, wampserver (haven't tested on IIS).
You no longer need to worry about the ntwdblib.dll or whether your web server is in FastCGI mode or
not.
Absolutely simple and it connects straight away!
Just remember to use the correct server name: $serverName = "<computer
name>\SQLEXPRESS";