× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.