Hi, I’m pretty frustrated trying to connect to an SQLServer 2000 DB using yii. That’s a legacy database and I want to make a new version of the front end using Yii, I have configured the db component in the protected/config/main.php:
'db'=>array( 'connectionString'=>'mssql:host=myhost;dbname=dbname', 'emulatePrepare' => false, 'username' => 'user', 'password' => 'password', 'charset' => 'utf8', ),
When I’m trying to generate the model with gii I have the message:
CDbConnection failed to open the DB connection: could not find driver
I have enabled the php extensions: php_mssql y php_pdo_mssql
I have read that SQLServer 2000 hasn’t support anymore but database migration is not an option by now, there’s another way to connect and work it with yii.
Thanks in advance