[ycast]

Hi all

I would like to connect to a remote MS-SQL Server with the pdo_dblib driver (freetds) on CentOS 5.5.
After some minor problems with the OS configuration, I finally got the connection working with a manual connect with

$connection=new CDbConnection($dsn,$username,$password); 

Unfortunately, when using the Yii database component (as specified in config/main.php) I get the following error:

Quote

CDbConnection failed to open the DB connection: SQLSTATE[IM001]: Driver does not support this function: driver does not support setting attributes

when I try to retrieve the connection with this code in my Controller:

$connection = Yii::app()->db;

My db settings are as follows:

'db'=>array(
	'connectionString' => 'dblib:host=SERVER_IP;dbname=DB',
	'emulatePrepare' => false,
	'username' => 'USER',
	'password' => 'PASS',
	'charset' => 'utf8',
),

Any ideas why this is happening?
I would really like to use the "shared" connection instead of create a new one every time

Best regards
ycast

[Gustavo]

take a look here

[ycast]

Hi Gustavo. In my case, the PDO driver is installed and does work if I connect manually with

$connection=new CDbConnection($dsn,$username,$password);

.

But not when using

$connection = Yii::app()->db;

together with the db settings in config/main.php.

[Gustavo]

true, I read it in a hurry

the problem is that you can't set attributes to this driver

'charset' => 'utf8','emulatePrepare' => false,

I'm not sure tho which attributes you can or cannot set, as I haven't used this driver yet

[ycast]

Yeah! You were right: it was because of charset and emulatePrepare. Thanks alot
I think you can set the charset in freetds.conf with "client charset = UTF-8".

[marinovdf]

Gustavo, on 27 July 2011 - 12:22 PM, said:

true, I read it in a hurry

the problem is that you can't set attributes to this driver

'charset' => 'utf8','emulatePrepare' => false,

I'm not sure tho which attributes you can or cannot set, as I haven't used this driver yet

Gustavo, Thanks. It works

[Blaza]

Gustavo, on 27 July 2011 - 12:22 PM, said:

true, I read it in a hurry

the problem is that you can't set attributes to this driver

'charset' => 'utf8','emulatePrepare' => false,

I'm not sure tho which attributes you can or cannot set, as I haven't used this driver yet

Form me removing only 'emulatePrepare' => false,' was enough