This is an old, old problem that --Microsoft should have documented to help us all a long, long time ago -- !!!
The solution when using a vfp mtdll and fox data across the network (or using SQL/MSDE from the mtdll)is to use COM+ which allows the mtdll to impersonate an account with the proper rights. Here are some simple instructions that will be included with the next version of ActiveVFP(
http://www.activevfp.com):
COM + Setup Instructions for a VFPmtdll on Windows20001.)go into Control Panel, Component Services
2.)right click COM+ applications and select New.
3.)going through the wizard, create an Empty Application,giving it a name, check server application,
and select the appropriate account to run under.4.)After the Empty Application is created, right click on 'Components' under the newly created application.
5.) select New/Component.
6.) The wizard starts - select 'Import components that are already registered.'
7.) select your vfp mtdll from the list and it is added to this COM+ app.
8.) right click on your COM+ application name and select 'Start'. The COM+ icon is now revolving in the Components pane.
>I have a VFP created dll with an OLE COM object in it. This has a method which opens some VFP data, formats it and returns the HTML as a string.
>
>I have an ASP which instantiates the COM object and calls the method. Then Reponse.Write(s) the result.
>
>I have IIS running on my PC and the ASP is run within this envioronment. The DLL is registered on my PC also.
>
>When the data is on my PC it all works fine. However, I want the DLL COM object to open data on another PC on my LAN. When I instantiate the COM object in VFP it all works fine. However from the ASP nothing.
>
>Now I understand that this is all about security permissions. I have tried everything - in IIS, in Component services. I have set up users on the remote PC and my PC - but nothing works.
>
>Can anyone give me a list of what I have to do to get this to work?
>
>thanks,
>
>Andrew R.