Error - " No Current Records " or Error " Unknown COM error "

Article:TECH144718  |  Created: 2010-11-22  |  Updated: 2010-11-22  |  Article URL
Article Type
Technical Solution


This error message has been observed when usually querying some of the Data Sources in BVC-SQL.  The effected datasources are usually the following data sources:

Remote Logins
Remote Servers
Replication DB query
Server Audit
Server Logins
Server Roles


One of the two error messages are observed

- No Current Records

- Unknown COM error



BVIS is using SQL 2008 64 bit version on x64 platform.

CCS 10 - 2010-4 PCU

OS : Windows 2003 64-bit SP2 Enterprise

Note: This error was observed in this specific environment , Other environments have not been tested for this error message.


Backward compatibility components for SQL 2008 are found to be missing.


Install DMO which can be found in the "Backward compatibility components for SQL Server 2005". x 64 package

 Installer was downloaded from

The SQL Server Backward Compatibility package includes the latest versions of the Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with both SQL Server 2005 and SQL Server 2008 and include all fixes shipped through SQL Server 2000 Service Pack 4 (SP4) and SQL Server 2005 SP2.

Article URL

Terms of use for this information are found in Legal Notices