mssql with php 5.3 on windows setup

Although I am also in email contact, I start a thread here because it might help others.

I am on a windows server setup, using all the latest material:
WSRV2008R2 with IIS 7.5. I have also installed PHP 5.3.5 on that machine with the MSSQL driver loaded in PHP.ini
Checked and working.
My MSSQL server is on a remote machine but tested and working with remote connections.

Running Joomla 1.7 installed with the latest Table JX I cannot get it to work. The moment I input the Server details and click the "check the DB and Tables" button I get a blank screen.

TableJX works with ntwdblib.dll but that extension is not supported under PHP 5.3.

If I can make a test call to the mssql driver it should not be too difficult to do the same from within the program.
The only pitfall I have seen is that the mssql driver uses windows authentication by default. Something to watch out for when connecting or giving credentials.

The component looks really useful but for now it is not working as expected. Hope this is solved quickly.

Yeah not work to..

just work with :



<?php

$serverName = 'WNX-SERVER\SQLEXPRESS';

/* Get UID and PWD from application-specific files. */
$uid = 'user';
$pwd = 'passwd';
$myDB ='DB';
$connectionInfo = array( "UID"=>$uid,
"PWD"=>$pwd,
"Database"=>$myDB);

/* Connect using SQL Server Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn = false )
{
echo "Unable to connect.</br>";
die( print_r( sqlsrv_errors(), true));
}

echo "<center><h2><b><u>Connected successfully.. next ur mine..</b></u></h2></center>";
?>