Could not load data from the data source

[AngeletaWilson]

I am trying to access some data from a version 10.0 SDE GDB using Desktop 10.2 but for some of the layers, when i try to access the table i get the error "Could not load data from the data source". This only happens with some layers and on others i can open the table but it comes up either blank or with the field values all set to '0'. I found an old post that spoke to the field names using incorrect field names, but i checked all the fields and they seem fine http://forums.esri.com/Thread.asp?c=2&f=1719&t=293619.

Apparently that issue was fixed in 10.0, but i cannot find any information relating to 10.1 or higher. Can someone assist please?

[NidhinKarthikeyan]

Angeleta,

Check whether the name of the Feature class/Table/Field, doesn't contain a space/special character or begin with number. For the purpose of test, try renaming the feature class and table. Make sure you have a complete backup before the test.

Regards,

[BrooksKelley]

Did you ever figure this out? We're experiencing the same thing with ArcGIS Desktop 10.2 and an SDE 10 GDB. It seems to only occur over a slower network connection.

[AngeletaWilson]

Did you ever figure this out? We're experiencing the same thing with ArcGIS Desktop 10.2 and an SDE 10 GDB. It seems to only occur over a slower network connection.

No, and issue persists; another colleague is also having the same issue as well...

[AsrujitSengupta]

Angela,

Can you please try a OLEDB connection and check whether that gives you the same issue.

Adding OLE DB connections to databases:
http://resources.arcgis.com/en/help/main/10.2/index.html#//006600000452000000

[AngeletaWilson]

Angela,

Can you please try a OLEDB connection and check whether that gives you the same issue.

Adding OLE DB connections to databases:
http://resources.arcgis.com/en/help/main/10.2/index.html#//006600000452000000

I tried this and i can view the tables fine through the OLEDB connection.

[George_Thompson]

Angeleta,

What RDBMS and O/S are you using for your 10.0 SDE?

Thanks!
George

[AngeletaWilson]

I got this issue resolved today by a nice ESRI support guy, Nitesh J. Apparently even though I was running the SQL Server Native Client, I needed to run SQL Server Native Client Release 2. After uninstalling the sqlncli and installing sqlncli release 2, my tables were loading fine!

http://www.microsoft.com/en-in/download/details.aspx?id=16978 - First go to Installation Instructions and scroll down to Microsoft® SQL Server® 2008 R2 Native Client. You have to ensure that you are installing the one that is compatible with your machine.