>Steve,
>as far as I can remember I managed to get the 'provider' to work with ADO but not with the straight sqlexec(). I posted some stuff about this on the profox list, so you could check Ed's archive if you'e interested:
>http://leafe.com/archiveSearch.html
>
> AndyD 8-)#


Thanks Andy. I have rewritten the code to follow your ADO example. I am getting a VFP.exe error --memory could not be written to!-- on loRecordSet.open(....

Is there something wrong with one of my ADO configurations:

thanks,

Steve


Here is the code:


Local loConnection,lcConnectString
loConnection = CreateObject("adodb.connection")

With loConnection
lcConnectString = "Provider=MSDAORA.1;Password=mypassword;User ID=myname;Data Source=mydata.forme.com"
.ConnectionString = lcConnectString
.Open
Endwith


loRecordSet = CreateObject("adodb.recordset")

lcCommandText = ;
"GET_CURSOR_PKG.GET_MembershipCursor(?,'2474','3281')"
loRecordSet.Open(lcCommandText,loConnection, 0, 1, 4)

lnRecords = loRecordSet.recordcount

Release all