Re: Microsoft IIS - Fatal error: Call to undefined function db2_connect()

Hi Jason, I'm betting you used the PHP Windows Installer. Add the following environment variable: PHPRC and set the value to the path to your PHP installation ( in your case it appears to be F:\PHP\ ). We used to set it as a part of the installer, but then stopped doing that for 5.2.5. We'll be re-enabling from now on. John On Jan 3, 2008 3:35 PM, McCallister, Jason <Jason.McCallister@bcbsfl.com> wrote: > *** I think PHP may be using the wrong PHP.INI file. > > phpinfo() says this: > > Configuration File (php.ini) Path C:\WINNT > Loaded Configuration File (none) > > > *** However, when I run php -i, it says this: > > Configuration File (php.ini) Path => C:\WINNT > Loaded Configuration File => F:\PHP\php.ini > > > *** How do I change the pointer to use the correct PHP.INI file? It must > be something in IIS, since the command line can see it? > > > > > > > ________________________________ > > From: Tom Hearn [mailto:tomh@nsoftware.com] > Sent: Thursday, January 03, 2008 3:25 PM > To: McCallister, Jason > Cc: php-windows@lists.php.net > Subject: RE: [PHP-WIN] Microsoft IIS - Fatal error: Call to undefined > function db2_connect() > > > > > Jason, > > If you do not see it in phpinfo then it is not loaded. > > > > Are you positive that your php extension directory is properly set > in php.ini? > > A good way to check this is when you actually call phpinfo() there will > be an entry telling you the path of php.ini it is actually using. > Verify that the file you are editing with extension= is actually in the > path that phpinfo is showing. > > > > Are you sure that php_ibm_db2.dll is the proper filename > (extensions are generally php_nomoreunderlinesinfilename.dll), but I'm > not sure about DB2? > > > > It seems to me that you may be having something like: > > > > [PHP_IBM_DB2] > > extension=filename.dll > > > > You should add extension=php_ibm_db2.dll (granted that is the > correct filename) directly below the rest of the ini file's extensions. > There is a specific section towards the middle of your php.ini file that > there is a whole list of other extensions to be loaded. Add it to the > last line under these entries if it is not already. > > > > > > Tom Hearn > > Software Engineer > > /n Software > > > > We are releasing IPWorks! for PHP Soon! Ask me for more information! > > > > ----- Original Message ----- > > >*** I don't see it with phpinfo() > > > > > >*** I have this in PHP.INI ([PHP_IBM_DB2] extension=php_ibm_db2.dll). > > > > > >*** What else is need to load the DB2 extension? I have also rebooted. > > > > > > > >*** These are the only entries that I see in PHP.INI with the word DB2. > > > > > > >CLASSPATH > >.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\d > b > >2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\ > I > >BM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar > > > >DB2INSTANCE DB2 > > > >DB2TEMPDIR C:\PROGRA~1\IBM\SQLLIB\ > > > >_ENV["CLASSPATH"] > >.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\d > b > >2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\ > I > >BM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar > > > >_ENV["DB2INSTANCE"] DB2 > > > >_ENV["DB2TEMPDIR"] C:\PROGRA~1\IBM\SQLLIB\ > > > > > > > >-----Original Message----- > >From: Lester Caine [mailto:lester@lsces.co.uk] > >Sent: Thursday, January 03, 2008 12:47 PM > >To: php-windows@lists.php.net > >Subject: Re: [PHP-WIN] Microsoft IIS - Fatal error: Call to undefined > >function db2_connect() > > > >McCallister, Jason wrote: > >> I have this line in my php.ini file. > >> > >> [PHP_IBM_DB2] > >> extension=php_ibm_db2.dll > >> > >> Also, if I run php -m, I can see ibm_db2 > >> > >> > >> > >> -----Original Message----- > >> From: Lester Caine [mailto:lester@lsces.co.uk] > >> Sent: Thursday, January 03, 2008 12:22 PM > >> To: php-windows@lists.php.net > >> Subject: Re: [PHP-WIN] Microsoft IIS - Fatal error: Call to undefined > > >> function db2_connect() > >> > >> McCallister, Jason wrote: > >>>> *** When I run a PHP script that uses db2_connect, I get this error > > >>>> message: > >>>> > >>>> Fatal error: Call to undefined function db2_connect() in > >>>> F:\Inetpub\wwwroot\jason2.php on line 5 > >> > >> You need to load the ibm_db2 package. > >> Check out phpinfo() if you think that it should be loaded. > > > >I'd still be looking for the results from phpinfo() to show that the > >module is actually running and what settings it has defaulted to. I > >believe that 'php -m' only shows that a module is included, that that > it > >actually started? > > > >-- > >Lester Caine - G8HFL > >----------------------------- > >Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact > >L.S.Caine Electronic Services - http://home.lsces.co.uk > >MEDW - > >http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/ > >Firebird - http://www.firebirdsql.org/index.php > > > >-- > >PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: > >http://www.php.net/unsub.php > > > > > > > > > > > > > >Blue Cross Blue Shield of Florida, Inc., and its subsidiary and > affiliate companies are not responsible for errors or omissions in this > e-mail message. Any personal comments made in this e-mail do not reflect > the views of Blue Cross Blue Shield of Florida, Inc. The information > contained in this document may be confidential and intended solely for > the use of the individual or entity to whom it is addressed. This > document may contain material that is privileged or protected from > disclosure under applicable law. If you are not the intended recipient > or the individual responsible for delivering to the intended recipient, > please (1) be advised that any use, dissemination, forwarding, or > copying of this document IS STRICTLY PROHIBITED; and (2) notify sender > immediately by telephone and destroy the document. THANK YOU. > > > >-- > >PHP Windows Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not > responsible for errors or omissions in this e-mail message. Any personal comments made in this > e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. The information > contained in this document may be confidential and intended solely for the use of the individual or > entity to whom it is addressed. This document may contain material that is privileged or protected > from disclosure under applicable law. If you are not the intended recipient or the individual > responsible for delivering to the intended recipient, please (1) be advised that any use, > dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender > immediately by telephone and destroy the document. THANK YOU. > -- John Mertic jmertic@gmail.com http://jmertic.wordpress.com "Explaining a joke is like dissecting a frog: you understand it better, but the frog dies in the process." --Mark Twain