Re: Re: I retreated to 5.2.6 where everything worked for months...HELP!

--- On Thu, 9/3/09, Fred Silsbee <fredsilsbee@yahoo.com> wrote: > From: Fred Silsbee <fredsilsbee@yahoo.com> > Subject: Re: [PHP-WIN] Re: I retreated to 5.2.6 where everything worked for months...HELP! > To: RQuadling@googlemail.com > Date: Thursday, September 3, 2009, 3:44 PM > > --- On Thu, 9/3/09, Richard Quadling <rquadling@googlemail.com> > wrote: > > > From: Richard Quadling <rquadling@googlemail.com> > > Subject: Re: [PHP-WIN] Re: I retreated to 5.2.6 where > everything worked for  months...HELP! > > To: "Fred Silsbee" <fredsilsbee@yahoo.com> > > Date: Thursday, September 3, 2009, 8:34 AM > > 2009/9/3 Richard Quadling <rquadling@googlemail.com>: > > > 2009/9/3 Fred Silsbee <fredsilsbee@yahoo.com>: > > >> one remaining problem: > > >> > > >> Warning: mssql_connect() > [function.mssql-connect]: > > message: Login failed for user 'sa'. (severity 14) in > > C:\Inetpub\wwwroot\handle_log_book_mssql.php on line > 8 > > >> > > >> Warning: mssql_connect() > [function.mssql-connect]: > > Unable to connect to server: LANDON\SQLEXPRESSLMKIII > in > > C:\Inetpub\wwwroot\handle_log_book_mssql.php on line > 8 > > >> Something went wrong while connecting to > MSSQL > > >> > > >> Found this in php.net search...did not help! > > >> [13 Jan 9:19am UTC] bloodjazman at gmail dot > com > > >> Problem solved when change Default Language > = > > English in properties SQL > > >> Server Management Studio > > >> [14 Jan 7:46am UTC] bloodjazman at gmail dot > com > > >> recomended check php.ini > > >> > > >> mssql.allow_persistent = On > > >> mssql.compatability_mode = Off > > >> mssql.min_error_severity = 10 > > >> mssql.min_message_severity = 10 > > >> mssql.secure_connection = Off > > >> > > >> > > >> > > >> > > >> --- On Thu, 9/3/09, Fred Silsbee <fredsilsbee@yahoo.com> > > wrote: > > >> > > >>> From: Fred Silsbee <fredsilsbee@yahoo.com> > > >>> Subject: Re: I retreated to 5.2.6 where > > everything worked for months...HELP! > > >>> To: php-windows@lists.php.net > > >>> Date: Thursday, September 3, 2009, 4:13 > AM > > >>> > > >>> new_black_scholes.php is now working but > I > > found a bug in > > >>> IE8 > > >>> > > >>> I deleted all history but had to reboot > to > > completely clear > > >>> all files hidden in history temp files > > >>> > > >>> first I had to : (not sure if this did > it! > > >>> IIS: properties->home > > >>> > > directory->configuration   C:\PHP\php5isapi.dll > > >>> with GET,HOST,POST,DEBUG > > >>> > > >>> changed to: > > >>> IIS: properties->home > > >>> > > directory->configuration   C:\PHP\php5isapi.dll > > >>> with ALL > > >>> > > >>> --- On Wed, 9/2/09, Fred Silsbee <fredsilsbee@yahoo.com> > > >>> wrote: > > >>> > > >>> > From: Fred Silsbee <fredsilsbee@yahoo.com> > > >>> > Subject: I retreated to 5.2.6 where > > everything worked > > >>> for months...HELP! > > >>> > To: php-windows@lists..php.net > > >>> > Date: Wednesday, September 2, 2009, > 2:59 > > AM > > >>> > I tried 5.3 and found out it had no > > >>> > php_mssql. > > >>> > Then I retreated to 5.2.10. > > >>> > > > >>> > Trying to get back to where I had > > everything worked, > > >>> I > > >>> > downloaded 5.2.6: > > >>> > (1) I uninstalled cgi 1.5 > > >>> > (2) php.ini   has: > > >>> > > > >>> > extension_dir = "C:\PHP\ext" > > >>> > ; doc_root = "C:\inetpub\wwwroot" > > >>> > commented out > > >>> > doc_root = > > >>> > > > >>> > ALL extensions are uncommented > > >>> > > > >>> > I only need: > > >>> > extension=php_mssql.dll > > >>> > > > >>> > ; **You CAN safely turn this off for > IIS, > > in fact, > > >>> you > > >>> > MUST.** > > >>> >  cgi.force_redirect = 0 > > >>> > > > >>> > ntwdblib and php.ini moved to > > >>> > C:\WINDOWS > > >>> > C:\WINDOWS\system > > >>> > C:\WINDOWS\system32 > > >>> > > > >>> > IIS: properties->home > > >>> > > > directory->configuration   C:\PHP\php5isapi.dll > > >>> > with GET,HOST,POST,DEBUG > > >>> > > > >>> > I also tried: > > >>> > php5ts.dll > > >>> > phpnsapi.dll > > >>> > only php5isapi.dll seemed to work! > > >>> > added to XP Prof SP3 path: > > ;C:\PHP;C:\PHP\ext > > >>> > > > >>> > also created (just in case) PHPRC > > environment > > >>> variable > > >>> > (alongside path) > > >>> > containing C:\PHP;C:\PHP\ext > > >>> > > > >>> > I gave IUSR_LANDON all powers > > >>> > > > >>> > > > ________________________________________results > > >>> > this > > >>> > works:http://207.254.225.224:8080/phpinfo.php > > >>> > > > >>> > > > >>> > http://207.254.225.224:8080/new_black_scholes.php > > >>> > initial display works until I > select > > "DEMO"...then: > > >>> > > > >>> > The page cannot be displayed > > >>> > There is a problem with a program on > the > > page you are > > >>> > trying to reach, and the page cannot > be > > displayed. > > >>> > > > >>> > Here is new_black_scholes.php > > >>> > <?php > > >>> > define( "ITMAX",100); > > >>> > define( "EPS",3.0e-7); > > >>> >     // If the submit button has > been > > pressed > > >>> >     $StockPrice = $ExercisePrice > = > > >>> $RiskFreeRateInterest > > >>> > = > $InstantaneousVarianceRateStocksReturn > > = ""; > > >>> >     $TimetoExpirationOption = > > $ValueCallOption = > > >>> > $ValuePutOption = $DeltaCalls  = > > $DeltaPuts  = ""; > > >>> > > > >>> >     if (isset($_POST['reset'])) > > >>> >     { > > >>> > > > >>> >     $m_s = 100.; > > >>> >     $m_e = 100.; > > >>> >     $m_rf = .12; > > >>> >     $m_sigma = .1; > > >>> >     $m_time = 365.; > > >>> >     Black_Scholes_Main($m_s, > $m_e, > > $m_rf, > > >>> > $m_sigma,$m_time, $m_c, $m_p, > > $m_deltacalls, > > >>> $m_deltaputs); > > >>> >     $StockPrice = $m_s; > > >>> >     $ExercisePrice = $m_e; > > >>> >     $RiskFreeRateInterest = > $m_rf; > > >>> >     > > $InstantaneousVarianceRateStocksReturn = > > >>> $m_sigma; > > >>> >     $TimetoExpirationOption = > > $m_time; > > >>> >     $ValueCallOption = $m_c; > > >>> >     $ValuePutOption = $m_p; > > >>> >     $DeltaCalls = $m_deltacalls; > > >>> >     $DeltaPuts = $m_deltaputs; > > >>> >     } > > >>> >     elseif > (isset($_POST['submit'])) > > >>> >     { > > >>> >     $m_s = $_POST['StockPrice']; > > >>> >     $m_e = > $_POST['ExercisePrice']; > > >>> >     $m_rf = > > $_POST['RiskFreeRateInterest']; > > >>> >     $m_sigma = > > >>> > > > $_POST['InstantaneousVarianceRateStocksReturn']; > > >>> >     $m_time = > > $_POST['TimetoExpirationOption']; > > >>> >     Black_Scholes_Main($m_s, > $m_e, > > $m_rf, > > >>> > $m_sigma,$m_time, $m_c, $m_p, > > $m_deltacalls, > > >>> $m_deltaputs); > > >>> >     $StockPrice = $m_s; > > >>> >     $ExercisePrice = $m_e; > > >>> >     $RiskFreeRateInterest = > $m_rf; > > >>> >     > > $InstantaneousVarianceRateStocksReturn = > > >>> $m_sigma; > > >>> >     $TimetoExpirationOption = > > $m_time; > > >>> >     $ValueCallOption = $m_c; > > >>> >     $ValuePutOption = $m_p; > > >>> >     $DeltaCalls = $m_deltacalls; > > >>> >     $DeltaPuts = $m_deltaputs; > > >>> >     } > > >>> > function Black_Scholes_Main($m_s, > $m_e, > > $m_rf, > > >>> $m_sigma, > > >>> > $m_time, &$m_c, &$m_p, > > &$m_deltacalls, > > >>> > &$m_deltaputs) { > > >>> >         $m_c = > black_scholes($m_s,  > > $m_e, > > >>> $m_rf, > > >>> > $m_sigma,  $m_time/365., $nd1, > $nd2); > > >>> >         $m_p = $m_e / > pow(1.+$m_rf, > > $m_time/365.) > > >>> - > > >>> > $m_s + $m_c; > > >>> >         $m_deltacalls = $nd1; > > >>> >         $m_deltaputs = $nd1 - > 1.; > > >>> > } > > >>> > function black_scholes( $s,  $e,  > > $rf,  $sigma, > > >>> $time, > > >>> > &$nd1, &$nd2) { > > >>> >         $num = > > >>> > > log($s/$e)+$time*($rf+.5*$sigma*$sigma); > > >>> >         $d1 = > > $num/($sigma*sqrt($time)); > > >>> >         $d2 = $d1 - > > $sigma*sqrt($time); > > >>> >         $c = $s*myerf($d1) - $e > * > > myerf($d2) * > > >>> > exp(-$rf*$time); > > >>> >         $nd1 = myerf($d1); > > >>> >         $nd2 = myerf($d2); > > >>> > > > >>> >         return $c; > > >>> > } > > >>> > function gammln($xx) > > >>> > { > > >>> > > > >>> > > > $cof=array(76.18009173,-86.50532033,24.01409822, > > >>> > > > >>> > > > -1.231739516,0.120858003e-2,-0.536382e-5); > > >>> > > > >>> >         $x=$xx-1.0; > > >>> >         $tmp=$x+5.5; > > >>> >         $tmp -= > ($x+0.5)*log($tmp); > > >>> >         $ser=1.0; > > >>> >         for ($j=0;$j<=5;$j++) > { > > >>> >                 $x += 1.0; > > >>> >                 $ser += > > $cof[$j]/$x; > > >>> >         } > > >>> >         return > > -$tmp+log(2.50662827465*$ser); > > >>> > } > > >>> > > > >>> > function gser(  &$gamser,  > $a,  > > $x, &$gln) > > >>> > { > > >>> > > > >>> >         $gln=gammln($a); > > >>> >         if ($x <= 0.0) { > > >>> >                 if ($x < > 0.0) > > echo "x less > > >>> than > > >>> > 0 in routine GSER"; > > >>> >                 > $gamser=0.0; > > >>> >                 return; > > >>> >         } else { > > >>> >                 $ap=$a; > > >>> >                 > $sum=1.0/$a; > > >>> >         $del=$sum; > > >>> >                 for > > ($n=1;$n<=ITMAX;$n++) > > >>> { > > >>> >                         > $ap > > += 1.0; > > >>> >                         > $del > > *= $x/$ap; > > >>> >                         > $sum > > += $del; > > >>> >                         > if > > (abs($del) > > >>> < > > >>> > abs($sum)*EPS) { > > >>> > > > >>> > > $gamser=$sum*exp(-$x+$a*log($x)-($gln)); > > >>> > > > >>> return; > > >>> >                         > } > > >>> >                 } > > >>> >                 echo "a=$a > too > > large, ITMAX = > > >>> > $itmax too small in routine GSER > > >>> > "; > > >>> >                 return; > > >>> >         } > > >>> > } > > >>> > > > >>> > > > >>> > function gcf( > > &$gammcf,$a,$x,&$gln) > > >>> > { > > >>> >         $gold=0.0; > > >>> >         $fac=1.0; > > >>> >         $b1=1.0; > > >>> >         $b0=0.0; > > >>> >         $a0=1.0; > > >>> > > > >>> >         $gln=gammln($a); > > >>> >         $a1=$x; > > >>> >         for > ($n=1;$n<=ITMAX;$n++) > > { > > >>> >                 $an=(double) > $n; > > >>> >                 > $ana=$an-$a; > > >>> >                 > > $a0=($a1+$a0*$ana)*$fac; > > >>> >                 > > $b0=($b1+$b0*$ana)*$fac; > > >>> >                 > $anf=$an*$fac; > > >>> >                 > > $a1=$x*$a0+$anf*$a1; > > >>> >                 > > $b1=$x*$b0+$anf*$b1; > > >>> >                 if ($a1) { > > >>> >                         > > $fac=1.0/$a1; > > >>> >                         > > $g=$b1*$fac; > > >>> >                         > if > > >>> (abs(($g-$gold)/$g) > > >>> > < EPS) { > > >>> > > > >>> > > $gammcf=exp(-$x+$a*log($x)-($gln))*$g; > > >>> > > > >>> return; > > >>> >                         > } > > >>> >                         > > $gold=$g; > > >>> >                 } > > >>> >         } > > >>> >         echo "a too large, ITMAX > too > > small in > > >>> routine > > >>> > GCF > > >>> > "; > > >>> > } > > >>> > function gammp($a,$x) > > >>> > { > > >>> > > > >>> >         if ($x < 0.0 || $a > <= > > 0.0) { > > >>> >                 echo > "Invalid > > arguments in > > >>> routine > > >>> > GAMMP > > >>> > "; > > >>> >                 return 0.; > > >>> >         } > > >>> >         if ($x < ($a+1.0)) { > > >>> >                 > > gser($gamser,$a,$x,$gln); > > >>> >                 return > $gamser; > > >>> >         } else { > > >>> >                 > > gcf($gammcf,$a,$x,$gln); > > >>> >                 return > > 1.0-$gammcf; > > >>> >         } > > >>> > } > > >>> > > > >>> > function gammq($a,$x) > > >>> > { > > >>> > > > >>> >         if ($x < 0..0 || $a > <= > > 0.0) echo > > >>> "Invalid > > >>> > arguments in routine GAMMQ > > >>> > "; > > >>> >         if ($x < ($a+1.0)) { > > >>> >                 > > gser($gamser,$a,$x,$gln); > > >>> >                 return > > 1.0-$gamser; > > >>> >         } else { > > >>> >                 > > gcf($gammcf,$a,$x,$gln); > > >>> >                 return > $gammcf; > > >>> >         } > > >>> > } > > >>> > function erfc($x) > > >>> > { > > >>> > > > >>> >         return $x < 0.0 ? > > 1.0+gammp(0.5,$x*$x) > > >>> : > > >>> > gammq(0.5,$x*$x); > > >>> > } > > >>> > function erf($x) > > >>> > { > > >>> > > > >>> >         return $x < 0.0 ? > > -gammp(0.5,$x*$x) : > > >>> > gammp(0.5,$x*$x); > > >>> > } > > >>> > function myerf($argin) { > > >>> >        return > > .5*(1.+erf($argin/sqrt(2.0))); > > >>> > } > > >>> > > > >>> > ?> > > >>> > > > >>> > <form > action="new_black_scholes.php" > > >>> method="post"> > > >>> >     <p> > > >>> >         Black Scholes Option > Price > > Calculator: > > >>> > > > >>> >             temp website > under > > Redhat Fedora 9 > > >>> > Linux: > > >>> > > > >>> >             the first 5 > boxes > > require input(try > > >>> 100. > > >>> > 100. .12 .1 365.): > > >>> > > > >>> >     </p> > > >>> >     <p> > > >>> >         StockPrice (required): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> maxlength="40" > > >>> > name="StockPrice" > > >>> >         value="<?php echo > > $StockPrice; > > >>> > ?>" /> > > >>> >     </p> > > >>> >     <p> > > >>> >         ExercisePrice > (required): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> maxlength="40" > > >>> > name="ExercisePrice" > > >>> >         value="<?php echo > > $ExercisePrice; > > >>> ?>" > > >>> > /> > > >>> > </p> > > >>> >     <p> > > >>> >         Risk Free Rate of > > Interest(required): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> maxlength="40" > > >>> > name="RiskFreeRateInterest" > > >>> >         value="<?php echo > > >>> $RiskFreeRateInterest; > > >>> > ?>" /> > > >>> >     </p> > > >>> >     <p> > > >>> >         Instantaneous Variance > Rate > > of Stock's > > >>> Return > > >>> > (required): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> maxlength="40" > > >>> > > > name="InstantaneousVarianceRateStocksReturn" > > >>> >         value="<?php echo > > >>> > > $InstantaneousVarianceRateStocksReturn; > > ?>" /> > > >>> > </p> > > >>> >     <p> > > >>> >         Time to Expiration of > the > > Option(days) > > >>> > (required): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> maxlength="40" > > >>> > name="TimetoExpirationOption" > > >>> >         value="<?php echo > > >>> $TimetoExpirationOption; > > >>> > ?>" /> > > >>> > </p> > > >>> >     <p> > > >>> >         Values of the Call > Option : > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> > maxlength="40"  > name="ValueCallOption" > > >>> >             > VALUE="<?php > > echo > > >>> $ValueCallOption; > > >>> > ?>" /> > > >>> > </p> > > >>> > </p> > > >>> >     <p> > > >>> >         Values of the Put option > : > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> > maxlength="40"  > name="ValuePutOption" > > >>> >             > VALUE="<?php > > echo > > >>> $ValuePutOption; > > >>> > ?>" /> > > >>> > </p> > > >>> >     <p> > > >>> >         Delta(calls): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> > maxlength="40"  name="DeltaCalls" > > >>> >             > VALUE="<?php > > echo > > >>> $DeltaCalls; > > >>> > ?>" /> > > >>> > </p> > > >>> >     <p> > > >>> >         Delta(puts): > > >>> > > > >>> >         <input type="text" > > size="20" > > >>> > maxlength="40"  name="DeltaPuts" > > >>> >             VALUE="<?php > echo > > $DeltaPuts; > > >>> > ?>" /> > > >>> > </p> > > >>> >     <button type="submit" name > = > > "submit" > > >>> > value="Calculate!" > > >>> >     style="color:maroon > font:18pt > > Courier; > > >>> > font-weight:bold ">Calculate > > >>> >     </button> > > >>> >     <button type="submit" name > = > > "reset" > > >>> > value="Demo!" > > >>> >     style="color:red font:18pt > > Courier; > > >>> font-weight:bold > > >>> > ">Demo > > >>> >     </button> > > >>> > </form> > > >>> > > > >>> > > > >>> > > > _________________________________________________________results > > >>> > > > >>> > Please try the following: > > >>> > > > >>> > Open the 207.254.225.224:8080 home > page, > > and then look > > >>> for > > >>> > links to the information you want. > > >>> > Click the Refresh button, or try > again > > later. > > >>> > > > >>> > HTTP 403.1 Forbidden: Execute > Access > > Forbidden > > >>> > Internet Information Services > > >>> > > > >>> > > > >>> > > > -------------------------------------------------------------------------------- > > >>> > > > >>> > Technical Information (for support > > personnel) > > >>> > > > >>> > > > >>> > Background: > > >>> > You have attempted to execute a > CGI, > > ISAPI, or other > > >>> > executable program from a directory > that > > does not > > >>> allow > > >>> > programs to be executed. > > >>> > > > >>> > > > >>> > More information: > > >>> > Microsoft Support > > >>> > > > ____________________________________________ > > >>> > > > >>> > http://207.254.225.224:8080/handle_log_book_mssql.php > > >>> > yields: > > >>> > > > >>> > Warning: mssql_connect() > > [function.mssql-connect]: > > >>> Unable > > >>> > to connect to server: > > LANDON\SQLEXPRESSLMKIII in > > >>> > > > C:\Inetpub\wwwroot\handle_log_book_mssql.php on line > > >>> 8 > > >>> > (mssql_connect(...) > > >>> > Something went wrong while > connecting to > > MSSQL (my > > >>> > message) > > >>> > > > >>> > > > _______________________________________________________ > > >>> > all these worked before trying 5.3 > > >>> > > > >>> > > > >>> > > > >>> > > > >>> > > > >>> > > > >>> > > > >>> > > >>> > > >>> > > >>> > > >> > > >> > > >> > > >> > > >> -- > > >> PHP Windows Mailing List (http://www.php.net/) > > >> To unsubscribe, visit: http://www.php.net/unsub.php[–ýõ¨™ > > >> j°<§®'¤h > > >> > > >> > > > > > > The mssql extension is reliant on an unsupported > and > > ancient ntwdblib.dll. > > > > > > Your upgrade options are : > > > > > > ODBC / PDO_ODBC with the SQL Native Client > > > or > > > php_sqlsvr.dll - the new MS SQL Server extension > from > > Microsoft > > > > > > http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx > > > > > > > > > -- > > > ----- > > > Richard Quadling > > > "Standing on the shoulders of some very clever > > giants!" > > > EE : http://www.experts-exchange.com/M_248814.html > > > Zend Certified Engineer : > > > http://zend.com/zce.php?c=ZEND002498&r=213474731 > > > ZOPA : http://uk.zopa.com/member/RQuadling > > > > > > > Sorry. Old URL. > > > > New one is > > http://www.microsoft.com/downloads/details.aspx?FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9&displaylang=en > > > > > > -- > > ----- > > Richard Quadling > > "Standing on the shoulders of some very clever > giants!" > > EE : http://www.experts-exchange.com/M_248814.html > > Zend Certified Engineer : > > http://zend.com/zce.php?c=ZEND002498&r=213474731 > > ZOPA : http://uk.zopa.com/member/RQuadling > > > > BINGO! THANKS!!! > > Now I remember using this driver when I had 5.2.6 working > before. > Problem is, in the docs two files are mentioned but exist > nowhere on my PHP stuff. > php5ts.dll > php5.dll > > Maybe I need to go back up to 5.2.8 or 5.2.9 or 5.2.10! > > > > > > > > > > >