dayjob Posted February 9, 2009 Share Posted February 9, 2009 I need to be able to read only query and Oracle Database that is remote (very infrequently) and read write query's to MySql that will reside on the same server as the php scripts. Is this possible? Quote Link to comment https://forums.phpfreaks.com/topic/144511-can-php-query-both-oracle-remotly-and-mysql-locally/ Share on other sites More sharing options...
.josh Posted February 9, 2009 Share Posted February 9, 2009 If you have the proper access and the remote oracle db is setup to allow remote conditions, then yes, you can do that. Quote Link to comment https://forums.phpfreaks.com/topic/144511-can-php-query-both-oracle-remotly-and-mysql-locally/#findComment-758319 Share on other sites More sharing options...
dayjob Posted February 9, 2009 Author Share Posted February 9, 2009 I have all the rights to the remote Oracle DB but the reason i ask this question is because it seems you have to recompile php for oracle and this breaks its ability to connect to MySql. So how would this be accomplished? Quote Link to comment https://forums.phpfreaks.com/topic/144511-can-php-query-both-oracle-remotly-and-mysql-locally/#findComment-758324 Share on other sites More sharing options...
premiso Posted February 9, 2009 Share Posted February 9, 2009 because it seems you have to recompile php for oracle and this breaks its ability to connect to MySql. It should not break the ability to connect to mysql, it should just add on to that feature. Are you removing the mysql portion when you recompile it? EDIT: Thinking about it, does oracle use the same port as mysql? If so, try changing your local mysql port to something different and see if that works. Quote Link to comment https://forums.phpfreaks.com/topic/144511-can-php-query-both-oracle-remotly-and-mysql-locally/#findComment-758329 Share on other sites More sharing options...
dayjob Posted February 9, 2009 Author Share Posted February 9, 2009 Different port. 3306 is Mysql and 1521 is the Oracle one.. Just so everyone knows.. i did not try the recompile of PHP for Oracle yet, it just seemed that it would break MySql. I guess i will go though the long recompile process and prey that i dont mess it up and then see for myself if it breaks.. then i will have to reinstall everything again if it does. Quote Link to comment https://forums.phpfreaks.com/topic/144511-can-php-query-both-oracle-remotly-and-mysql-locally/#findComment-758347 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.