IIS 7.0 + MSSQL + TestLink Issues
Posted: Thu Jun 03, 2010 8:46 am
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!
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!