Author Topic: Importing DB Schema from Oracle (Read 4762 times)

pushtak7 · « **on:** March 06, 2006, 12:18:47 pm »

Maybe someone can help with this:
When I import a DB schema from Oracle, the table comments are truncated to include only about the first 80 characters. Anyone know how to fix this??
Thanks.

hd · « **Reply #1 on:** March 06, 2006, 02:19:22 pm »

Can you provide more details - EA version/build, Oracle version?

EA build 788 successfully imports > 80 char table comments from Oracle 9i (9.0.1.0.1) using ODBC driver 9.00.11.00.

pushtak7 · « **Reply #2 on:** March 06, 2006, 03:49:25 pm »

EA version/build 6.0.778
Oracle 10g 10.1.0.2.0
Importing with Microsoft ODBC for Oracle version 2.575.1117.00 data 8/4/2004 - this is the only ODBC driver that I could get to work.
Thanks.

hd · « **Reply #3 on:** March 06, 2006, 06:03:18 pm »

Using build 778, Oracle 10.2.0.1.0 and Oracle ODBC Driver 9.00.11.00 works for me.

(The Microsoft ODBC Driver for Oracle will not work).

If you have any further problems, submit a bug report directly to Sparx.

mikewhit · « **Reply #4 on:** March 07, 2006, 01:05:46 am »

Quote

(The Microsoft ODBC Driver for Oracle will not work).

I presume this problem has been notified to Microsoft ?

People tend to assume that MS stuff works, and if not it must be your fault !

thomaskilian · « **Reply #5 on:** March 07, 2006, 01:39:25 am »

Quote

I presume this problem has been notified to Microsoft ?

People tend to assume that MS stuff works, and if not it must be your fault !

Mike,
do you think, MS will respect bug reports? My feeling is that you can tell it to the next hydrant and it will help more...

Paolo F Cantoni · « **Reply #6 on:** March 07, 2006, 02:58:22 am »

Quote

Mike,
do you think, MS will respect bug reports? My feeling is that you can tell it to the next hydrant and it will help more...

Thomas,

You undersell Microsoft. I reported a bug in MS Word v4 (which had been there since MS Word v1) and they started to fix it in MS Word v10 (Word 2000).

Paolo

thomaskilian · « **Reply #7 on:** March 07, 2006, 03:57:59 am »

Paolo,
I could swear you haven't told it your next hydrant. Else it would have been fixed already

pushtak7 · « **Reply #8 on:** March 07, 2006, 06:08:32 am »

Thanks for the suggestion.
My problem with the Oracle ODBC driver is that when I try to configure a user DSN I get an error: Unable to connect. SQLState=IM004.
I've scoured the boards, checked my environment variables (PATH, TNS_ADMIN), reinstalled the drivers, etc. Nothing seems to help. Any insights from the all-wise gurus would be appreciated.

thomaskilian · « **Reply #9 on:** March 07, 2006, 12:31:11 pm »

Do you receive that "Unable to connect" only with EA or generally when e.g. trying to import data from Excel.

Btw.: I'm neither an Oracle nor another Guru, just a frequent poster

«Midnight» · « **Reply #10 on:** March 07, 2006, 12:32:02 pm »

Try this page:http://www.orafaq.com/forum/t/38079/0/

pushtak7 · « **Reply #11 on:** March 07, 2006, 03:01:33 pm »

Well, I've succeeded getting the driver to work and the comments seem to transfer ok.

Here is another question: All table columns that are of type NUMBER import with precision and scale set to 0. Any way to fix this?

Thanks.

Sparx Systems Forum

News: