Processing extensions - Can you use VB

[satshergill]

I'm trying to create a processing extension that will record info on the user, request type and report accessed into another database

I have downloaded all the necessary info from crystal
but am a VB developer and not C++.

Has anybody done this, if so can you post the code to
connect to a SQL server database and Insert the required data into a table

If only you could do it VB???

 

[SteveRemington]

Firstly, to answer your specific question it is POSSIBLE to write a Proc Ext using VB, HOWEVER, VB based Proc Exts are NOT supported by Crystal Decisions if you have a problem and I believe there are issues related to VB based Proc Exts NOT being thread-safe (I am not 100% sure about the last point and am prepared to be corrected).

Also, do you NEED to use processing extensions to capture usage information. This can also be done using the CSP code and javascript (or VB script) by modifying ePortfolio (or whatever user interface you are using) to intercept the user's report access request, capture and record the information and then proceed with the user's request.

I do not know your specific situation but using the CSP based option may be simpler to develop and you also have access to a broader range of functions, that is the CE 8.5 Proc Ext SDK while being useful in many circumstances is limited relative to the CSP SDK.
Regards,
Steve Remington
Wave Business Solutions
steve.remington@wavebusiness.com.au