Re: Oracle to MySQL

I'm recalling this from memory, and I may not be 100% right, but it should put you on the right path. You will need to install the Oracle client libraries on the box with php (you can find these on the Oracle discs used to install the actual database). However, if I remember correctly, the Oracle discs will be for a specific OS, so if the db isn't on OS X, the client libraries for OS X won't be on there. If you can find the libraries for OS X, and get them installed, you will need to recompile php with Oracle support...."--with-oci8", or the other option (I can't remember what it is ( "--with-oracle"?, and this depends on the version of the Oracle DB you have). My memory of how to do this gets really fuzzy now. I remeber having to set up enviroment variables like ORA_HOME, and creating a file ("sid"?) with the connection string. It's not that it's real hard to do this, just that I have very little Oracle experience, and I was given this as a task about 18 months ago when our sysadmin quit. There's quite a few steps involved in this, and I'm sure that since you're doing this on OS X, there is going to be alot less help out there for you. Okay, I babbled, and don't think I really helped. Maybe these URL's will help... http://www.enderunix.org/documents/eng/php_oracle_en.html http://www.phpbuilder.com/columns/yenigul20020122.php3? Chris Cook wrote:

Hi all, I am working on PHP project with a MySQL backend. However, we would like update the MySQL database periodically with an Oracle database not on our server. What should I do to interface with Oracle? Do I need to install anything on our server (OS X Server running Apache)? Thanks for any help, Chris _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

-- By-Tor.com It's all about the Rush http://www.by-tor.com