>>>I have the latest MSDE installed on my computer and am trying to use Andrew Coates management tool but it cannot find the SQL namespace. Is there a separate install for the automation servers?
>>>
>>>Thanks
>>>
>>Glenn,
>>
>>I haven't had experience with MSDE, but it should install if the Enterprise Manager is installed.
>
>Thanks George,
>
>But I do not have the enterprise manager, and the documentation says that SQL Namespace and SQL-DMO are available from MSDE. My only problem is that I cannot instanciate the object. Plus I cannot find the "SQLNS.SQLNamespace" using isComObject (Rick Strahl).
>
Glenn,
Two suggestions. First, use the registry class that comes with VFP to determine if the SQLDMO.SQLServer object is registered using the IsKey() function. The DLL that contains the SQLDMO object is SQLDMO.DLL. For SQL Server 2000, it's in Program Files\Microsoft SQL Server\80\Tools\Binn. If it there, then look at MSKB#
822034. It basically describes using regsvr32 to register the object.
George
Ubi caritas et amor, deus ibi est