RE: [PHP-DB] MS SQL 'Changed database context' error

Try putting the error suppressor (@) before the query, eg: @mssql_query Or, try setting the error reporting: error_reporting(0); On Thu, 2004-02-19 at 14:38, Michael Flanagan wrote: > Thanks, Adam. > > I don't get the error in Enterprise manager. MS has a KB article out that > says that this message is informational. I seem to remember that the > article also says the message comes out some times, and not other times, but > that you should just forget it. > > The particular SELECT statement I'm getting the message on is the second > query in my script. The other query is to the same db; in fact, it uses the > exact same $db connection object. > > Any ideas on getting PHP to ignore this info message? > > Thanks again. > Michael > > -----Original Message----- > From: Adam Voigt [mailto:adam@kotisprop.com] > Sent: Thursday, February 19, 2004 12:13 PM > To: Michael Flanagan > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] MS SQL 'Changed database context' error > > > This may not be the case, but I've seen this before when the PHP library > didn't know how to express MS SQL's error, so it simply returns the last > message sent which was the informational context change. If it is infact > an error, you should be able to plug the query directly into Enterprise > Manager to see MS SQL's take on the problem, so to speak. =) > > But again, this is all just in my past experience's, yours may differ > greatly. > > > > On Thu, 2004-02-19 at 14:08, Michael Flanagan wrote: > > I'm getting the error "Changed database context" from MS SQL. I see > > where this is supposedly just an informational message. I've tried > > setting > > > > mssql.min_error_severity = 11 > > mssql.min_message_severity = 11 > > > > but to no avail. What am I missing? I don't mind the message so much, > > but php treats this as an error, and doesn't execute my query. > > > > I'm running php 4.3.3 for Windows; the SQL Server and web server are on > the > > same machine. I'm using PEAR:DB for the database access. > > > > Thanks. > > > > Michael Flanagan > > voice: (1) 303-674-2691 > > fax: (1) 603-963-0704 (note '603' area code) > > mailto:mflanagan@MJFlanagan.com > -- > > Adam Voigt > adam@kotisprop.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt adam@kotisprop.com