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

Hello

 

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)

       comReleaser.ManageLifetime(featureCursor)

     ' Iterate through the features.

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

 

 

 

 

Outcomes