Hi, short before my weekend just a short example attached, where I use 2 connections to the same database in a sequence, to not mix what happens on each connection.
If you just alter the connect parms you may connect to different db's and
then submit some insert/update sql's
Hope this helps and have a nice weekend.
best regards
Manfred Beilfuss
(See attached file: grantread.pl)
James Edward Gray
II An: [EMAIL PROTECTED]
<[EMAIL PROTECTED] Kopie:
tions.net> Thema: Fwd: required help
10.10.2003 15:40
[ forwarded to list by James Gray ]
Begin forwarded message:
> From: vaishali <[EMAIL PROTECTED]>
> Date: Fri Oct 10, 2003 5:06:21 AM US/Central
> To: James Edward Gray II <[EMAIL PROTECTED]>
> Subject: Re: required help
> Reply-To: [EMAIL PROTECTED]
>
> how to define multiple connect statements
>
> Actually I am having one database ie smsd and table sms_log in
> 10.100.208.254.
> I have created one database called smsd and table sms_log1 on
> 10.100.200.47 ie in another machine
>
> I want to insert data from sms_log ie 10.100.208.254 server to
> 10.100.200.47 table ie sms_log1.
>
> how to do this task using perl DBI
>
> fields from sms_log ie 10.100.208.254 are
> sender char(40)
> receiver char(40)
> sent datetime
>
> fields from sms_log1 ie 10.100.200.47 are
> sender char(40),
> receiver char(40),
> sent datetime,
> dept char(40),
> branch char(40)
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
grantread.pl
Description: Binary data
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
