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] [email protected] 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] [email protected] 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
