On Windows2000, go into Control Panel, Component Services:
1.)Right click COM+ applications and select New.
2.)Using the wizard, create an Empty Application,giving it a name/check server application, and selecting the appropriate account to run under.
3.)After the Empty Application is created, Right click on 'Components' under the newly created application.
4.) Select New/Component.
5.) The wizard starts - select 'Import components that are already registered.'
6.) Select the name of your vfp mtdll from the list and it will be added to this new COM+ app.
7.) Right click on the new COM+ application name and select 'Start'. The COM+ icon is now revolving in the Components pane.
It should now be running under COM+ now using the Impersonated User.
>Claude, how do you give an mtdll "the proper impersonation/identity." I don't know what this means. How do you implement the proper impersonation/identity? I want to use the mtdll to create a function in Excel using VBA that can access data from VFP tables on a network drive.
>
>Joel
>
>>For networked access to your vfp database, you've got to run your mtdll from COM+ (create a COM+ package) giving it the proper impersonation/identity. Same with using a mtdll with SQL/MSDE/Oracle/MySQL...
>>>I'm sure this question has been asked 1000 times but this is my first exposure.
>>>
>>>How do you access a mapped network drive from a VFP DLL? I seem to be able to access local data but not data on a mapped network drive. Will someone please point me to an article on this?
>>>
>>>Thank you.
>>>
>>>Joel