Date parsed: 9/26/2003 6:18:03 AM
Date: Fri, 26 Sep 2003 11:18:03 -0400
Thanks again Franz...
Found a copy of the VB6 Pro so as you suggested, we will stick with this...
John
"Franz Krainer" <franzk@netal.com> wrote in message
news:lAQAYq5gDHA.1924@is1.netal.com...
> John,
>
> I just verified that using VB.NET as development environment for custom
> extension objects works. But there are some steps to take care of, because
> of the CLR/COM-interop issues. The easiest way would be to stick with VB6,
> if available.
>
> Franz
>
>
> "John Smith" <apu000a@hotmail.com> wrote in message
> news:0RLLqb4gDHA.1924@is1.netal.com...
> > Franz,
> >
> > Is the sample code/Custom Evaluator feature compatible with VB .Net?
> > Apparently VB 6.0 is replaced by VB .Net. I have VB .Net but not VB 6.0
so
> I
> > am thinking of modifying your sample code using VB .Net and its new
> > syntax/functions/etc but before I do that, I want to make there are no
> > compatibility issues. When I open your VB 6.0 sample code in Visual
Studio
> > .Net, it upgrades it to the new VB .Net.
> >
> > Please let me know.
> >
> > Thanks,
> > John
> >
> > "Franz Krainer" <franzk@netal.com> wrote in message
> > news:iUiC10HgDHA.1924@is1.netal.com...
> > > Hi John,
> > >
> > > > I never compiled an ActiveX component before. Would you be able to
> > provide
> > > > some help in how to compile this code in VB5 after I have modify the
> > code?
> > > > Any more help in this would be appreciated.... Hopefully what I
> > described
> > > > above is all the work involved in making this work.
> > >
> > > the sample was written in VB6 and I don't know if the project files of
> the
> > > sample are compatible with VB5.
> > >
> > > I never used VB5 but in VB6 it's very simple to compile the project:
> Open
> > > it, make your changes and then select File->Make <ProjectName>" and
> choose
> > > the destination path for the DLL to create.
> > >
> > > Franz
> > >
> > >
> > >
> > >
> > > "John Smith" <mayabuttreek123@lycos.com> wrote in message
> > > news:wxGBquzfDHA.2640@is1.netal.com...
> > > > Hi Franz,
> > > >
> > > > After reading the sample VB code in the SDK, it looks like I don't
> have
> > to
> > > > edit "SL4NTCRCVB.vbp" and "SL4NTCRCVB.vbw" since I could use it as
is.
> > > >
> > > > As far as the "CustomRuleCondition.cls", there is not much editing
> > unless
> > > I
> > > > change the function name and/or return type to something else. But
if
> I
> > > keep
> > > > the function name and return type as is, I can use this sample
> > > > "CustomRuleCondition.cls" as is also.
> > > >
> > > > So the only real work is in the "HelperFunctions.bas" file which
> > contains
> > > > the algorithm for the function called in the
"CustomRuleCondition.cls"
> > > file.
> > > >
> > > > So I modify the function in "HelperFunctions.bas" to perform the
space
> > > > delimited parsing and rename the function name. The individual space
> > > > delimited value that is parsed would be returned in the function
> > parameter
> > > > variable and written to one of the sixteen custom columns in
> > > > "CustomRuleCondition.cls". In "CustomRuleCondition.cls", I would
> change
> > > the
> > > > function name to the name I specify in the "HelperFunctions.bas"
file.
> > > That
> > > > is it, I think...
> > > >
> > > > I never compiled an ActiveX component before. Would you be able to
> > provide
> > > > some help in how to compile this code in VB5 after I have modify the
> > code?
> > > > Any more help in this would be appreciated.... Hopefully what I
> > described
> > > > above is all the work involved in making this work.
> > > >
> > > > Thanks,
> > > > John
> > > >
> > > >
> > > > "John Smith" <apu000a@hotmail.com> wrote in message
> > > > news:$Pwun%23rfDHA.1924@is1.netal.com...
> > > > > Franz,
> > > > >
> > > > > Thanks for the responses. Right now we are either going with Run
> > Program
> > > > > (program would be Java applet using JDBC) OR the Custom Evaluator.
I
> > am
> > > > very
> > > > > rusty in my C++ and VB so I am asking one of the developers in my
> > > company
> > > > to
> > > > > help me. I need to speak with him on which approach he is
> comfortable
> > > with
> > > > > (he knows both java and C++ but java better).
> > > > > I guess I should take a look at the sample source and see if it is
> > > > > sufficiently complete for me or my developer to modify to meet our
> > needs
> > > > > without extensive work.
> > > > > If we decide to go with the custom evaluator and run into a
problem,
> > we
> > > > will
> > > > > definitely contact you for help...
> > > > >
> > > > > Thanks,
> > > > > John
> > > > >
> > > > > "Franz Krainer" <franzk@netal.com> wrote in message
> > > > > news:u7ON5pseDHA.3388@is1.netal.com...
> > > > > > > One thing I was thinking of was using the Custom Evaluator.
One
> > > thoght
> > > > > was
> > > > > > > to use the Custom Evaluator and somehow have it read the
content
> > of
> > > > the
> > > > > > > MessageText column as it comes in and have it directly write
> each
> > > > space
> > > > > > > separated value to its own column in the SQL table. Is this
> > > possible?
> > > > > >
> > > > > > Yes, that's the way to go:
> > > > > >
> > > > > > Implement a custom evaluator object that takes the message text,
> > > > extracts
> > > > > > the data to be separated and stores them in the (up to 16)
> available
> > > > > custom
> > > > > > fields. Then configure your "Log to ODBC" action to map the used
> > > custom
> > > > > > fields to your table columns.
> > > > > >
> > > > > >
> > > > > > > Another possibility was using the Custom Evaluator to reformat
> the
> > > > > > incoming
> > > > > > > syslog messages so that each of the MessageText space
separated
> > > values
> > > > > > > becomes a comma separated value and I can then maybe use the
> > Custom
> > > > > > Mapping
> > > > > > > feature in Log to ODBC to map each of these "new" comma
separate
> > > > values
> > > > > > into
> > > > > > > the SQL DB. I don't know if this is possible.
> > > > > >
> > > > > > This won't work.
> > > > > >
> > > > > > > Can I use the "Run a program" option to parse the incoming
> syslog
> > > > > message,
> > > > > > > ie similar to a "pipe" command?
> > > > > >
> > > > > > You could use a "Run a program" action to parse the message text
> > into
> > > > the
> > > > > > desired parts but there are two big problems with this approach:
> > > > > >
> > > > > > 1. Very slow
> > > > > > 2. The program called must then take care of logging the data to
> the
> > > DB.
> > > > > >
> > > > > > I can only recommend to implement a custom evaluator object.
This
> > > > approach
> > > > > > is perfectly suited for your requirements (verfy fast & minimal
> > > resource
> > > > > > usage).
> > > > > >
> > > > > > Should you need help in implementing such a custom evaluator
> object,
> > > > > please
> > > > > > contact me.
> > > > > >
> > > > > > Franz
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>