note 91261 added to book.mssql
| From: | opc dot three at gmail dot com | Date: | Tue, 02 Jun 2009 15:50:39 +0000 |
| Subject: | note 91261 added to book.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-156297@lists.php.net to get a copy of this message | ||
After extensive research trying to get PHP on Linux communicating with SQL Server 2005 and 2008
including support for all Unicode, MAX and XML data types I could not find any open source
solutions...yes, I spent a lot of time trying to get FreeTDS to work to no avail.
I found one free solution that runs on Windows which is to use the "SQL Server Driver for
PHP" provided by Microsoft (http://sql2k5php.codeplex.com). The driver relies on the Microsoft
Native Client ODBC drivers for SQL Server 2008 (part of the "Microsoft SQL Server 2008 Native
Client" which is downloadable from Microsoft) which is why this solution will not work on
anything except Windows.
I did find a solution that works for PHP on Linux but it's not free...use the standard
PHP::ODBC lib (free) and the Easysoft ODBC driver for SQL Server (not free, but reasonable by
Enterprise standards). You can check out the ODBC driver by going here http://www.easysoft.com/products/data_access
and looking for "Easysoft ODBC-SQL Server Driver"
----
Server IP: 69.147.83.197
Probable Submitter: 63.214.184.6
----
Manual Page -- http://www.php.net/manual/en/book.mssql.php
Edit -- https://master.php.net/note/edit/91261
Del: integrated -- https://master.php.net/note/delete/91261/integrated
Del: useless -- https://master.php.net/note/delete/91261/useless
Del: bad code -- https://master.php.net/note/delete/91261/bad+code
Del: spam -- https://master.php.net/note/delete/91261/spam
Del: non-english -- https://master.php.net/note/delete/91261/non-english
Del: in docs -- https://master.php.net/note/delete/91261/in+docs
Del: other reasons-- https://master.php.net/note/delete/91261
Reject -- https://master.php.net/note/reject/91261
Search -- https://master.php.net/manage/user-notes.php