note 95100 added to function.mssql-connect
| From: | thornhawk at osu1 dot php dot net | Date: | Sun, 13 Dec 2009 22:00:19 +0000 |
| Subject: | note 95100 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-163908@lists.php.net to get a copy of this message | ||
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";
----
Server IP: 117.55.229.1
Probable Submitter: 124.191.97.177
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/95100
Del: integrated -- https://master.php.net/note/delete/95100/integrated
Del: useless -- https://master.php.net/note/delete/95100/useless
Del: bad code -- https://master.php.net/note/delete/95100/bad+code
Del: spam -- https://master.php.net/note/delete/95100/spam
Del: non-english -- https://master.php.net/note/delete/95100/non-english
Del: in docs -- https://master.php.net/note/delete/95100/in+docs
Del: other reasons-- https://master.php.net/note/delete/95100
Reject -- https://master.php.net/note/reject/95100
Search -- https://master.php.net/manage/user-notes.php