Jeff,
Have you tried using the OCI8 functions built into to Zend Server for IBM
i? According to php.net, these functions should support connectivity to
Oracle 11g. Give it a shot and let me know. These functions are part of
the Community Edition, as well as the full version of Zend Server.
http://php.net/manual/en/book.oci8.php
Regards,
Mike
Office Phone: (708)233-5880 Cell: (408)679-1011
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Jeffrey Day
Sent: Tuesday, January 08, 2013 4:20 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] IBM i running PHP talking with Oracle
Hello Everyone,
I'll start with I am fairly new to PHP. We are at i/OS v7.1, with Zend
PHP/ZendDBI installed.
I have been trying to find a way for a PHP script on an IBM I to talk with
an Oracle 11g database, and in my searching, I have found PDO_OCI. What
I'm looking for are opinions on PDO_OCI and help with how to get it
installed on the IBM i.
I have a few questions:
1.
http://php.net/manual/en/ref.pdo-oci.php says that PDO_OCI is
experimental, meaning it can change or be removed without prior notice.
In my Zend config, I see that there are a few databases setup to work with
PDO. Does it look like PDO_OCI will be kept around, or does it look like
it will be short-lived? Opinions?
2. How do I install PDO_OCI on the IBM i? Does anyone have a
document for that?
3. Can PHP use JDBC to get to Oracle? Does anyone have an example
they can send me?
4. Is there a better/easier way to transfer data between an Oracle
database to an IBM i? We have a need for both an on-the-fly method and a
batch transfer method, but at a minimum, we need an on-the-fly method.
Thank you in advance for your assistance and input!
Best Regards,
Jeff
If the reader of this email is not the intended recipient(s), please be
advised that any dissemination, distribution or copying of this
information is strictly prohibited. Johnson Matthey PLC has its main place
of business at 5th Floor, 25 Farringdon Street, London (020 7269 8400).
Johnson Matthey Public Limited Company
Registered Office: 5th Floor, 25 Farringdon Street, London EC4A 4AB
Registered in England No 33774
Whilst Johnson Matthey aims to keep its network free from viruses you
should note that we are unable to scan certain emails, particularly if any
part is encrypted or password-protected, and accordingly you are strongly
advised to check this email and any attachments for viruses. The company
shall NOT ACCEPT any liability with regard to computer viruses transferred
by way of email.
Please note that your communication may be monitored in accordance with
Johnson Matthey internal policy documentation.
This message has been scanned for viruses by MailControl -
www.mailcontrol.com
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
midrange.com
