Microsoft SQL Server Issues

More
4 years 6 months ago #86402 by helper
helper created the topic: Microsoft SQL Server Issues
Installation platform - With LimeSurvey Version 2.00+ Build 120931:
  • Windows 2008r2
  • MS SQL Server 2008
  • Apache 2.4
  • Php 5.4.7

Added DLL's to the php/ext directory and added the following in the php.ini:
extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll

Unable to install - get to the step for database and no matter what happens I receive an error "Try again! Connection with database failed."

Setup a test PHP file (items in square brackets have actual values):
<?php
$serverName = "[my sql server location],1433";

$connectionInfo = array("Database" => "[my database name]",
"UID" => "[user name]",
"PWD" => "[password]");
$conn = sqlsrv_connect($serverName, $connectionInfo);

if ($conn === false) {
die(print_r(sqlsrv_errors(), true));
} else {
echo 'connection okay';
}
?>

Above script works fine.

Did a code base check for "mssql_[value]" - found many instances (this is the older syntax for using the Micrsoft libraries). Conversely, I found NO instances for the new (3.0) libraries "sqlsrv_[value]." This would indicate to me that Lime cannot use the newer libraries.


Questions:

1. Are there any workarounds (other than stepping back to previous versions of PHP and older libraries from Microsoft)?

2. Are there any plans to getting the latest version of Lime to use the latest Microsoft libraries?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now