Mike,
Thank you Mike, that looks like exactly what I need.
Regards,
Jeff
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Mike Pavlak
Sent: Tuesday, January 08, 2013 5:51 PM
To: Jeffrey Day; Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] IBM i running PHP talking with Oracle
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.
--
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.
This message has been scanned for viruses by MailControl - www.mailcontrol.com
Click
https://www.mailcontrol.com/sr/BzuZB3LPrT3GX2PQPOmvUuT+IDOo3OtHy6Ux0kFGLeYWfkhInes!Sty4qy455tBpiiZzsaVbARasCq9I+zBdpQ== to report this email as spam
midrange.com
