RE: MS SQL 'Changed database context' error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Frank, thanks!  My problem was that I was increasing the value.

I decreased the value to 4, and I still get the error/message.  Any idea
what value will work, without throwing away valuable messages?  There are
some messages I want to consider an error.  Any doc someplace that
describes the severity levels, and their interplay with MS SQL Server??

Thanks.
Michael

-----Original Message-----
From: Frank M. Kromann [mailto:frank@xxxxxxxxxxxx]
Sent: Thursday, February 19, 2004 5:07 PM
To: Michael Flanagan
Cc: php-db@xxxxxxxxxxxxx
Subject: RE:  MS SQL 'Changed database context' error


You are getting a message from the SQL Server.

If you increase the values of mssql.min_error_severity and
mssql.min_message_severity (default is 10) you will get more messages if
you descrease the value you will get less messages.

- Frank



> Adam,  Thanks for the suggestions.  I don't want to ignore all error
> handling.  Later, I might get an error that I really don't want php to
> swallow due to either of your suggestions.
> 
> Has anyone else run into this and solved it?
> 
> Any idea why the following lines in the php.ini file don't work?
> mssql.min_error_severity = 11
> mssql.min_message_severity = 11
> 
> Michael
> 
> -----Original Message-----
> From: Adam Voigt [mailto:adam@xxxxxxxxxxxxx]
> Sent: Thursday, February 19, 2004 12:44 PM
> To: Michael Flanagan
> Cc: php-db@xxxxxxxxxxxxx
> Subject: RE:  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@xxxxxxxxxxxxx]
> > Sent: Thursday, February 19, 2004 12:13 PM
> > To: Michael Flanagan
> > Cc: php-db@xxxxxxxxxxxxx
> > Subject: Re:  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@xxxxxxxxxxxxxx
> > --
> >
> > Adam Voigt
> > adam@xxxxxxxxxxxxx
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> --
> 
> Adam Voigt
> adam@xxxxxxxxxxxxx
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux