Problem with W2K, PHP 4.02 and SYBASE
| From: | TEN | Date: | Thu, 05 Oct 2000 18:13:14 +0000 |
| Subject: | Problem with W2K, PHP 4.02 and SYBASE | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-2960@lists.php.net to get a copy of this message | ||
Could someone please help me out here.
I am trying to connect to a sybase db, from php, which is running on W2K
(same on NT4).
The script look's like this
<?php
$db = sybase_pconnect("myserv", "myusr", "") ;
sybase_select_db("mydb",$db);
$result = sybase_query("SELECT col1, col2,..... FROM mytab",$db);
echo "<table border=1>\n";
echo "<tr><td>Code</td><td>Name</td>\n";
while ($myrow = sybase_fetch_row($result)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[0],
$myrow[1], $myrow[2]);
}
sybase_close($db);
?>
and the error look's this
<b>Warning</b>: Sybase: Server message: Changed database context to
'master'.
(severity 10, procedure N/A) in <b>sybase-test.php</b> on line
<b>3</b><br>
It is no problem using ISQL/SQLAdvantage with the same parameters.
BTW, the same scrip runs OK on linux.
TIA
TEN