Articles in this section

See more

Reverse Engineering ERwin metadata using ODBC: When I set target server as ODBC 3.x, ERwin Reverse Engineering returns error message: [DataDirect][Open Access ODBC] Dynamic SQL error - invalid description count. There is no result for column 13.

Avatar
Thais Pedroso
Updated
Follow

Reverse Engineering ERwin metadata using ODBC: When I set target server as ODBC 3.x, ERwin Reverse... - CA Technologies ERwin Knowledge Base

Article ID: 371
Last updated: 11 Apr, 2012

 

Components:ERwin Data Modeler: 7.3
Last Modified Date:    01/04/2011
Document ID:    TEC538895
Tech Document
Title:  Reverse Engineering ERwin metadata using ODBC: When I set target server as ODBC 3.x, ERwin Reverse Engineering returns error message: [DataDirect][Open Access ODBC] Dynamic SQL error - invalid description count. There is no result for column 13.

Description:

I am Reverse Engineering ERwin metadata using ERwin ODBC Data source, when I set target server as ODBC 3.x, ERwin Reverse Engineering returns error message;[DataDirect][Open Access ODBC] Dynamic SQL error- invalid description count. There is no result for column 13.

Solution:

The ODBC interface to ERwin is not a Level 3 driver. It is a Level 2 driver. The solution is to select ODBC 2.x.

Note: The ERwin ODBC query tool does use a Level 3 driver.

 

Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk