Re: Re: I retreated to 5.2.6 where everything worked for months...HELP!
Richard Quadling <[email protected]>
| Newsgroups | gmane.comp.php.windows |
|---|---|
| Message-ID | <[email protected]> |
2009/9/3 Fred Silsbee <[email protected]>: > > > --- On Thu, 9/3/09, Fred Silsbee <[email protected]> wrote: > >> From: Fred Silsbee <[email protected]> >> Subject: Re: [PHP-WIN] Re: I retreated to 5.2.6 where everything worked for months...HELP! >> To: [email protected] >> Date: Thursday, September 3, 2009, 3:44 PM >> >> --- On Thu, 9/3/09, Richard Quadling <[email protected]> >> wrote: >> >> > From: Richard Quadling <[email protected]> >> > Subject: Re: [PHP-WIN] Re: I retreated to 5.2.6 where >> everything worked for months...HELP! >> > To: "Fred Silsbee" <[email protected]> >> > Date: Thursday, September 3, 2009, 8:34 AM >> > 2009/9/3 Richard Quadling <[email protected]>: >> > > 2009/9/3 Fred Silsbee <[email protected]>: >> > >> 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 <[email protected]> >> > wrote: >> > >> >> > >>> From: Fred Silsbee <[email protected]> >> > >>> Subject: Re: I retreated to 5.2.6 where >> > everything worked for months...HELP! >> > >>> To: [email protected] >> > >>> 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 <[email protected]> >> > >>> wrote: >> > >>> >> > >>> > From: Fred Silsbee <[email protected]> >> > >>> > Subject: I retreated to 5.2.6 where >> > everything worked >> > >>> for months...HELP! >> > >>> > To: [email protected] >> > >>> > 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 >> > >> >> > >> >> > > >> > > 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! >> >> >> >> >> >> >> >> >> >> >> > > > > Or even 5.3.0 -- ----- 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php