RE: MS SQL 'Changed database context' error

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

 



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

-- 
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