nyonline Posted July 6, 2008 Share Posted July 6, 2008 Hello All, We recently have upgraded our system with following configs : Windows Server 2003 X64 PHP.5.2 X32 Apache 2.2 X32 MSSQL 2005 X32 Currently our application is being used by 600+ employees. Everything was working fine for first few days but later we started facing the connection issues. The connection to the MSSQL server is lost and we start these getting Error messages. Invalid object name 'tablename'. Once we restart our Apache service it works fine for some time and then it starts throwing same errors. i have increased the timeout limit but still no use. Please let me know if anyone of you had faced same error or if you can suggest me a solution for the same. Thanks, Nishchint Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/ Share on other sites More sharing options...
dylanrolfey Posted July 7, 2008 Share Posted July 7, 2008 found this article, its a bit old so should have resolved by now, but maybe helpful. they suggest to loop the connect script until it connects :-\ http://bugs.php.net/bug.php?id=29074 hope it helps. i am going to try it out tomorrow at work. Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-583330 Share on other sites More sharing options...
dylanrolfey Posted July 7, 2008 Share Posted July 7, 2008 hey mate, found another bug report similar to the one above. http://bugs.php.net/bug.php?id=19541&edit=3 it says at the bottom The Microsoft Library (dblib) used for the mssql extension is not thread safe. To avoid problems with this extension you should use CGI or FastCGI. Maybe using FastCGI is the answer. I am going to try it out and let you know, but I only have a production environment at the moment and no testing ground so it might take me a while... let me know if it is of any help http://phplens.com/phpeverywhere/fastcgi-php Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-584054 Share on other sites More sharing options...
nyonline Posted July 8, 2008 Author Share Posted July 8, 2008 Hey thanks for the reply buddy.. In my opinion these bugs should not be the mail reason as we were using the same system with 32 bit server and sql Server 2000. We never had this problem before.. this started once we moved to 64 bit server and Sql Server 2005. Do u have any idea on connection pooling in apache and PHP? Do u think it would help if we have a static port on sql server 2005? Thanks again, NY Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-584303 Share on other sites More sharing options...
dylanrolfey Posted July 9, 2008 Share Posted July 9, 2008 yeah mate really not sure, i am not that experienced as a sys admin to do any of these things, i just stab around in the dark till it works lol. i will let you know how i go, we are setting it up this weekend, i will let you know of the results Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-585023 Share on other sites More sharing options...
sachinkumaram Posted July 11, 2008 Share Posted July 11, 2008 yeah mate really not sure, i am not that experienced as a sys admin to do any of these things, i just stab around in the dark till it works lol. i will let you know how i go, we are setting it up this weekend, i will let you know of the results bvvb hhhhhhhhhhh111111111111111111 sachin1 Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-587282 Share on other sites More sharing options...
sachinkumaram Posted July 11, 2008 Share Posted July 11, 2008 yeah mate really not sure, i am not that experienced as a sys admin to do any of these things, i just stab around in the dark till it works lol. i will let you know how i go, we are setting it up this weekend, i will let you know of the results bvvb ookk sachin12 Quote Link to comment https://forums.phpfreaks.com/topic/113431-connection-issues-mssql-2005/#findComment-587287 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.