The COM object you are creating is named "sqlSMO", are you sure this isn't already the object you are looking for?
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul Newton Sent: Wednesday, April 29, 2020 11:56 AM To: profoxtech@leafe.com Subject: SQL Server Shared Management Objects (SMO)
Hi all
We have been using the following to get a list of available servers loDMO = CreateObject("sqlSMO.Application") loServerList = loDMO.ListAvailableSQLServers
However SQL-DMO was apparently deprecated with SQL Server 2005 and succeeded by SQL-SMO. Has anybody used SQL Server Shared Management Objects in VFP and, if so, can they please give me some pointers on what I need to install and how to implement code to replace that above. Many thanks
Paul Newton
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]