Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I use an ODBC connection to an SDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL SDE server and the connection info matches what I see in ArcCatalog.

The problem is that the ODBC connection returns a version of the table that is several months old - it shows some features that have been removed and doesn't show some new features.

Using the same connection information in ArcMap, I see a current version of the table and the current set of features.

I have created a new ODBC connection, tried refreshing the connection, and tried using the connection in Microsoft Access and R.

Any suggestions?

UPDATE: this question referred to a versioned table. As it turns out, an editor had checked out a parent version of the SDE some time ago and never checked it back in. This was preventing subsequent child versions from being compressed back to the DEFAULT table. Child edits were being kept in a delta table but still showing in ArcMap; the ODBC connection wasn't aware of the delta table and was showing DEFAULT as it existed when the rogue parent version was checked out.

Thanks for the suggestions.

share|improve this question
1  
Is it a versioned table? –  Chad Cooper Feb 7 '12 at 3:37
    
Similarly, when was the last time you compressed to DEFAULT? –  blah238 Feb 7 '12 at 3:50
add comment

1 Answer

More than likely you are viewing the default version with odbc and an edit version through arc. Try reconcile version through arcgis tools.

share|improve this answer
    
this is a versioned table, so I will check the viewed table and request a compress to DEFAULT –  user5797 Feb 8 '12 at 2:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.