Bug #47580 [Com]: MSSQL: "Changed database context to" when connecting
Edit report at http://bugs.php.net/bug.php?id=47580&edit=1
ID: 47580
Comment by: bguaitanele at gmail dot com
Reported by: maxcamo at gmail dot com
Summary: MSSQL: "Changed database context to" when connecting
Status: Feedback
Type: Bug
Package: MSSQL related
Operating System: Win2003
PHP Version: 5.2CVS-2009-03-05 (snap)
Block user comment: N
Private report: N
New Comment:
I had this problem using php 5.2.6 and php 5.3. This happen with me
because the mssql timeout in php configuration.
this problem has 2 solutions:
The right solution: Refactory your query because your query is taking
too long time to respond to php. Case your query is fast, the problem
can be the database. In my case was an alter index running and 2 jobs.
The fast solution: increase the variable mssql.timeout in php.ini. I
increased to 300s and my error stop. But, this is not recommended,
because the connections in your application server will increase, More
people will be hang the response of the server.
Weel, hope this help
Previous Comments:
------------------------------------------------------------------------
[2011-02-05 21:20:40] pajoye@php.net
If you can try it on linux/unix with 5.3, please try it. If not I would
suggest to
use sqlsrv (http://sqlsrvphp.codeplex.com/) instead on Windows (and php
5.3).
------------------------------------------------------------------------
[2011-02-05 20:29:14] nkrsaxena at gmail dot com
I am facing this problem, making me nuts :-X
it shows mssql connection connected
mssql selectdb fine
but while running query says "Changed database context to" and script
terminated
the same is working fine
1. On MSSQL ternimal
2. php5.1.6
i tried different RPMS and manual installation with all dependencies but
still
no luck, even on Clean servers RHEL5
Please help...
------------------------------------------------------------------------
[2009-06-13 13:16:11] maxcamo at gmail dot com
I've tried but i get the same problem
Can be related to mssql time_wait tcp/ip?
Thx
Massimo
------------------------------------------------------------------------
[2009-06-02 01:00:01] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2009-05-25 19:46:59] kalle@php.net
Have you tried to change the severity with mssql_min_message_severity?
Error 5701 (Changed database context to) is at severity 10.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=47580
--
Edit this bug report at http://bugs.php.net/bug.php?id=47580&edit=1
Thread (10 messages)