DMO objects in sql 2005
-
hi all, In our code,SQL DMO objects(Sql 2000)are used in the VB components. Now we are doing SQl 2005 upgradation.when i ran the same component in SQl 2005, i got the following error. To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO) .I read in an article that we have to reregister SQL-DMO 2005 version.but i have to change that DMO object to SMO in code. Plz give suggestions on how to convert DMO to SMO. Thanks in advance,
cheers sangeet
-
hi all, In our code,SQL DMO objects(Sql 2000)are used in the VB components. Now we are doing SQl 2005 upgradation.when i ran the same component in SQl 2005, i got the following error. To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO) .I read in an article that we have to reregister SQL-DMO 2005 version.but i have to change that DMO object to SMO in code. Plz give suggestions on how to convert DMO to SMO. Thanks in advance,
cheers sangeet
You need the SQL Server 2005 Backward Compatibility Components package. You can find this at the latest 'Feature Pack' download. The last update was in February 2007 which can be found here[^]. SMO - Server Management Objects - is a set of .NET components that perform much the same function as DMO.
DoEvents: Generating unexpected recursion since 1991