ID: 44300 Comment by: genedorrell at aol dot com Reported By: alfa77 at gmail dot com Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 5.2.5 New Comment:
Badly need your help. How we remember, what we remember and why we remember form the most personal map of our individuality. Help me! Need information about: Canon ixus date stamp. I found only this - <a href="http://rifondazione.objectis.net/Members/DateStamp";>automatic date stamps</a>. Glassboro, getting three unwanted process advances, date stamp. Basis dealers can be issues organised from high, not, day areas or stamps, date stamp. Waiting for a reply :cool:, Nen from Tunisia. Previous Comments: ------------------------------------------------------------------------ [2010-01-19 08:41:40] t dot zander at tuneup dot de We're experiencing the same problem with Microsofts SQLSRV driver. So it might be it's not just a driver problem. ------------------------------------------------------------------------ [2009-12-03 17:37:29] dbuerer at leviton dot com I too have suffered this same problem for the last couple of years on all of the 5.x release of PHP. It works great for days then has problem for a few days then works great. 1-3 page reloads often solves the problem but not always. Unfortunatley support for this extension has been discontinued--I wonder if this is one of the reasons why? I would like to try using Microsofts SQLSRV driver but converting an entire website from mssql to sqlsrv is going to be a lot of work! ------------------------------------------------------------------------ [2009-02-13 19:26:45] b116d at mail dot ru Same problem here. Apache 2.2.10 Php 5.2.5 as module. OS win2003 sp1+all critical updates I even try upgrade to php 5.2.8, but it still appears. ------------------------------------------------------------------------ [2008-12-09 15:25:50] frosty dot z at freesbee dot fr Hi, same problem detected here (connection "rarely" successful with mssql_connect, with a MSSQL server under quite heavy load). Happens only with PHP on Windows, not on Linux (FreeDTS). But for some reason I needed to connect from PHP/Windows, so I have used the "ADO workaround", as previously suggested by alfa77. At first, I didn't understand very well that workaround, so here are some details : Do not use the ADOdb engine 'mssql' because it will still use mssql_connect(). Instead, use 'ado_mssql' which uses COM objects ; that makes all the difference. Here is a basic database functions lib : function db_open($db_host, $db_login, $db_pass, $db_name) { $db = NewADOConnection('ado_mssql'); $dsn="PROVIDER=MSDASQL;DRIVER={SQL Server};" . "SERVER=".$db_host.";DATABASE=".$db_name.";UID=".$db_login.";PWD=".$db_pass.";"; $db->Connect($dsn); return $db; } function db_query($db, $query) { return $db->Execute($query); } function db_fetch_assoc($res) { $obj = $res->FetchNextObj(); return get_object_vars($obj); } function db_close($db) { $db->Close(); } ------------------------------------------------------------------------ [2008-09-26 11:53:35] yusefhassan at gmail dot com Have you try editing php.ini mssql.max_procs? mssql.max_procs = -1 ------------------------------------------------------------------------ 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/44300 -- Edit this bug report at http://bugs.php.net/?id=44300&edit=1
