>>>I tried o=createobject( "ADODB.Recordset" ) in the VFP command window and got the message "Class definition not found."
>>>
>>>What do I need to install to be able to create an ADO recordset? TIA.
>>
>>I just tried it and it works. This is the correct syntax to use. Make sure all the required components to use ADO are installed in your workstation.
>>
>>BTW, just curious, why do you want to use ADO from Visual FoxPro? You can use direct Visual FoxPro commands to access your SQL Server data.
>
>Given the major hype re: ADO I'm curious about it. How do you use FoxPro to create middle-tier objects that can be used by various front ends? That can access various back ends? How do you separate business objects from data objects? (In all my spare time ...)


An excellent book is "Visual Basic 5.0 Business Objects", Wrox Press ISBN
1-861000-43-X. Yes, I know it says VB, but all the theories apply to any language. If you are an MSDN member, you can get this book at a discount. (www.microsoft.com/msdn). MSDN Online membership is free.