Paul,

SQL Server allows to work with COM server using set of system stored procedures: sp_OACreate, sp_OAGetProperty, sp_OASetProperty, sp_OAMethod, sp_OAGetErrorInfo and sp_OADestroy. I'm not sure what you're trying to do but keep in mind that it isn't the best way to work with data. It could be much slower than using stored procedures.


>Newbie here to SQL Server. Is it possible to create object references to COM objects in SQL Server the way one does in VFP? I have many objects written in VFP and would like not to have to recode them as stored procedures in SQL Server.
>