Re: Re: I retreated to 5.2.6 where everything worked for months...HELP!
Fred Silsbee <[email protected]>
| Newsgroups | gmane.comp.php.windows |
|---|---|
| Message-ID | <[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], [email protected] > Date: Thursday, September 3, 2009, 4:20 PM > > > --- 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! > > going back to 5.2.10...nothing working cgi 1.5 back in sqlserver driver installed -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php