Skip to main content
Question

ODBC Data Reader

  • November 29, 2012
  • 2 replies
  • 48 views
dos_gis
Contributor
Forum|alt.badge.img+3
Hi, I'm trying to connect to a database using the ODBC 3.x data reader.  The parameters seem correct and I can see the tables in the Table list.  When I try to add the data I get the error:

 

 

ODBC2 Reader: Now reading schema for gistxtaxes Database Generated Error Information: Database Error Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Table/View/Synonym not found (7519) Database SQL Statement Text: SELECT * FROM "gistxtaxes" WHERE 1=0 SQL State: 42S02 Variable Information:  ODBC2 Reader: Failed to get schema for feature type 'gistxtaxes'. Continuing with next feature type in the list

 

 

I can connect to the data base and add data in ArcMap using the same connection parameters.  Any idea what's going on?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

sigtill
Supporter
Forum|alt.badge.img+25
  • sigtillSupporter
  • Supporter
  • December 3, 2012
Perhaps you used this reader previously with another FeatureType? Try to open a new blank workspace and add a brand new reader to see if this solves the issue
The real SigTill
dos_gis
Contributor
Forum|alt.badge.img+3
  • dos_gisContributor
  • Author
  • Contributor
  • December 3, 2012
Thanks.  I simply had to fully qualify the target table for it to work (pub.gistxtaxes)

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.