Thanks Glen, Hilmar

Glen i need client running remotly on the network where VFP database is located and am not sure that your solution will work but i learned that VFP OLE DB provider can support Stored procedure which will sort out my problem.
Except i don't know how to call stored procedure through code

I came so far with this :

loConnection = CREATEOBJECT('ADODB.Connection')
WITH loConnection
.Provider = "VFPOLEDB.1" && "sqloledb"
.CursorLocation = adUseClient && 3
.OPEN("DSN=WGSMS")
ENDWITH

loRecSet = CREATEOBJECT('ADODB.Recordset')
lcQuery = "execute get_time"
loRecSet.OPEN(lcQuery ,loConnection)

lcQuery = "CALL get_time" also doesn't work.

My stored procedure will be simple

FUNCTION get_time

return datetime()

If i can call SP via OLEDB that would sort out my problems.

Any ideas.

Thanks

Dejan