Re: Communication between Perl and VBSript for DataBase

[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@stripped 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@stripped'
> Cc: perl@stripped
> 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@stripped] 
> Sent: Friday, May 09, 2008 8:26 PM
> To: Mohammed Mustafa (WT01 - Testing Services)
> Cc: perl@stripped
> Subject: Re: Communication between Perl and VBSript for DataBase
>
>
>
> mohammed.mustafa@stripped 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@stripped] 
>> Sent: Friday, May 09, 2008 8:01 PM
>> To: Mohammed Mustafa (WT01 - Testing Services)
>> Cc: perl@stripped
>> 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@stripped 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@stripped] 
>>> Sent: Friday, May 09, 2008 5:59 PM
>>> To: Mohammed Mustafa (WT01 - Testing Services)
>>> Cc: perl@stripped
>>> 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@stripped 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
>