Hey Guys,I'm hoping that somebody else has come across this.
I'm using ADO 2.6 to write/read into / out of a Visual 7 database from Visual Fox 7.
However, on occasions, I receive the messsage : "oledb provider for microsoft visual foxpro : too many variables".
Now, all I am doing is straight writes / reads from the datasource, there are no stored procedures / triggers etc with the backend data.
I'm using ADO to actually read / write the data because the application has to be datasource independant, but this is driving me crazy, I'm tempted to just re-write the data level objects to use plain foxpro code, rather than use ado, but i would rather stick to doing things the 'proper' way, if you see what I mean.
I really would appreciate any help.
Thanks very much...
Simon
I'm using ADO 2.6 to write/read into / out of a Visual 7 database from Visual Fox 7.
However, on occasions, I receive the messsage : "oledb provider for microsoft visual foxpro : too many variables".
Now, all I am doing is straight writes / reads from the datasource, there are no stored procedures / triggers etc with the backend data.
I'm using ADO to actually read / write the data because the application has to be datasource independant, but this is driving me crazy, I'm tempted to just re-write the data level objects to use plain foxpro code, rather than use ado, but i would rather stick to doing things the 'proper' way, if you see what I mean.
I really would appreciate any help.
Thanks very much...
Simon
