Answer
If a connection is successful but no tables appear, the provider does not support the IDBSchemaRowset interface. ArcGIS requires this interface to browse a workspace.
The provider can still be used programmatically but will not be able to browse a workspace for tables/views.