Changed database context to 'database_name'

Hi,

i got this message executing an application that was working previously.

what’s the meaning of this message?

thanks.

Re: Changed database context to ‘database_name’

Can I get more detail? Is the subject the error message?

Does the app die with this error?
Has there been any changes to app or server since before the error?

I have seen errors where a variable was not recognized due to quotes in the code and the code tried to ‘assume’ a value.

Regards,
Scott.

Re: Changed database context to ‘database_name’

thanks for aswering Scott,

i read an article tha php has a bug caused by tables that has more than 32 columns, that’s not my case.

the app stop show that red window with the message: Changed database context to ‘my database name’
but this error just appear when my return coasts more time
exemple if my select executs in 10s, ok my app works
but if my select finishes in 3m apper this message of error and that changed the database context

do you think that it ould be rlated whit php/mssql settings in php.ini?

thanks again.

Re: Changed database context to ‘database_name’

I believe your error is more related to MSSQL than PHP. (Connection error).

There seems to be many related issue about this online. Some suggest another driver (sybase) that is better, or to simply ignore the error.

Please provide a full script that reproduces the problem. The log file
indicates that the mssql_select_db() failed. This could be caused by
insufficient access or a bad database name. If the database name
includes white space it should be included in [].

“Changed database context to ‘XXX’”. is not an error but a message. You
should only see this message if mssql.min_message_severity = 0.

mssql.min_message_severity can be specified in php.ini or at runtime
with the ini_set() command.

Regards,
Scott.

Re: Changed database context to ‘database_name’

This is a problem with both Sybase and Mssql: it is not really an error, but a very annoying warning.
To avoid it, use the following in your php.ini:

mssql.min_error_severity = 11
mssql.min_message_severity = 11
sybct.min_error_severity = 11
sybct.min_message_severity = 11