How Do I Test My Provider?
Before you release a provider, you should perform the following tests, in the order indicated. These tests will ensure that the provider functions properly for most potential users.
Test the provider using a consumer application written with the OLE DB consumer templates. The test consumer should cover all functional areas of your provider (all code that you have added or modified).
Test the provider using a consumer application written with ADO. Most developers (especially Microsoft Visual Basic and Microsoft J++ developers) use ADO for consumer applications. Again, the test consumer should cover all functional areas of your provider.
Run the OLE DB conformance tests (including ADO conformance tests) to ensure that your provider meets the level 0 standard for OLE DB providers. These tests and associated documentation are included with Visual C++. These tests also help to ensure that your provider runs well when aggregated by other service providers and are especially useful if you modify or add properties.