note 69677 deleted from ref.mssql by bobby
| From: | bobby@php.net | Date: | Thu, 14 Sep 2006 21:55:34 +0000 |
| Subject: | note 69677 deleted from ref.mssql by bobby | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-117205@lists.php.net to get a copy of this message | ||
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 :)