>>I documented it on forums for a few times at least:) I noticed the dicrepencies first with XML datatype, then OLEDB driver and passing byte arrays from .Net (now in list of corrected bugs of SP2-but I don't use SP2) then varchar(max). Bug seems to be within VFP not the driver itself. Try with a nonVFP environment and it correctly returns the data.
>
>Hi Cetin,
>Can you show me the error of Passing byte array from .net and VFPoledb driver Please? What error is it ?
>
>
>Suhashegde
Hi Suhas,
With OLEDB driver (prior to SP2) if you send a byte[] from .Net to a VFP SP and byte[].Length > 8000 then SP gets a null instead. It happens only if you do that with ADO.Net, doesn't happen with ADO from somewhere else say a VB6.
Hang on and I'll find the thread where it started with a workaround.
Update: Here is the link to the thread
Vfpoledb and binary parameters Thread #
1198862 Message #
1198862Cetin