Could not load data from the data source

4457
7
10-18-2013 08:53 AM
AngeletaWilson
New Contributor II
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
Regular Contributor II
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
New 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
New Contributor II
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
Regular Contributor III
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
New Contributor II
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 Frequent Contributor
Angeleta,

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

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