Communication between Perl and VBSript for DataBase

am 09.05.2008 14:03:26 von mohammed.mustafa

------_=_NextPart_001_01C8B1CC.B025454B
Content-Type: text/plain;
charset="us-ascii"
content-transfer-encoding: quoted-printable

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. =0A=
=0A=
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. =0A=
=0A=
WARNING: Computer viruses can be transmitted via email. The recipient should=
check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email. =0A=
=0A=
www.wipro.com

------_=_NextPart_001_01C8B1CC.B025454B--

Re: Communication between Perl and VBSript for DataBase

am 09.05.2008 14:28:47 von John Scoles

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

mohammed.mustafa@wipro.com 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
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Communication between Perl and VBSript for DataBase

am 09.05.2008 15:57:42 von mohammed.mustafa

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:scoles@pythian.com]
Sent: Friday, May 09, 2008 5:59 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl@lists.mysql.com
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

mohammed.mustafa@wipro.com 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
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=3Dmohammed.mustafa@wipro.c om

Please do not print this email unless it is absolutely necessary. =0A=
=0A=
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. =0A=
=0A=
WARNING: Computer viruses can be transmitted via email. The recipient should=
check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email. =0A=
=0A=
www.wipro.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Communication between Perl and VBSript for DataBase

am 09.05.2008 16:30:51 von John Scoles

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

mohammed.mustafa@wipro.com 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 5:59 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> 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
>
>
>
> mohammed.mustafa@wipro.com 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
>>
>>
>>
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Communication between Perl and VBSript for DataBase

am 09.05.2008 16:37:53 von mohammed.mustafa

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 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:scoles@pythian.com]
Sent: Friday, May 09, 2008 8:01 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl@lists.mysql.com
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

mohammed.mustafa@wipro.com 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 5:59 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> 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
>
>
>
> mohammed.mustafa@wipro.com 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
>>
>>
>>
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=3Dmohammed.mustafa@wipro.c om

Please do not print this email unless it is absolutely necessary. =0A=
=0A=
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. =0A=
=0A=
WARNING: Computer viruses can be transmitted via email. The recipient should=
check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email. =0A=
=0A=
www.wipro.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Communication between Perl and VBSript for DataBase

am 09.05.2008 16:55:33 von John Scoles

mohammed.mustafa@wipro.com 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 8:01 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> 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
>
>
> mohammed.mustafa@wipro.com 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:scoles@pythian.com]
>> Sent: Friday, May 09, 2008 5:59 PM
>> To: Mohammed Mustafa (WT01 - Testing Services)
>> Cc: perl@lists.mysql.com
>> 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
>>
>>
>>
>> mohammed.mustafa@wipro.com 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
>>>
>>>
>>>
>>>
>>
>>
>
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Communication between Perl and VBSript for DataBase

am 09.05.2008 17:43:25 von mohammed.mustafa

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:scoles@pythian.com]
Sent: Friday, May 09, 2008 8:26 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl@lists.mysql.com
Subject: Re: Communication between Perl and VBSript for DataBase

mohammed.mustafa@wipro.com 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 8:01 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> 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
>
>
> mohammed.mustafa@wipro.com 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:scoles@pythian.com]
>> Sent: Friday, May 09, 2008 5:59 PM
>> To: Mohammed Mustafa (WT01 - Testing Services)
>> Cc: perl@lists.mysql.com
>> 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
>>
>>
>>
>> mohammed.mustafa@wipro.com 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. =0A=
=0A=
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. =0A=
=0A=
WARNING: Computer viruses can be transmitted via email. The recipient should=
check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email. =0A=
=0A=
www.wipro.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

RE: Communication between Perl and VBSript for DataBase

am 09.05.2008 17:46:48 von mohammed.mustafa

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: 'scoles@pythian.com'
Cc: perl@lists.mysql.com
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:scoles@pythian.com]
Sent: Friday, May 09, 2008 8:26 PM
To: Mohammed Mustafa (WT01 - Testing Services)
Cc: perl@lists.mysql.com
Subject: Re: Communication between Perl and VBSript for DataBase

mohammed.mustafa@wipro.com 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 8:01 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> 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
>
>
> mohammed.mustafa@wipro.com 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:scoles@pythian.com]
>> Sent: Friday, May 09, 2008 5:59 PM
>> To: Mohammed Mustafa (WT01 - Testing Services)
>> Cc: perl@lists.mysql.com
>> 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
>>
>>
>>
>> mohammed.mustafa@wipro.com 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. =0A=
=0A=
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. =0A=
=0A=
WARNING: Computer viruses can be transmitted via email. The recipient should=
check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email. =0A=
=0A=
www.wipro.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Communication between Perl and VBSript for DataBase

am 09.05.2008 17:57:17 von John Scoles

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

mohammed.mustafa@wipro.com 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: 'scoles@pythian.com'
> Cc: perl@lists.mysql.com
> 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:scoles@pythian.com]
> Sent: Friday, May 09, 2008 8:26 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@lists.mysql.com
> Subject: Re: Communication between Perl and VBSript for DataBase
>
>
>
> mohammed.mustafa@wipro.com 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:scoles@pythian.com]
>> Sent: Friday, May 09, 2008 8:01 PM
>> To: Mohammed Mustafa (WT01 - Testing Services)
>> Cc: perl@lists.mysql.com
>> 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
>>
>>
>> mohammed.mustafa@wipro.com 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:scoles@pythian.com]
>>> Sent: Friday, May 09, 2008 5:59 PM
>>> To: Mohammed Mustafa (WT01 - Testing Services)
>>> Cc: perl@lists.mysql.com
>>> 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
>>>
>>>
>>>
>>> mohammed.mustafa@wipro.com 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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Communication between Perl and VBSript for DataBase

am 12.05.2008 19:00:41 von el.dodgero

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 :
> 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
>
>
>
> mohammed.mustafa@wipro.com 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: 'scoles@pythian.com'
> > Cc: perl@lists.mysql.com
> > 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:scoles@pythian.com] Sent: Friday, May 09, 2008
> 8:26 PM
> > To: Mohammed Mustafa (WT01 - Testing Services)
> > Cc: perl@lists.mysql.com
> > Subject: Re: Communication between Perl and VBSript for DataBase
> >
> >
> >
> > mohammed.mustafa@wipro.com 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:scoles@pythian.com] Sent: Friday, May 09, 2008
> 8:01 PM
> > > To: Mohammed Mustafa (WT01 - Testing Services)
> > > Cc: perl@lists.mysql.com
> > > 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
> > >
> > >
> > > mohammed.mustafa@wipro.com 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:scoles@pythian.com] Sent: Friday, May 09,
> 2008 5:59 PM
> > > > To: Mohammed Mustafa (WT01 - Testing Services)
> > > > Cc: perl@lists.mysql.com
> > > > 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
> > > >
> > > >
> > > > mohammed.mustafa@wipro.com 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/perl?unsub=sean@aquest.com
>
>
>

--
Dodger

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org