Messages

1

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 17, 2008, 09:17:51 am »

Thanks a lot louis, this works!!

2

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 17, 2008, 07:17:05 am »

All, at last i managed to import correctly, it was  the problem with the driver, I replaced the driver and now importing correctly.

One solution i needed now, that is, previously i imported 1 whole schema with varchar(255) datatype into one folder in datamodel, and created many datamodel diagrams based on that.  now, when i import the schema again with correct datatype into the same folder, how can I make these changes reflect in my data model diagrams?

Creating all datamodel diagrams again is a big task, i am looking for a solution to reflect these changes into my diagrams...

Can anyone help on these please?

3

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 16, 2008, 09:24:15 am »

you mean, remove connection, and recreate it?

I tried this for different schema's but for every schema imports, i am getting the same issue

4

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 16, 2008, 09:11:48 am »

I already included the Schema owner window in ODBC connection window

5

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 16, 2008, 08:57:19 am »

currently i've all required permissions in the schema

6

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 16, 2008, 08:33:38 am »

I'm trying to import oracle 9.1, I tried ORACLE ODBC DRIVER and Microsoft ODBC for Oracle, but still I am not able to import all datatypes. just varchar(255). Default DBMS is Oracle,

7

General Board / Re: Import Oracle DB schema from ODBC (datatype is

« on: January 16, 2008, 08:29:31 am »

I've changed the drivers, but still i am getting the same datatype , is there any other checks i need to do?

8

General Board / Import Oracle DB schema from ODBC (datatype issue)

« on: January 15, 2008, 03:19:19 pm »

Hi

while i am importing a an oracle schema into a diagram, all the datatypes generating as varchar(255). can anyone help me to sort this issue?