IFeatureWorkspace is empty

soniadickerson1

I'm unable to get a workspace from an sde connection and assign the pFeatureWorkspace to it.  Here's the VB code:

        Dim factoryType As Type = Type.GetTypeFromProgID("esriDataSourcesGDB.SdeWorkspaceFactory")

        Dim pWorkspaceFactory As IWorkspaceFactory2

        Dim pFeatureWorkspaceA As IFeatureWorkspace

        Dim pFeatureWorkspaceB As IFeatureWorkspace

        Dim featureWorkspace As ESRI.ArcGIS.Geodatabase.IFeatureWorkspace

‘thePropSet, theWorkspace, fimWorkspace, fimPropSet are global variables

        Try

        pWorkspaceFactory = CType(Activator.CreateInstance(factoryType), IWorkspaceFactory)

            'ReadConnectionPropertiesFromFile

           theWorkspace = pWorkspaceFactory.OpenFromFile(theFilesLoc & "dnrgdrs-prod1-pg-dc-pfmm_dev.sde", 0)

       thePropSet = theWorkspace.ConnectionProperties

            fimWorkspace = pWorkspaceFactory.OpenFromFile(theFilesLoc & "\FOR01-ORA-DC-LRSDB-FIM-DEFAULT.sde", 0)

       fimPropSet = fimWorkspace.ConnectionProperties

‘Both of these give empty results           

            pFeatureWorkspaceA = CType(theWorkspace, IFeatureWorkspace)

            pFeatureWorkspaceB = CType(fimWorkspace, IFeatureWorkspace)

The pFeatureWorkspace is always empty. The database has data, but somehow it can't find it.

When debugging, I get "No children available"

Thank you for any advice.

soniadickerson1

I found out that just because it gives an error:  no children available, doesn't mean that the workspace isn't valid.  Once the workspace is defined, a request to get a table is made and  I was getting an error when trying to open a table.  So I thought it was because of the no children error, but it wasn't.  When opening the table, I was including the name of the schema with the name of the table:  schema.Table_Name  and that's what was the real problem.  I just needed to use the name of the table.