import DB schema from ODBC source

[pr1smiley]

Hello,

The import DB schema from ODBC source is not working. i can place random text in the schema/owner box and import and all object are included

thanks

[«Midnight»]

Not all databases, or ODBC drivers, support owners. Can you be more specific about which software components you are using?

[pr1smiley]

Hey Midnight,

Actually I'm using the DB2 client tools ver 8.2

Thanks

[«Midnight»]

My guess is that EA is not using the fields you mention. Depending on the DBMS, EA may or may not do something - anything, it varies between products - with this information. [For example, including an entry in the one of these fields (I cannot remember exactly) can cause Oracle tables to become invisible to the import; clearing the entry can correct the problem.]

The interesting things are that EA seems to allow you to enter something (i.e. not empty) and then it seems to ignore the entry; and EA allows you to enter anything (i.e. not a valid entry as far as the DBMS is concerned) and still ignores the entry.

At least one of these, possibly both, could be a Windows or IBM problem, rather than an EA issue. If the ODBC client dialog is where you are entering this information, then EA has no control over how that data is used (for connection at least). If you are entering this on an EA-provided dialog then EA is the culprit.

In that case (an EA problem) I suggest you report this to Sparx as a bug. One way or the other something is wrong. EA should either disable the field (if it is not used at all) or validate the data and act accordingly (if it is).

You'll find the bug report by clicking the Report a Bug link below the Support link near the bottom of any forum page. Remember to include the manufacturer and specific build number (i.e. the entire version number, with all the fields) of the driver and DBMS components you are using, and any other components that might be involved.

David

[pr1smiley]

Midnight,

Thanks for the insight, I'll submit a bug report