Thank you Sergey, that works in my test database. I have a related question, if I get a "Function is not implemented" error, does that mean that some of the VFP functions in my stored procedure is not implemented in the VFP OLEDB? I am using the XmlAdapter object in my stored procs.

>

ors = oConn.Execute('GetUser()')
>? oRs.Fields(0).Value
>

>>>>I have a VFP stored procedure in my VFP database named as: GetUser() which returns a string (xml). I am not accessing the VFP database directly and use ODBC to connect to it, can I use SQLEXEC() to call the stored procedure and accept the string?
>>>
>>>No, you cannot. You've to use VFP OLE DB provoder.
>>
>>How do I get the returned string from the Ado object? Looking at the ADO object, I don't see a property where the results might be stored. The simplest implementation I can think of is:
>>

>>xx=""
>>numericValIsReturned = 0
>>oConn = createobject('ADODB.Connection')
>>cConnString = "Provider=vfpoledb.1;Data Source=Test.dbc"
>>oConn.Open(cConnString)
>>oConn.Execute('GetUser()') && How do I capture the returned string?
>>oConn.Execute('GetUser()',@xx) && Returns number of rows?
>>oConn.Execute('GetUser()',@xx,@numericValIsReturned) && Returns a numeric value?
>>oConn.Close()
>>?xx,numericValIsReturned
>>