Welcome, Guest
Username: Password: Remember me

TOPIC: Microsoft SQL Server Issues

Microsoft SQL Server Issues 1 year 10 months ago #86402

  • helper
  • helper's Avatar
  • OFFLINE
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
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?
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.095 seconds
Donation Image