Page 1 of 1
Can't work with latest sql server driver with php 5.3.10
PostPosted: 08 May 2012, 09:50
by 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.
PostPosted: 08 May 2012, 14:37
by Jason
The error message is telling you exactly what you need -- the mssql extension.
PostPosted: 23 Jun 2012, 06:31
by olasole
arrowchat brings up an error (500) when trying to install with MSSQL
PostPosted: 23 Jun 2012, 07:57
by Jason
olasole wrote:arrowchat brings up an error (500) when trying to install with MSSQL
Do you have the MSSQL PHP extension?
PostPosted: 08 Jan 2013, 06:23
by 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
PostPosted: 08 Jan 2013, 10:19
by Jason
We've been working on updating the mssql installation as it doesn't seem to work for some people.
PostPosted: 29 Jun 2013, 03:31
by GSridhar
did anyone figure out what is the solution for this? please share, if any.
PostPosted: 29 Jun 2013, 03:41
by 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.
PostPosted: 29 Jun 2013, 13:06
by Jason
Yes, this issue was already fixed. Anyone seeing this error now does not have the extension installed properly.
PostPosted: 12 Jul 2013, 00:29
by 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
PostPosted: 03 Apr 2014, 00:50
by didio
Anyone got arrowchat working with the Microsoft MSSQL extention on PHP 5.3 or 5.4?
PostPosted: 12 May 2014, 11:03
by BrianKondalski
I'm also having problems getting the MSSQL extension working on IIS7 in php 5.4
Any pointers would be helpful.
PostPosted: 12 May 2014, 11:16
by 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).
PostPosted: 12 May 2014, 12:08
by 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);
?>
PostPosted: 12 May 2014, 20:10
by 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.
PostPosted: 13 May 2014, 06:20
by 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?
Topic Closed
PostPosted: 16 Dec 2014, 00:26
by 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]