Note Submitter: stephane dot Raviart at laposte dot net
----
Hello,
I've installed Sql Server 2000 on a Windows XP Professional machine. I've configured Apache and PHP as requested for running with SQL :
;extension=php_ming.dll
extension=php_mssql.dll
;extension=php_msql.dll
I've created an ODBC connector (sqlserver, user : sa pwd ="")
When I try following script :
<?php
$dsn="sqlserver";
$username="sa";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password) ;
$sqlquery="SELECT companyName FROM Customers;";
$process=odbc_exec($sqlconnect, $sqlquery);
while(odbc_fetch_row($process)){
$companyName = odbc_result($process,"companyName");
echo "$companyName<br>"; }
odbc_close($sqlconnect);
?>
for testins a standard SQL Server table (Northwind), I've no error message and nothing is appening. I had the same problem with MySQL test.
Each time I copy necessary file in Windows/System32 or Php/ext directory as it's recommended but I obtain always a white page without error or result.
Is somebody can help me about this problem ?
Best regards