#26296 [Opn->Bgs]: Warning: mssql_query(): message: Invalid object name

ID: 26296 Updated by: sniper@php.net Reported By: ameen at whitehouseit dot com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.3.4 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2003-11-18 01:48:03] ameen at whitehouseit dot com Description: ------------ Just i try to connect my database in SQL Server and fetch some records from the database. But it shows warning message like this. Warning: mssql_query(): message: Invalid object name 'mytable'. (severity 16) in D:\abc\Conn.php on line 21 Warning: mssql_query(): Query failed in D:\abc\Conn.php on line 21 How to rectify? i'm sure tables exists in my db. and also connection establishes perfectly. Reproduce code: --------------- $i=mssql_connect("localhost","uid","pwd") or die("unable to Connect"); if (mssql_select_db("mydb",$i)==true) echo "DB Exists"; else echo "DB Not Exists"; $sql="select * from mytable where login_id='myname'"; $rs=mssql_query($sql,$i); Expected result: ---------------- Warning: mssql_query(): message: Invalid object name 'mytable'. (severity 16) in D:\abc\Conn.php on line 21 Warning: mssql_query(): Query failed in D:\abc\Conn.php on line 21 Actual result: -------------- Fetch Records from db ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26296&edit=1