SQL Server 2005

system · January 23, 2009, 12:52pm

Hi there!

I was wondering what is the connection string for SQL Server 2005 ?Can You help me ?

qiang · January 24, 2009, 2:50am

This is a question about PDO. Maybe you can search for an answer online? I never used SQL server with PHP yet.

mrlami · March 16, 2009, 3:18pm

Try…

http://us3.php.net/pdo

redyopante · September 6, 2013, 4:07am

Hay All…

In my case, it is okay when i migration to create table using sql server 2005,. but when i want to generate model generator using gii,.

the error was "Table "table_name" does not exist"

what should i do???is it correct if i use mssql?or i must use sqlsrv

i use:

xampp php 5.2.5
sql server 2005 (SQL Server Management Studio Express) -> location of my db is in different PC with IP : 172.31.1.248
and in my db script protected\config\main.php is like this

‘db’=>array(

		'connectionString' =&gt; 'mssql:host=172.31.1.248;dbname=ebudget',


		//'emulatePrepare' =&gt; false,


		'username' =&gt; 'sa',


		'password' =&gt; 'XXXXXXXX',


		'charset' =&gt; 'GB2312',


		'tablePrefix' =&gt; 'tbl_',


	),