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

2004-03-11 Thread Ford, Mike [LSS]
 -Original Message-
 From: Martin McCormick [mailto:[EMAIL PROTECTED] 
 Sent: 10 March 2004 21:31
 To: [EMAIL PROTECTED]
 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: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730  Fax:  +44 113 283 3211

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



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

2004-03-11 Thread Martin McCormick
A thousand thanks.  This is all starting to make a bit of
sense.

Martin McCormick

Ford, Mike [LSS] writes:
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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php