>I have writtten a DLL in VFP7 which works fine and has done for some time. I have even tested it using VB.
>
>I have now converted it to a Web Sevice and now it can't recognise the data path I pass to it.
>
>Basically the DLL opens 2 tables, runs a select and returns an integer.
>
>Does the web service not handle data in the same way as the DLL?
>
>Many thanks
>Paul
It is possible that web-service does not run as user that has sufficient privileges/rights. To check it create a method of the COM class, that will return the current context username.
use code like the following:
LOCAL lcUserName, lnLen
DECLARE INTEGER GetUserName IN WIN32API String @ Buffer, Integer @ leng
lcUserName = SPACE(255)
lnLen = 255
=GetUserName(@lcUserName, @lnLen)
lcUserName = LEFT(lcUserName, lnLen-1)
Return lcUserName
If this is true try to give more rights to the user that WEB service uses to get access to the system.
HTH
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!