no because there is no such datasource in 2.x: https://github.com/cakephp/datasources/tree/2.0/Model/Datasource/Database
Am Donnerstag, 12. April 2012 02:37:18 UTC+2 schrieb rchavik: > > Mark, > > Try https://groups.google.com/d/topic/cake-php/WgIhA0mj89M/discussion and > see wether it's relevant to your environment. > > On Thursday, April 12, 2012 2:52:53 AM UTC+7, euromark wrote: >> >> in the $mssql it's 'database' => 'database' - but thats not that >> important. >> >> we also tried the SqlSrv datasource from the Datasources plugin (cakephp >> github) >> But this seems to use the sqlsrv extension which is also not available on >> our linux setup >> >> >> >> Am Mittwoch, 11. April 2012 21:29:24 UTC+2 schrieb euromark: >>> >>> We have been trying for hours getting a second datasource to work which >>> connects to a MS Sql Server (2008) from linux. >>> On windows we have running the "pdo_sqlserv" extension. And with a few >>> hours of trial and error and installation of different drivers we got it up >>> and running. >>> We use the following datasource: >>> >>> public $mssql = array( >>> 'datasource' => 'Database/Sqlserver', >>> 'host' => '192.168.0.2\SQLEXPRESS', >>> 'login' => 'user', >>> 'password' => 'pwd', >>> 'database' => 'table', >>> ); >>> >>> On linux, though, we cannot get pdo_sqlserv to run (confirmed with >>> phpinfo). Only mssql (for plain mssql where is no datasource for) or >>> pdo_dblib. >>> The latter is supposed to be the eqivalent to the windows pdo_sqlserv >>> but the datasource always errors with `datasource could not be created`. >>> >>> What does work, though, is using this manuel statement: >>> >>> $dsn = 'dblib:dbname=database;host=192.168.0.2\sqlexpress'; >>> $user = 'user'; >>> $password = 'pwd'; >>> >>> $dbh = new PDO($dsn, $user, $password); >>> >>> $stmt = $dbh->prepare("SELECT * FROM tablename"); >>> $stmt->execute(); >>> while ($row = $stmt->fetch()) { >>> ... >>> } >>> >>> So the connection details seem to be right and the connection is >>> establishable. >>> Only the extension/module which our Sqlserver datasource is expeting is >>> not really working. >>> We have to use this manual snippet which, of course, is incompatible to >>> the rest of the model code (which uses the datasource for find(first) and >>> find(all) queries). >>> >>> note: that we replaced "sqlserv:" with "dblib:" here in order to get it >>> to work. >>> So is there some special dblib datasource here for linux? Or what's >>> going on? >>> thx >>> >>> -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
