Skip to main content
Question

ODBC Data Reader

  • November 29, 2012
  • 2 replies
  • 38 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?

2 replies

sigtill
Contributor
Forum|alt.badge.img+24
  • Contributor
  • 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

dos_gis
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • December 3, 2012
Thanks.  I simply had to fully qualify the target table for it to work (pub.gistxtaxes)

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings