ideasworking

Hello, I've exhausted everything I can think of and I still can't execute an mssql stored procedure with a datetime variable from PHP. Would someone look at my code and suggest a solution? I know the sp works and if I enter EXEC Reporting.dbo.CalculateDaily Totals '2007-10-31' the daily totals for for today are calculated. So I really don't see why my php code doesn't work. Any suggestions are welcome. Thanks, Lou $RecDate = date("Y-m-d",strtotime($_POST['RecalcDate'])); $db = mssql_connect("server","user","password") or die("Unable to connect to server"); $query = "EXEC Reporting.dbo.CalculateDailyTotals '$RecDate'"; $Result= mssql_query($query, $db); if ($Result == 1){ echo "Success"; } ELSE { echo "Failure"; }

Hello, Just wanted to let everyone know that upgrading to 5.2.1 didn't resolve the problem. Still looking for help. Thanks, Lou

Hello, Has anyone experienced problems with PHP losing it's connection to MSDE2000? I have a Win2003 server with PHP 5.2, MSDE2000, and IIS. Everything will be working fine. Then once in about ten times someone will navigate through the pages, or submit a form and that's when PHP stops communicating with MSDE. The web page shows a simpe error message "Unable to connect to server" which is directly from my script. At this point I have to go to the server, open the services manager, stop the World Wide Web Publishing Service, then start it. At that point the PHP pages load normally... for a while. I see nothing in the Events logs... I'm stumped as to what the problem is. This problem is slowly driving me insane. If someone could help identify the problem and solution I would greatly appreciate the help. Thanks, Lou

Hello, I would like to print a web page everyday at the same time each day. I tried to think of a batch file I could execute using Windows Task Scheduler but I haven't had much luck. Does anyone have a good suggestion? Thanks, Lou