<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SqlWorkspaceFactory deprecated in 10.1???   error -2147180283 in Data Management Questions</title>
    <link>https://community.esri.com/t5/data-management-questions/sqlworkspacefactory-deprecated-in-10-1-error/m-p/373280#M21224</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Can anyone help me with this issue?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt; I have an instance sde:oracle11g and I'm trying to make a simple select from sample taken from &lt;A href="http://help.arcgis.com/en/sdk/10.0/arcobjects_cpp/componenthelp/index.html#//000800000039000000"&gt;here&lt;/A&gt;, using &lt;/STRONG&gt;&lt;/P&gt;&lt;H3 style="margin-left: -15px; font-size: 13.2480001449585px; color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; margin-bottom: 0.4em; margin-top: 1em;"&gt;&lt;SPAN style="color: #2873ee;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlWorkspaceFactory &lt;SPAN style="color: #303030;"&gt;but cannot understand&lt;/SPAN&gt; &lt;STRONG style="color: #e23d39;"&gt;ERROR CODE -2147180283&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/H3&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.Geodatabase&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.esriSystem&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.ADF.Connection.Local&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ClassLibrary1.GenericObjectPoolVB&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.Geometry&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Dim&lt;/SPAN&gt; con2 &lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;IWorkspace&lt;/SPAN&gt; = &lt;EM&gt;&lt;STRONG&gt;(I have an object pool here that returns me propper workspace object, and I name it as con2)&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Dim&lt;/SPAN&gt; sqlWorkspace &lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;ISqlWorkspace&lt;/SPAN&gt; = CType(con2, &lt;SPAN style="color: #4fcddc;"&gt;ISqlWorkspace&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #7ed529;"&gt;' Construct a SQL query.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #2873ee;"&gt;Dim &lt;/SPAN&gt;queryBuilder &lt;SPAN style="color: #3334ca;"&gt;&lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #4fcddc;"&gt;StringBuilder&lt;/SPAN&gt; = New &lt;SPAN style="color: #4fcddc;"&gt;StringBuilder()&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; queryBuilder.Append("&lt;SPAN style="color: #e23d39;"&gt;SELECT *&lt;/SPAN&gt; ")&lt;/P&gt;&lt;P&gt;&amp;nbsp; queryBuilder.Append("&lt;SPAN style="color: #e23d39;"&gt;FROM&lt;/SPAN&gt; " + listView1.FocusedItem.Text)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #2873ee;"&gt;Dim &lt;/SPAN&gt;query &lt;SPAN style="color: #2873ee;"&gt;As String&lt;/SPAN&gt; = queryBuilder.ToString()&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Using&lt;/SPAN&gt; comReleaser &lt;SPAN style="color: #3334ca;"&gt;As&lt;/SPAN&gt; ESRI.ArcGIS.ADF.&lt;SPAN style="color: #4fcddc;"&gt;ComReleaser&lt;/SPAN&gt; = &lt;SPAN style="color: #2873ee;"&gt;New&lt;/SPAN&gt; ESRI.ArcGIS.ADF.&lt;SPAN style="color: #4fcddc;"&gt;ComReleaser&lt;/SPAN&gt;() &lt;SPAN style="color: #7ed529;"&gt;&lt;EM&gt;&lt;STRONG&gt;'is this correct reference? deprecated?&lt;/STRONG&gt;&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #7ed529;"&gt;' Create the query cursor.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Dim&lt;/SPAN&gt; featureCursor &lt;SPAN style="color: #3334ca;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;IFeatureCursor&lt;/SPAN&gt; = CType(sqlWorkspace.OpenQueryCursor(query), &lt;SPAN style="color: #4fcddc;"&gt;IFeatureCursor&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; comReleaser.ManageLifetime(featureCursor)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #7ed529;"&gt; ' Iterate through the features.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Dim&lt;/SPAN&gt; feature As IFeature = featureCursor.NextFeature() &lt;SPAN style="color: #e23d39;"&gt;&lt;STRONG&gt;' HERE ERROR IS COMException was unhandled ERROR CODE -2147180283&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 24 Aug 2015 20:39:36 GMT</pubDate>
    <dc:creator>MarceloJury</dc:creator>
    <dc:date>2015-08-24T20:39:36Z</dc:date>
    <item>
      <title>SqlWorkspaceFactory deprecated in 10.1???   error -2147180283</title>
      <link>https://community.esri.com/t5/data-management-questions/sqlworkspacefactory-deprecated-in-10-1-error/m-p/373280#M21224</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Can anyone help me with this issue?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt; I have an instance sde:oracle11g and I'm trying to make a simple select from sample taken from &lt;A href="http://help.arcgis.com/en/sdk/10.0/arcobjects_cpp/componenthelp/index.html#//000800000039000000"&gt;here&lt;/A&gt;, using &lt;/STRONG&gt;&lt;/P&gt;&lt;H3 style="margin-left: -15px; font-size: 13.2480001449585px; color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; margin-bottom: 0.4em; margin-top: 1em;"&gt;&lt;SPAN style="color: #2873ee;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlWorkspaceFactory &lt;SPAN style="color: #303030;"&gt;but cannot understand&lt;/SPAN&gt; &lt;STRONG style="color: #e23d39;"&gt;ERROR CODE -2147180283&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/H3&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.Geodatabase&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.esriSystem&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.ADF.Connection.Local&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ClassLibrary1.GenericObjectPoolVB&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Imports&lt;/SPAN&gt; ESRI.ArcGIS.Geometry&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Dim&lt;/SPAN&gt; con2 &lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;IWorkspace&lt;/SPAN&gt; = &lt;EM&gt;&lt;STRONG&gt;(I have an object pool here that returns me propper workspace object, and I name it as con2)&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #2873ee;"&gt;Dim&lt;/SPAN&gt; sqlWorkspace &lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;ISqlWorkspace&lt;/SPAN&gt; = CType(con2, &lt;SPAN style="color: #4fcddc;"&gt;ISqlWorkspace&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #7ed529;"&gt;' Construct a SQL query.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #2873ee;"&gt;Dim &lt;/SPAN&gt;queryBuilder &lt;SPAN style="color: #3334ca;"&gt;&lt;SPAN style="color: #2873ee;"&gt;As&lt;/SPAN&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #4fcddc;"&gt;StringBuilder&lt;/SPAN&gt; = New &lt;SPAN style="color: #4fcddc;"&gt;StringBuilder()&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; queryBuilder.Append("&lt;SPAN style="color: #e23d39;"&gt;SELECT *&lt;/SPAN&gt; ")&lt;/P&gt;&lt;P&gt;&amp;nbsp; queryBuilder.Append("&lt;SPAN style="color: #e23d39;"&gt;FROM&lt;/SPAN&gt; " + listView1.FocusedItem.Text)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #2873ee;"&gt;Dim &lt;/SPAN&gt;query &lt;SPAN style="color: #2873ee;"&gt;As String&lt;/SPAN&gt; = queryBuilder.ToString()&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Using&lt;/SPAN&gt; comReleaser &lt;SPAN style="color: #3334ca;"&gt;As&lt;/SPAN&gt; ESRI.ArcGIS.ADF.&lt;SPAN style="color: #4fcddc;"&gt;ComReleaser&lt;/SPAN&gt; = &lt;SPAN style="color: #2873ee;"&gt;New&lt;/SPAN&gt; ESRI.ArcGIS.ADF.&lt;SPAN style="color: #4fcddc;"&gt;ComReleaser&lt;/SPAN&gt;() &lt;SPAN style="color: #7ed529;"&gt;&lt;EM&gt;&lt;STRONG&gt;'is this correct reference? deprecated?&lt;/STRONG&gt;&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #7ed529;"&gt;' Create the query cursor.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Dim&lt;/SPAN&gt; featureCursor &lt;SPAN style="color: #3334ca;"&gt;As&lt;/SPAN&gt; &lt;SPAN style="color: #4fcddc;"&gt;IFeatureCursor&lt;/SPAN&gt; = CType(sqlWorkspace.OpenQueryCursor(query), &lt;SPAN style="color: #4fcddc;"&gt;IFeatureCursor&lt;/SPAN&gt;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; comReleaser.ManageLifetime(featureCursor)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #7ed529;"&gt; ' Iterate through the features.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #3334ca;"&gt;Dim&lt;/SPAN&gt; feature As IFeature = featureCursor.NextFeature() &lt;SPAN style="color: #e23d39;"&gt;&lt;STRONG&gt;' HERE ERROR IS COMException was unhandled ERROR CODE -2147180283&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 24 Aug 2015 20:39:36 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/sqlworkspacefactory-deprecated-in-10-1-error/m-p/373280#M21224</guid>
      <dc:creator>MarceloJury</dc:creator>
      <dc:date>2015-08-24T20:39:36Z</dc:date>
    </item>
    <item>
      <title>Re: SqlWorkspaceFactory deprecated in 10.1???   error -2147180283</title>
      <link>https://community.esri.com/t5/data-management-questions/sqlworkspacefactory-deprecated-in-10-1-error/m-p/373281#M21225</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello, I've discovered this issue, and was related to a wrong oracle client installation, in fact a mismatched version, the reason to post was just a confusing &lt;STRONG style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif; color: #e23d39;"&gt;ERROR CODE -2147180283.... thanks anyway.&lt;/STRONG&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Sep 2015 19:47:00 GMT</pubDate>
      <guid>https://community.esri.com/t5/data-management-questions/sqlworkspacefactory-deprecated-in-10-1-error/m-p/373281#M21225</guid>
      <dc:creator>MarceloJury</dc:creator>
      <dc:date>2015-09-09T19:47:00Z</dc:date>
    </item>
  </channel>
</rss>

