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
  • sigtillContributor
  • 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
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)

Reply


Most helpful members this week

Community Stats

30,851
Posts
116,970
Replies
38,683
Members
Terms & ConditionsCookie settings

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
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.