"The PDO_SQLSRV extension is only compatible with PHP running on Windows."
http://php.net/manual/en/ref.pdo-sqlsrv.php The SQLSRV one also won't work - everything is through *ODBC* MS Drivers. Linux Users need to install php-odbc and use PDO through that and the MS driver to access the MS SQL Database. But there is no CakePHP PDO-ODBC datasource for MSSQL I think! On Wednesday, February 8, 2012 2:32:54 AM UTC+8, trent wrote: > > Cake2 uses the new sqlsrv extension for php. This php extension is > available only from Microsoft. It is different than the old php-mssql > extension, and much better from what I hear. Fortunately Microsoft > recently made a linux 64bit version available: > > http://www.microsoft.com/download/en/details.aspx?id=28160 > > However if you cannot install that on your system you will need to use > freetds to get the dblib extension in pdo. Check your linux package > manager for freetds. (On ubuntu you simply install the php-sybase > package). > > Once installed I would recommend copying the old sqlsrv datasource, > renaming it to something else. Since it uses PDO the connection > string should be the biggest change: > > > https://github.com/cakephp/cakephp/blob/master/lib/Cake/Model/Datasource/Database/Sqlserver.php#L131 > > > reference here for the correct reference string: > > http://php.net/manual/en/ref.pdo-dblib.php > > I have used dblib before with PDO, but not with cake, but this should > work. It would be nice to have an alternative connection though. > > Trent > > > > On Feb 7, 10:12 am, Justin Edwards <[email protected]> wrote: > > I've spent a whole day trying to make this work with 2.x, no luck from > > linux. > > > > On Tue, Feb 7, 2012 at 8:51 AM, Gianluca Gentile < > [email protected] > > > > > > > > > > > > > > > > > wrote: > > > Hi all, > > > I need to connect my linux server (Debian 6) to Microsoft SQL Server > > > 2005 with CakePHP 2.0.6 but the PDO driver "Sqlserver" not exist for > > > Linux...How it's possible!? > > > > > Sorry for my english... :) > > > > > -- > > > Our newest site for the community: CakePHP Video Tutorials > > >http://tv.cakephp.org > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > [email protected] <javascript:> For more options, visit > this group > > > athttp://groups.google.com/group/cake-php -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
