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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only