I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a clients' environment).
The OpenFeatureClass method on the IFeatureWorkspace is working correctly when I access feature classes that are in the default schema (SDE).
That same method will fail, however, when I try to access feature classes on the other schemas. The error I'm getting is "Error HRESULT E_FAIL has been returned from a call to a COM component."
Has anyone had a similar issue? Is there something I should do to ensure the other feature classes are accessible to ArcObjects?
Brad Nesom made a good point in the comments about whether the alternate schema tables are spatial. The table WERE spatial, but for some reason after I changed the schema, they were changed to non-spatial. It's possible that ArcSDE does not allow you to modify schemas for spatial tables.