MSSQL (dblib): Driver does not support this function

Yii 1.1 Installation and Setup
1

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:

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

2

take a look here

3

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.

4

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

5

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".

6

Gustavo, Thanks. It works

7

Form me removing only ‘emulatePrepare’ => false,’ was enough

8

Gustavo you’re king !

9

So Thank`s, My I ask you to describe emulatePrepare in Yii db?