Hi All, The upsides are you wil lbe using a database interface with full support for all Microsofts new features like nText, nChar etc.
The downsides: 1) A performence penalty, as OLEDB (used by ADODB) adds some overhead on featching data. I think most of this can be eliminated by only selecting the data you realy need in your application. 2) Your code is no longer portable to *nix's. ADODB and COM support is a Win32 thing only. - Frank > Does anyone know what the performance difference are for this method? What are the >downsides for this method. > > Thanks, > > -Flint > > -----Original Message----- > From: David Redmond [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 8:31 PM > To: 'bmw'; [EMAIL PROTECTED] > Subject: RE: [PHP-WIN] Re: PHP/IIS5/MSSQL shows CGI Header Error > > > Hi All, thanks for the feedback. > > The work around that we came up with was to use COM support and use the > ADODB.Connection object. Fortunately, the code changes were pretty small > since all DB connections are handled in one function. > > The pages have now run flawlessly for just over a day now which is a great > sign. > > Cheers > > -----Original Message----- > From: bmw [mailto:[EMAIL PROTECTED]] > Sent: Friday, 27 September 2002 10:39 PM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] Re: PHP/IIS5/MSSQL shows CGI Header Error > > > I had similar problems with close to the same configuration and changed > strategies completely by having the IIS server handle the header output. > This was done by making the IIS server use the php DLL instead of the .exe > as a CGI. My php files work fine now. It took some digging, but there is an > installation/configuration explanation in the MS IIS help files. > > > "Csa" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Check if you have installed PHP in a folder to which only the > administrator > > has access to. (Either PHP or the application that is calling PHP.) > > Regards, > > csaravind > > "David Redmond" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Hi All, > > > I am just wondering if anyone out there using PHP (4.2.3, bug also > affects > > > previous versions and the latest CVS snapshot) with IIS5 and receives > the > > > "CGI Header Error" in PHP scripts that use an MSSQL DB connection. > > > > > > This bug has been logged on the PHP buglist > > > (http://bugs.php.net/bug.php?id=9852) however the moderators have closed > > the > > > bug without it being investigated correctly. > > > > > > I will re-itereate the points that I have listed in the bug thread, they > > > are; > > > > > > - I'm running PHP 4.2.3, IIS5, Win2K (SP3 + Q326830, Q295688, Q147222). > > > - IIS is configured to use Host Header > > > - The error message that is returned via the script is; > > > > > > <head><title>Error in CGI Application</title></head> > > > <body><h1>CGI Error</h1>The specified CGI application misbehaved by not > > > returning a complete set of HTTP headers. The headers it did return > > > are:<p><p><pre></pre> > > > > > > - If the slot is run as a local administrator then the error does not > > occur, > > > similiary if you remove the IUSR access to the slot so that you are > > prompted > > > for authentication, and you use an administrator account. > > > - At the same time that the error is generated, a popup also occurs on > the > > > console with the details; > > > > > > TitleBar: php.exe - Application Error > > > > > > The application failed to initialize properly (0xc0000142). Click OK to > > > terminate the application > > > > > > - Any other PHP script which does not use an MSSQL connection works > > without > > > a problem, this also includes scripts which use MySQL. > > > > > > If anyone has encountered this problem before and found a resolution for > > it, > > > please post it here. As you may read from the bug thread, the developers > > of > > > PHP seemed to have passed this off as an IIS issue. > > > > > > Cheers > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
