Page 1 of 1

mssql & ph bug???

Posted: Thu Jan 30, 2003 1:23 am
by Guy
hello all
when I load a page, I go to the database get my values, and put them into a form.
on submit I call a stored procedure using mssql_query.
it works, and saves the information to the database.
BUT, when reloading the page after the sp, I get an this warning:

Code: Select all

Warning: MS SQL: Unable to select database: MyDB in 
d:\phpsite\INCLUDE\DBManager.php on line 7
the same sql works perfectly fine when loading the page the first time.
I tried to release the result of the query using mssql_free_result
but it didn't work.
im using mssql-connect. win2k, and mssql 2000
any idea's
thanks
Guy