OLE DB Non-Indexed Tables and SQL Server 7.0
The CONNX Query Optimizer uses index information to process tables more efficiently. However, some SQL Server 7.0 tables do not contain index information. CONNX cannot access data stored in SQL Server 7.0 tables that do not contain index information and generates an error.
To prevent this error from occurring when importing SQL Server 7.0 tables, pass the SQL statement CREATE TABLE to the CONNX driver, and follow it with the CREATE UNIQUE INDEX.
Tools such as the Microsoft SQL Server 7.0 Enterprise Manager can be used to add index information to tables. If an index is added to a table after the table is imported into CONNX, the table metadata should be re-imported so that the index information can be accessed.
The Data Transformation Service (DTS) of Microsoft SQL Server 7.0 Enterprise Manager copies and transforms data from one data source to another, but does not replicate key information. Index information must be replaced or inserted in tables generated by DTS.