Just bought it and unfortunately I have the same problem.
Have SBS2003 with SQLServer2005.
Ended up installing PHP5.3 with FastCLI. All apps work except I can not get to the DB.
Unable to connect to the database:The MSSQL adapter "mssql" is not available.
The modules you are refering here are no longer supported, I tried in all ways imaginable and it would not work - this is the current version:
SQL Server Driver for PHP
Q: The PHP module is actually called php_sqlsrv.dll - it the Database type still mssql?
If I do a PHP test I can reach the server as well, reporting back the version:
"DriverDllName: sqlncli10.dll DriverODBCVer: 03.52 DriverVer: 10.00.2531 ExtensionVer: 1.1.428.1"
The PHP module is:
| Code: |
<?php
/*Connect to the local server using Windows Authentication and
specify the AdventureWorks database as the database in use. */
$serverName = "(local)";
$conn = sqlsrv_connect( $iciserver);
if( $conn === false )
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}
if( $client_info = sqlsrv_client_info( $conn))
{
foreach( $client_info as $key => $value)
{
echo $key.": ".$value."\n";
}
}
else
{
echo "Client info error.\n";
}
/* Close connection resources. */
sqlsrv_close( $conn);
?>
|
also reports it is loaded: sqlsrv
sqlsrv support enabled
Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On
Thanks for any help to get this working.
on a sidenote: your
pictures at the bottom are not working on the documentation
