Hi Pete...

VFP 5.0a should be fine for what you are doing. You will run into problems if you try to work with VFP COM DLL's. I would suggest upgrading to 6.0.

As far as the second example goes - do you have access to SQL Server? I think that is the only provider that will return multiple recordsets. You cannot use the ODBC OLE-DB Provider for this. My guess is that may be your problem..


>John,
>thanks for your time and code, The first example runs a treat after modifying >the Open method to oConnect.Open('mynwind') as I don't have the Jet driver >installed, the second example returns a "General Network Error" - "Check your >Server Documentation" this occurs when the connection objects' Open method is >called. By the way I'm still using VFP 5.0a ( have ordered 6 ) is this a >problem?