Bennett Posted May 17, 2011 Share Posted May 17, 2011 Greetings, I have a problem when executing long sql querys, it gives me an error like this Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\consolidadora\tablas.php on line 9 I've tried to modify the timeout to -1 on both ini and via script, I've read that this problem has been around on new versions of apache and set_time_limit (30000) by the way I'm running: Windows 2003 server PHP Version 5.3.1 any ideas on how to overcome this issue? Please help I'm desperate, had this problem for a couple of days now and can't get around it Quote Link to comment https://forums.phpfreaks.com/topic/236650-long-query-fails-sql-server-2000/ Share on other sites More sharing options...
micmania1 Posted May 18, 2011 Share Posted May 18, 2011 Is it the mssql timeout limit you've changed in your php.ini? Also, have you restarted apache? Apache must be restarted for changes to take affect. Quote Link to comment https://forums.phpfreaks.com/topic/236650-long-query-fails-sql-server-2000/#findComment-1216921 Share on other sites More sharing options...
Bennett Posted May 18, 2011 Author Share Posted May 18, 2011 Yes I've changed the mssql timeout on the ini, and restarted the apache, I checked the phpinfo and it all seems good, but nothing helps, and when I run the same script in sql analyzer it works fine Quote Link to comment https://forums.phpfreaks.com/topic/236650-long-query-fails-sql-server-2000/#findComment-1217008 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.