Readers may recognise a similar question posted a few months ago, but things have moved on and the criteria has changed, hence this new thread.

My client is running an insurance sales website which calculates a premium upon form submission and (hopefully) a sale made via a credit-card transaction. Up to now the premium calculation has been straightforward (ie. a flat-rate monthly or annual fee), but the formula needs to be modified to accomodate factors such as age, health history, postcode, etc..

There is already a desktop application (VFP front-end, SQL-server back-end) which has a function GetPremium() which accepts these parameters and produces a cursor containing the required output values. What I require is to create a COM object from the function so that the website (ASP accessing SQL tables) can call the function, which would return calculated values via a comma-delimited or XML string.

I envisage the asp calling code to be something like...
<%
Set ComTest = CreateObject("MyDLL.dll")
strOut = ComTest.GetPremium ParamList
%>

I have generated a single-threaded dll from the function and I note that corresponding .TLB and .VBR files are also generated. Are these files required, and if so, where are these to be located on the webserver? I guess the VFP8 runtime files will also be required - which files do I require and where do I put them, in the same folder as the .dll file?

I guess the function could also be called as a web-service, but this may be overkill because it is not available to anyone on the web, only to the web application, so I am assuming that a single-threaded dll will suffice.


Any help would be appreciated.

Alan Harris-Reid