Yii Framework Forum: SQL Server 2005 - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

SQL Server 2005 Rate Topic: -----

#1 User is offline   Perseverance 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 22-January 09
  • Location:Bulgaria

Posted 23 January 2009 - 07:52 AM

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

#2 User is offline   qiang 

  • Yii Project Lead
  • Yii
  • Group: Yii Dev Team
  • Posts: 5,892
  • Joined: 04-October 08
  • Location:DC, USA

Posted 23 January 2009 - 09:50 PM

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

#3 User is offline   mrlami 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 25
  • Joined: 03-March 09

Posted 16 March 2009 - 10:18 AM

Try...

http://us3.php.net/pdo

Attached File(s)


0

#4 User is offline   redyopante 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 8
  • Joined: 05-September 13

Posted 05 September 2013 - 11:07 PM

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' => 'mssql:host=172.31.1.248;dbname=ebudget',
//'emulatePrepare' => false,
'username' => 'sa',
'password' => 'XXXXXXXX',
'charset' => 'GB2312',
'tablePrefix' => 'tbl_',
),
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users