Question

ODBC Data Reader

  • 29 November 2012
  • 2 replies
  • 23 views
dos_gis
Rank
Badge
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
Rank
Badge +21
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
Rank
Badge
Thanks.  I simply had to fully qualify the target table for it to work (pub.gistxtaxes)

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
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.