Best Way... Sql Server+Php

Yii 1.1 General Discussion
1

Hi everybody,

I have installed xampp and used Yii 1.1.14 + MYSQL and everything works fine.

Now I have to move my database to SQL Server 2008 R2 and cannot find driver wich matches my xampp(apache+php)

The question is

Can anyone give me link to any XAMPP(WITH mssql.dll,pdo_mssql.dll, or sqlsrv.dll) version,

or best way to do it without xampp or something

so I can connect to my sql server.

I have installed many XAMPP version, but still cannot connect!!!!!!!

Thanks

2

You have asked about this same issue a few times already. The "M" in "XAMPP" is for MySQL, not MS SQL Server. I doubt you will find an XAMPP configured with it, mainly because of the Microsoft license rather than any technical reasons.

The link I provided in the other post for the sqlsrv_pdo drivers should get you the drivers that you need but most likely you’ll have to give up XAMPP and run your app “natively”. Good luck.

3

From the url I would say you need to use sqlsrv_connect() after uncommenting the following lines in php.ini

[b];extension=php_mssql.dll

;extension=php_pdo_mssql.dll[/b]

Hope this helps?

4

I already removed semicolon, but it couldn’t find sqlsrv_connect() function, only connected with mssql_connect() function. And still not working

5

It works!!!!!!!!!!!!!

Thank you everybody,

  1. downloaded php_sqlsrv_53_ts_vc6.dll, php_pdo_sqlsrv_53_ts_vc6.dll files and copy them to C:\xampp\php\ext folder

  2. added to C:\xampp\php\php.ini following lines

extension=php_sqlsrv_53_ts_vc6.dll

extension=php_pdo_sqlsrv_53_ts_vc6.dll

  1. Finally connected with following ways



$serverName = "192.168.1.2"; //serverName\instanceName

$connectionInfo = array( "Database"=>"PDB", "UID"=>"sa", "PWD"=>"xxx");

$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {/*works*/}

else {/*error*/}

YII code




'db'=>array(

	'connectionString' => 'sqlsrv:server=192.168.1.2;Database=PDB;',			

	'username' => 'sa',

	'password' => 'xxx',

	'charset' => 'utf8',

),