develooper Front page | perl.beginners | Postings from January 2002

Connect several server and database

From:
Alexis VAILLANT
Date:
January 15, 2002 01:08
Subject:
Connect several server and database
Message ID:
D98D901CD857D411BC04009027DE2AEE034298AF@bdcsrv.ivry.alapage.com
Hi,
 
I have to execute a select order on two databases, which are on 2 différents
server.
 
Ex: 
 
DSN1 = DBI:mysql:DB1:SERVER1
DSN2 = DBI:mysql:DB2:SERVER2
 
and the select order :
 
SELECT TABLE1.DATA1, TABLE2.DATA2 FROM DB1.TABLE1, DB2.TABLE2 WHERE
TABLE1.ARG1=TABLE2.ARG2
 
Who can do that ?
 
Thanks



nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About