Can't work with latest sql server driver with php 5.3.10

[wei80]

I tried to install the trial version with php 5.3.10, and the lastest php sql server driver. But it didn't work. It reported the following error:

Oops! There is an error:
You do not have the mssql PHP extension. Please have your host install it.

That would be a problem if it doesn't work with the latest stuff.

[Jason]

The error message is telling you exactly what you need -- the mssql extension.

[olasole]

arrowchat brings up an error (500) when trying to install with MSSQL

[Jason]

arrowchat brings up an error (500) when trying to install with MSSQL

Do you have the MSSQL PHP extension?

[FarhanNew]

I am also getting the same error, i have php 5.3.19 and mssql extension is installed.

using phpinfo() i can see sqlserver extension.

but still it is saying that you have to install it, please suggest

Thanks

[Jason]

We've been working on updating the mssql installation as it doesn't seem to work for some people.

[GSridhar]

did anyone figure out what is the solution for this? please share, if any.

[GSridhar]

Hi Jason,

Did you guys nail it? even at my server the MS SQL PHP extension is installed, but i still get this error. Would be great if you can help. Thanks.

[Jason]

Yes, this issue was already fixed. Anyone seeing this error now does not have the extension installed properly.

[kamaldewal]

HI Jason,

After trying all solution to install mssql extention for php for version 5.3 it is still not running
what to do now

[didio]

Anyone got arrowchat working with the Microsoft MSSQL extention on PHP 5.3 or 5.4?

[BrianKondalski]

I'm also having problems getting the MSSQL extension working on IIS7 in php 5.4

Any pointers would be helpful.

[BrianKondalski]

My phpinfo() call shows the module sqlsrv is enabled. And I can see the reference to it in my php.ini file as well (extension=php_sqlsrv_54_nts.dll).

[BrianKondalski]

I should note the following is also working fine from a .php page now running through the web server as well. Host and login info changed to something generic of course. But the arrowroot install is still telling me the mssql extension is not installed. I'm missing something somewhere I assume!

<?php

$serverName = “AA.BB.CC.DD";
$connectionInfo = array( "Database"=>”dbname", "UID"=>”uname", "PWD"=>”password");
$conn = sqlsrv_connect( $serverName, $connectionInfo );
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}

$sql = "SELECT top 10 EMAIL, HANDLE FROM USERS";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
echo $row['EMAIL'].", ".$row['HANDLE']."<br />\n";
}

sqlsrv_free_stmt( $stmt);

?>

[Jason]

Hi Brian,

The MSSQL extension requires PHP 5.2.x I believe as it was deprecated after that. We are working on switching over to sqlsrv which is more up-to-date.

[BrianKondalski]

Ok, then I am stuck for now. I am unable to change version of PHP. Hopefully I can get a new Trial once you make the switch. I can't do the integration with MySQL as all my user data is in SQL Server.

Is there any schedule on when this switch will be made?

[Staff Bot]

[b]This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.[/b]