Thanks Tracy - my mistake we are in fact currently using loDMO = CreateObject("sqlDMO.Application")
Paul
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Tracy Pearson Sent: 29 April 2020 16:59 To: profoxtech@leafe.com Subject: RE: SQL Server Shared Management Objects (SMO)
Sent by an external sender ------------------------------
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]