IIS 7.0 + MSSQL + TestLink Issues

[samseah]

hello all,

i tired to implement testlink 1.8.5 on a windows server 08 with iis 7 (php 5.3.13 with fastcgi) installed which is to be connected to a ms-sql database. prior to this, i have already done a default installation of testlink on another machine with ms-sql database. testlink works perfectly well on that machine. as such, i've transferred the entire folder of testlink into the machine with windows server 08.

upon the move, i was unable to get testlink to connect to the database even after uncommenting the php_mssql.dll extension in php.ini and placing the ntwdblib.dll in the windows/system32 folder. when i tried to load testlink in the browser, a white screen appears.

i have tried to write a simple connectivity test to the ms-sql database but found that php fails to connect. i have also use phpinfo() and it returns that the mssql extension is enabled.

the code is as shown below:

<?php

$host_inst = hostname;
$username = 'username';
$password = 'password';


$dbconnect = mssql_connect($host_inst, $username, $password);

if ( $dbconnect ) {
echo '<b><font color="green">OK!</font></b>';
} else {
echo '<b><font color="red">FAILED</font></b>';
}

?>

it returns FAILED whenever i load this script.

any idea how can i get testlink to correctly connect to the database?

thanks in advance!

[TurboPT]

Not sure where this stands, but:

1. after making changes to the php.ini file, ensure to restart the webserver so that changes are applied.
2. the hostname should also be a string. [you may have it that way, it just appears without quotes in the post]
3. I think adding a piece of code to that script might help:
inside the 'else' block, after the FAILED echo, add this:

Code: Select all

// The 'last_message' might return an empty string, if no message was set by MSSQL.
echo "MSSQL error: " . mssql_get_last_message();

[havlatm]

Not your problem with connection but TL 1.8.5 supports only PHP 5.2 (not 5.3).