Re: Multiple RDBMS in one request
| From: | CPT John W. Holmes | Date: | Wed, 14 Jan 2004 13:13:39 +0000 |
| Subject: | Re: Multiple RDBMS in one request | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-174540@lists.php.net to get a copy of this message | ||
From: "Geoff Caplan" <geoff@advantae.com>
> Is it possible to interact with multiple RDBMS during a single
> request? I seem to remember that with older versions at least, there
> was some problems with this, but can't find anything definitive in the
> archive or docs.
Yes, you can open up multiple connections to different database systems in a
single script. Each one is separate, though; you're not going to be doing
any "joins" between them or sharing data in any way unless you bring it into
PHP first, though.
But yes, you can open a connection to MySQL, do some SELECTs, open a
connection to MSSQL, do an INSERT, open Oracle, etc, etc...
---John Holmes...