Have you installed the sqlsrv PDO driver?  Also you'll need a recent
version of SQLServer. It was developed and tested against SQLServer
2008.

-Mark

On Oct 10, 11:14 am, Ernesto <e.fanz...@gmail.com> wrote:
> Hi all.
> i'm having some troubles with Cake 2.0 + SQLServer datasource
>
> i'm getting a "Sqlserver requires a database connection" error every time i
> use the "external_db" config.
>
> here's my database.php
>
> class DATABASE_CONFIG {
>
>  public $default = array(
> "datasource" => "Database/Mysql",
> "persistent" => false,
> "host" => "127.0.0.1",
>   "login" => "ernesto",
>   "password" => "***",
>   "database" => "my_db"
>  );
>
>  public $external_db = array(
> "datasource" => "Database/Sqlserver",
> "persistent" => false,
>   "host" => "192.168.0.10\MSSQLDB",
>   "port" => "1970",
>   "login" => "ernesto",
>   "password" => "***",
>   "database" => "Ernesto_DB"
>  );
>
>
>
>
>
>
>
> }

-- 
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to