AnsweredAssumed Answered

SqlWorkspaceFactory deprecated in 10.1???   error -2147180283

Question asked by marce002b on Aug 24, 2015
Latest reply on Sep 9, 2015 by marce002b



Can anyone help me with this issue?

I have an instance sde:oracle11g and I'm trying to make a simple select from sample taken from here, using

     SqlWorkspaceFactory but cannot understand ERROR CODE -2147180283




Imports ESRI.ArcGIS.Geodatabase

Imports ESRI.ArcGIS.esriSystem

Imports ESRI.ArcGIS.ADF.Connection.Local

Imports ClassLibrary1.GenericObjectPoolVB

Imports ESRI.ArcGIS.Geometry


Dim con2 As IWorkspace = (I have an object pool here that returns me propper workspace object, and I name it as con2)

Dim sqlWorkspace As ISqlWorkspace = CType(con2, ISqlWorkspace)


' Construct a SQL query.

  Dim queryBuilder As StringBuilder = New StringBuilder()

  queryBuilder.Append("SELECT * ")

  queryBuilder.Append("FROM " + listView1.FocusedItem.Text)


  Dim query As String = queryBuilder.ToString()


  Using comReleaser As ESRI.ArcGIS.ADF.ComReleaser = New ESRI.ArcGIS.ADF.ComReleaser() 'is this correct reference? deprecated?

      ' Create the query cursor.

       Dim featureCursor As IFeatureCursor = CType(sqlWorkspace.OpenQueryCursor(query), IFeatureCursor)


     ' Iterate through the features.

       Dim feature As IFeature = featureCursor.NextFeature() ' HERE ERROR IS COMException was unhandled ERROR CODE -2147180283