Hi Alf The ODBTP client works on all platforms. It includes a Win32 PHP extension (php_odbtp.dll). If you install it, you may find that it will produce better reslts than the packaged mssql extesnion under Windows. The reason is because the PHP win32 mssql extension was built with DB-Library, which Microsoft stop supporting after SQL Server 6.5. Try setting $ActualDate to an ISO date string: "YYYY-MM-DD HH:MM:SS" Note, use 24hr time values. I tested it with the mssql driver, and it works. -- bob > > > Thank you Bob. I decided to try it without the odbtp as I only found > source files at http://odbtp.sourceforge.net which looked like they > needed building on Linux and my problem does not include Linux. ie > Neither the client nor the server is a Linux/Unix machine. > > Long story short; your alteration to my code altered the results to the > following :- > > InParameter($stmt, $php_var='1126950445', $name='Today', $maxLen=4000, > $type=56); > OutParameter($stmt, $php_var='', $name='RETURN_VALUE', $maxLen=4000, > $type=47); > ------------------------------------------------------------------------ > (mssql): spGetActivePromotions || > ------------------------------------------------------------------------ > 8144: Procedure or function spGetActivePromotions has too many arguments > specified. > > and when I go to google to find out what "8144: Procedure or function" > really means I find Microsoft link, support.microsoft.com/?kbid=885712 > which tells me :- > > You receive this error message in the *Microsoft SQL-DMO (ODBC SQLState: > 42000)* dialog box. This problem occurs if there are more than 16 files > in the database that you try to attach, including the data files and the > log files in the database. > > Comments/suggestions please.BTW. The important part of your correction/suggestion was the PrepareSP rather than Prepare and the $ActualDate = time(); > > -- > > Regards, > Alf Stockton www.stockton.co.za > > Q: What is the difference between Texas and yogurt? > A: Yogurt has culture. > > My email disclaimer is available at www.stockton.co.za/disclaimer.html > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
