topic Re: IFeatureWorkspace is empty in ArcObjects SDK Questions

IFeatureWorkspace is empty

soniadickerson1 — Thu, 13 Nov 2014 13:19:26 GMT

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.

Re: IFeatureWorkspace is empty

DuncanHornby — Mon, 17 Nov 2014 18:56:44 GMT

Have you confirmed that theWorkspace is not Nothing?

Re: IFeatureWorkspace is empty

soniadickerson1 — Mon, 17 Nov 2014 19:06:26 GMT

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.

Re: IFeatureWorkspace is empty

ShriramBhutada1 — Tue, 18 Nov 2014 21:26:42 GMT

Hi,

what version on ArcGIS are you using? and is it a standalone application? Starting from 10.0 version in standalone application Runtime license binding is a requirement.

Re: IFeatureWorkspace is empty

soniadickerson1 — Wed, 19 Nov 2014 13:03:17 GMT

Shriram,

Thank you for asking. I'm using 10.2 and it is an addin. However, the no children error wasn't actually the problem. The opentable method on the feature workspace wouldn't return anything, so I thought it was because of that error. However, it was actually because I was adding the schema name with the table. This was an extension developed for 9.3 and at that time, you needed to have the schema name with the table name. With 10.2, you don't.

But thank you so much for participating.