Select to view content in your preferred language

Could not load data from the data source

4987
7
10-18-2013 08:53 AM
AngeletaWilson
Emerging Contributor
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?
7 Replies
NidhinKarthikeyan
Honored Contributor
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,
0 Kudos
BrooksKelley
Emerging Contributor
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.
0 Kudos
AngeletaWilson
Emerging Contributor
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...
0 Kudos
AsrujitSengupta
Deactivated User
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
0 Kudos
AngeletaWilson
Emerging Contributor
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.
0 Kudos
George_Thompson
Esri Notable Contributor
Angeleta,

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

Thanks!
George
--- George T.
AngeletaWilson
Emerging Contributor
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.