pdo with sqlsrv - Printable Version

pdo with sqlsrv - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: pdo with sqlsrv (/showthread.php?tid=47047)

pdo with sqlsrv - El Forum - 11-24-2011

[eluser]Unknown[/eluser]
it seems that pdo with sqlsrv is broken.

In the documentation of the pdo-sqlsrv driver there is the connection describe like this:

Code:
$conn = new PDO( "sqlsrv:server=(local) ; Database = $database", "", "");

But Codeigniter try some like this:

Code:
$conn = new PDO( "sqlsrv:server=(local) ; [b]dbname[/b]= $database", "", "");

Also the result is not running. CI always try to use LIMIT inside the sql statements. But the sqlsrv can´t understand this...