topic Re: Refresh SQL Server Native Client after renaming a Field? in ArcObjects SDK Questions

Refresh SQL Server Native Client after renaming a Field?

MickeyO_Neil — Wed, 29 May 2013 15:31:00 GMT

Hello,

I renamed a Field of a FeatureClass in an ArcSDE with the IClassSchemaEdit4.AlterFieldName Method.
This works fine, but as soon as I create a Cursor to iterate the FeatureClass I get an SQL Server Native Client Error, which can't find the old(!!) Fieldname in the Database.

m_pCursor = pFeatureClass.Search(Nothing, False)

But if i look for the renamed Field in the FeatureClass everything is fine --> I can't find the old fieldname and the new one is there.

I have no idea why the Native Client is looking for the old Fieldname? Do I have to refresh the Client somehow?

If I restart my application or look at the FeatureClass with ArcCatalog everything works fine.

Any idea whats going on with the Microsoft SQL Server Native Client 10.0?

Thanks
Mickey

Re: Refresh SQL Server Native Client after renaming a Field?

AndryJoos — Wed, 07 Oct 2015 14:33:32 GMT

We're currently encountering a similar issue. Have you ever found a resolution to this problem?

Re: Refresh SQL Server Native Client after renaming a Field?

MickeyO_Neil — Wed, 19 Oct 2016 11:02:11 GMT

You have to reconnect to the Workspace, and look for the Feature-Class, again. Then only use the new FC-Object and dispose the old one.

Re: Refresh SQL Server Native Client after renaming a Field?

AndryJoos — Wed, 19 Oct 2016 18:29:53 GMT

Hi Mickey, thanks for your answer. While this would resolve the problem, it does not work for us in a performance critical environment where reconnecting to the workspace is not an option. We have, while exploring workarounds, found a way to avoid our original problem. Thanks!