Re: Communication between Perl and VBSript for DataBase

Just make the VB output be a file stream input to the Perl script,
which you parse from STDIN as needed. No reason for an intermediary
file that I can see.

The part I can't get over is why on earth you'd want to do this.

Really, your best bet is to schedule a meeting to reassess your
architecture plan.

-- 
Sean

2008/5/9 John Scoles <[email protected]>:
> You would just  write out the XML or whatever first then run the Perl
> Script. I know it can be done as two separate scripts by I wouldn't know how
> to do it there was a run command in VB years ago
>
>
>
>  [email protected] wrote:
>
> > This is required for us as in a single click of button, we need to
> > execute one (Perl) after the other (VBS) automatically... i.e. after I
> > execute VBS, perl should also be executed as an automatic sequence...
> >
> > Thanks
> >
> > -----Original Message-----
> > From: Mohammed Mustafa (WT01 - Testing Services) Sent: Friday, May 09,
> 2008 9:13 PM
> > To: '[email protected]'
> > Cc: [email protected]
> > Subject: RE: Communication between Perl and VBSript for DataBase
> >
> > It is my pleasure to see your great response, and it is an excellent
> > idea.
> > But I have doubt here.
> > I want Perl script to be executed depending on data what I receive from
> > VBScript. As per my knowledge XML is not having any intelligence, so how
> > can I execute the PERL here?
> >
> > If you guide me, that will be a great help.
> >
> >
> > -----Original Message-----
> > From: John Scoles [mailto:[email protected]] Sent: Friday, May 09, 2008
> 8:26 PM
> > To: Mohammed Mustafa (WT01 - Testing Services)
> > Cc: [email protected]
> > Subject: Re: Communication between Perl and VBSript for DataBase
> >
> >
> >
> > [email protected] wrote:
> >
> >
> > > Thanks John,
> > >
> > >    In my application I want the data from VBScript rather than data
> > > base,
> > > so rather directly connecting perl to MySQL data base. I want the data
> > > to be get from VB script, which I indicated in point 2. As In below
> > > query.
> > >
> > > I Hope that clarified your doubt.
> > >
> > > Pictorial view....
> > >
> > > Database <--- VBScript driver <-- Perl Script Driver.
> > >
> > >
> > So basically you want to call a VBScript from PERL and use it to load data
> into MySQL.
> >
> > Database ---> VBScript driver --> Perl Script Driver.
> >
> >
> > I do not think there is any perl mod out there that lets the two talk to
> >
> > each other directly?? You might try and search CPAN for it.
> >
> > You might want try XML like this
> >
> > Database ---> VBScript driver --> XML --> Perl Script Driver.
> >
> > Or you can use any other File structure for XML
> >
> >
> >
> > cheers
> >
> > John Scoles
> >
> >
> > >  So here I want the data from VBScript not the Database directly.
> > >
> > > If you need more clarification, plz let me know.
> > >
> > > Thanks,
> > > Mustafa
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: John Scoles [mailto:[email protected]] Sent: Friday, May 09, 2008
> 8:01 PM
> > > To: Mohammed Mustafa (WT01 - Testing Services)
> > > Cc: [email protected]
> > > Subject: Re: Communication between Perl and VBSript for DataBase
> > >
> > > In that case it is easy.
> > >
> > > Simply use PERL with DBI and DBD::ODBC or DBD::MySQL
> > >
> > > you can find all three on www.cpan.org
> > >
> > > To connect to the database.
> > >
> > > I do not think is is practical to get  PERL to try and run teh VB code
> > >
> > > What is VB concept?
> > >
> > > cheers
> > >
> > >
> > > [email protected] wrote:
> > >
> > >
> > > > Hi John,
> > > >
> > > > It is written in VB concept and it is a VB program which connects to
> > > >
> > > >
> > > the
> > >
> > >
> > > > MySQL with ODBC.
> > > >
> > > >  Hope I am clear here, if not please let me know, as I am new to
> > > > Database & VBScript, so I may not understand everything upto the
> > > >
> > > >
> > > point.
> > >
> > >
> > > > Thanks,
> > > > Mustafa
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: John Scoles [mailto:[email protected]] Sent: Friday, May 09,
> 2008 5:59 PM
> > > > To: Mohammed Mustafa (WT01 - Testing Services)
> > > > Cc: [email protected]
> > > > Subject: Re: Communication between Perl and VBSript for DataBase
> > > >
> > > > In which context is the VBScript  written, .NET, ASP, VB ??
> > > >
> > > > Anyway you are not giving us (me anyway) enough detail to give you
> > > >
> > > >
> > >
> > any
> >
> >
> > >
> > > >
> > > >
> > >
> > >
> > > > guidance.
> > > >
> > > > Is you VB code really a driver (direct calls to a DB API) or is it
> > > >
> > > >
> > > just
> > >
> > > > a VB program that connects to the MySQL DB with ODBC or alike?
> > > >
> > > >
> > > > cheers
> > > > John Scoles
> > > >
> > > >
> > > > [email protected] wrote:
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > >
> > > > >  We need your help for writing a tool driver with perl script,
> > > > >
> > > > >
> > > >
> > >
> > which
> >
> >
> > >
> > > >
> > > > > will be disclosed as below.
> > > > >
> > > > > 1)       We have a driver which is written in VB script , which
> > > > > communicates with Database (Mysql) and retrive the data.
> > > > >
> > > > > 2)       We are developing one more driver in perl, which has to
> > > > > communicate with the VBScript driver mentioned above.
> > > > >
> > > > > 3)       Perl driver will communicated with a target m/c like
> > > > > Linux/unix/Solaris and do some operations & return a value.
> > > > >
> > > > >
> > > > > My main query is
> > > > > 1) How can we communicate the data between perl script driver (
> > > > >
> > > > >
> > > >
> > >
> > Linux
> >
> >
> > >
> > > >
> > > > >
> > > > >
> > > > or
> > > >
> > > >
> > > > > Windows m/c ) to VBScript driver so that I can transact the data
> > > > >
> > > > >
> > > > between
> > > >
> > > >
> > > > > these two.
> > > > >
> > > > >
> > > > > Thanks for your kind help.
> > > > >
> > > > >
> > > > > Regards,
> > > > >
> > > > > Mustafa
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Please do not print this email unless it is absolutely necessary.
> > > > > The information contained in this electronic message and any
> > > > >
> > > > >
> > > > attachments to this message are intended for the exclusive use of the
> > > > addressee(s) and may contain proprietary, confidential or privileged
> > > > information. If you are not the intended recipient, you should not
> > > > disseminate, distribute or copy this e-mail. Please notify the sender
> > > > immediately and destroy all copies of this message and any
> > > >
> > > >
> > > attachments.
> > >
> > > >
> > > >
> > > > > WARNING: Computer viruses can be transmitted via email. The
> > > > >
> > > > >
> > > >
> > >
> > recipient
> >
> >
> > >
> > > >
> > > > >
> > > > >
> > > > should check this email and any attachments for the presence of
> > > >
> > > >
> > > viruses.
> > >
> > >
> > > > The company accepts no liability for any damage caused by any virus
> > > > transmitted by this email.
> > > >
> > > > > www.wipro.com
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> > Please do not print this email unless it is absolutely necessary.
> > The information contained in this electronic message and any attachments
> to this message are intended for the exclusive use of the addressee(s) and
> may contain proprietary, confidential or privileged information. If you are
> not the intended recipient, you should not disseminate, distribute or copy
> this e-mail. Please notify the sender immediately and destroy all copies of
> this message and any attachments.
> > WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
> > www.wipro.com
> >
> >
>
>  --
>  MySQL Perl Mailing List
>  For list archives: http://lists.mysql.com/perl
>  To unsubscribe:    http://lists.mysql.com/[email protected]
>
>
>



-- 
Dodger

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]