For some reason, when I include "Provider=MSDataShape;Data Provider=SQLOLEDB.1. . . " in my connection string under ADO I get the error "class not registered." I thought the MSDataShape provider was registered when you installed MDAC 2.5 or 2.x. Any help would be greatly appreciated. I can create a Data Shaping query in the Data Environment but damn if I want to code that way. I want to create the necessary SHAPE SQL on the fly using the MSDataShape provider.