Hi,
> -----Original Message-----
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 1:05 PM
> To: 'Andrew Hazen'; [EMAIL PROTECTED]
> Subject: RE: mySQL & PervasiveSQL
>
>
> [snip]
> Now here's a bit of an oddball question:
>
> I am building a php/mysql web app that will be linking with
> an accounting system in PervasiveSQL. Right now the various
> pieces of the web app are built in mySQL.
>
> Is there a way to do JOINS between tables in the two
> different databases? [/snip]
No. You can't at present.
>
> The problem that you will run into is connecting to both
> databases. Normally in PHP you use something like the
> following to connect to a single database;
>
> $dbconnect = mysql_pconnect("127.0.0.1", "user", "password");
> mysql_select_db("mydatabase", $dbconnect);
>
> Using the PHP native connections to MySQL. Assuming
> PervasiveSQL has an ODBC connection available it can be done.
>
> I have seen it done, here are some examples with 2 MySQL databases;
All these represent the query manipulatation in individual
database either by establishing each connection to a database
or by switching between the databases(catalogs).
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
