RE: [PHP] If Using PHP CLI to Query Oracle8I DB, is Version Numbe r Critical?

> -----Original Message----- > From: Martin McCormick [mailto:martin@dc.cis.okstate.edu] > Sent: 10 March 2004 21:31 > To: php-general@lists.php.net > Subject: [PHP] If Using PHP CLI to Query Oracle8I DB, is > Version Number Critical? > > > We use PHP 4.3.4 (cli) to query a Microsoft SQL > database server with no problem. We are now going to attempt > the same sort of thing, only with a Pinnacle server running > an Oracle8I data base. > > The php installation is on a FreeBSD UNIX platform and > the Pinnacle server is on a Windows platform. > > Being very new to all this, my question is simply > whether or not this should work? I am concerned that php > comes with an Oracle7 client, but the data base I need to > query and write back to is Oracle8I which might, someday, > upgrade to a higher version. For an Oracle 8i database you want the OCI extension, not the Oracle extension. OCI should be the extension of choice for Oracle version 7 and later. > If I am using the PHP CLI to extract data from the > server with, of course, correct syntax, does the Oracle > version even matter? No, not as long as it's supported by the extension you use. OCI should be fine for Oracle 8i and subsequent versions -- there have certainly been users of 9i posting to this or the PHP-DB list. Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: m.ford@leedsmet.ac.uk Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211