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
