 |  |  |  |  |  |  |  |
Accessing Other databases other than MYSQL
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Sorry for how stupid this question may sound but I am in the process of linking two different warehouses together that use different databases.
I need to run a query from one that is a remote webserver as well running PHP with a MYSQL database. This query will be done on a Centura (Gupta) database. The results will then need to be assimilated back into the MYSQL database.
Currently I am able to access the Centura database using software such as MSACCESS and can do so using an ssh connection that port forwards appropriately since it is behind a hefty firewall.
So this may sound idiotic but I need to find the right kind of software or extension to query from an apache server to the application server that is running Centura on an XP platform. Can it even be done?
I can query and such from a laptop but am wondering which software or process I should ask to have installed on our managed webserver to automate these requests
Bridge_city
I need to run a query from one that is a remote webserver as well running PHP with a MYSQL database. This query will be done on a Centura (Gupta) database. The results will then need to be assimilated back into the MYSQL database.
Currently I am able to access the Centura database using software such as MSACCESS and can do so using an ssh connection that port forwards appropriately since it is behind a hefty firewall.
So this may sound idiotic but I need to find the right kind of software or extension to query from an apache server to the application server that is running Centura on an XP platform. Can it even be done?
I can query and such from a laptop but am wondering which software or process I should ask to have installed on our managed webserver to automate these requests
Bridge_city
I suggest using ODBC connection for the Centura database. More on ODBC connection via PHP at
http://www.php.net/manual/en/book.uodbc.php
http://www.php.net/manual/en/book.uodbc.php
|
Similar Threads
- MS Access vs. MySQL (MS Access and FileMaker Pro)
- Connecting to MS Access with PHP (PHP)
- I am New In MySQL. Problem With MySQL Database Plz Help. (MySQL)
- Web Mechanic (Post your Resume)
- HOWTO: Share an SQL Connection between multiple forms within the same project (C#)
- Pro*C to Mysql C API (C++)
Other Threads in the PHP Forum
- Previous Thread: Can't access array in a class
- Next Thread: Image button
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array back beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email error file files filter folder form forms function functions gc_maxlifetime google host href htaccess html image include insert integration ip java javascript joomla limit link login loop mail memmory memory menu mlm mod_rewrite multiple mysql navigation oop parse parsing paypal pdf php problem query radio random recursion regex remote script search server sessions sms snippet soap source space sql structure syntax system table thesishelp tutorial update upload url validation validator variable video web xml youtube
