HELP! HELP! The error of ODBC
| From: | leudon | Date: | Wed, 26 Jul 2000 12:36:04 +0000 |
| Subject: | HELP! HELP! The error of ODBC | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-1323@lists.php.net to get a copy of this message | ||
i have install php4 in winY2K.and the odbc have passed the test.
but when i wrote down this code:
source code:
<?
$db=odbc_connect("citydata","sa","");
$strSql="select * from User WHERE USR='heinzli'";
echo ($strSql);
$result=odbc_exec($db,$strSql);
?>
when i run,browser give this error message:
select * from User WHERE USR='heinzli'
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'User'., SQL state S0002 in SQLExecDirect in
c:\inetpub\wwwroot\DB.PHP on line 6