I'm converting 30 years of flat-file fixed-field data to Oracle 10g.
We have list of 450 data elements with basic characteristics like
datatype, length and description.
I'd like to populate an entity with these 450 attributes and then use
that entity to build my real entities. I've entered about 30 of these
attributes using the GUI interface and don't look forward to doing the
rest.
Is there an easy way to build that base Data_Elements entity in the
freeware version of Toad? Is this doable in the full version of Toad?
For Oracle (I don’t know what database you
work with) you can try to do the following:
1. change the string value in the key NLS_LANG in registry to
your local codepage (e.g. for korean language it must be changed to KOREAN_KOREA.KO16MSWIN949)
2. Do the RE via ADO
Regards,
Vaclav
From:
toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of kosharovsky Sent: Monday, September 04, 2006 9:07 AM To: toaddm@yahoogroups.com Subject: [toaddm] Reverse Engineering encoding problem
Hi!
Can't import a cyrillic comments of fields from database. I get a
question marks only. What I can do in this case?
To reverse engineer views please check the Load views check box
on tab „Settings“ of the „Reverse engineering“ dialog.
(Click File -> Reverse engineering -> Universal reverse engineering and
select from the “Execute script” combo box the MS SQL 2005 item).
Reverse engineered views will be stored among Text objects (Model -> Text objects).
Regards,
Vaclav
From:
toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of tom_eisen Sent: Friday, September 01, 2006 9:50 PM To: toaddm@yahoogroups.com Subject: [toaddm] Reverse Engineer SQL 2005 Views
This might not be the right forum for this, but
just in case...
I am currently using Case Studio (2.23), but could use The Toad Data
Modeler if necessary.
Have not been able to Reverse Engineer SQL 2005 Views (not the
tables), regardless of the provider or connection string I use.
We need to create ERD's based on the SQL 2005 Views as well as create
the relationships in the ERD.
Can Case Studio or Toad... do this, and if so how?
Really only two major limits to the freeware - no reverse engineering and not
more than 25 entities or tables. It's a great tool for doing little one-off
projects or limited scope modeling efforts. If you need more (say more than 25
entities) - then it's time to consider purchasing the commerical version - which
is very reasonably priced. It comes with one years maintenance - which includes
all upgrades being free and live support (can call and talk to a person, not
just email support).
-----Original Message-----
From: toaddm@yahoogroups.com on behalf of Morten Nielsen
Sent: Sun 9/3/2006 3:24 AM
To: toaddm@yahoogroups.com
Subject: [toaddm] Can't save
Hi
I have a problem with the free version.
Sometimes it seems to lock up and refuse me to save my changes, is
this some kind of limitation in the free version or me doing something
wrong?
Hi
I have a problem with the free version.
Sometimes it seems to lock up and refuse me to save my changes, is
this some kind of limitation in the free version or me doing something
wrong?
This might not be the right forum for this, but just in case...
I am currently using Case Studio (2.23), but could use The Toad Data
Modeler if necessary.
Have not been able to Reverse Engineer SQL 2005 Views (not the
tables), regardless of the provider or connection string I use.
We need to create ERD's based on the SQL 2005 Views as well as create
the relationships in the ERD.
Can Case Studio or Toad... do this, and if so how?
Thanks!
Hi T, that's correct, the submodeling is only availalble in the commercial version. Ramon
From: toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of rellafella74 Sent: Tuesday, August 29, 2006 1:20 PM To: toaddm@yahoogroups.com Subject: [toaddm] SubModel
Hi,
Does any know if it is possible to have submodels in the freeware version of Toad Data Modeler? I can't seem to get it to work, so I'm assuming it's not available.
Hi,
Does any know if it is possible to have submodels in the freeware
version of Toad Data Modeler? I can't seem to get it to work, so I'm
assuming it's not available.
Thanks,
T
Hello Joe,
Thanks very much for letting us know the result. We're happy to hear
that the trouble has been solved.
In case of any problems or questions on TDM please feel free to
write us. Our team is fully at your disposal.
All your suggestions and recommendations will be also greatly
appreciated. Thanks for them in advance.
Have a nice day.
Kind regards,
Vladka & TDM Team
>
> Vladka,
> I had to reinstall the latest scripting update from Microsoft, but
that
> did the trick. Thanks to you, Bert and the development team for
such
> speedy resolution!
>
> Joe
>
>
> Joseph Wheeler
> (404) 526-7359
>
>
>
>
> "vladka" <vladimira.nitrova@...>
> Sent by: toaddm@yahoogroups.com
> 08/28/2006 06:49 AM
> Please respond to
> toaddm@yahoogroups.com
>
>
> To
> toaddm@yahoogroups.com
> cc
>
> Subject
> [toaddm] Re: Reverse Engineer Error
>
>
>
>
>
>
>
>
>
> Hello Joe and Bert,
>
> Thanks for all the information, it helped us a lot. Here I'm with
> possible solution to the trouble.
>
> The problem points to the line:
> var CheckList = new ActiveXObject("Scripting.Dictionary");
>
> It seems that the TDM is not able to create the scripting object
> Dictionary. The Scripting::Dictionary object is an object that is
> part of the Microsoft Scripting Runtime Library (scrrun.dll). So
> this trouble can occur e.g. if Microsoft Scripting Runtime Library
> is missing or is not registrated on your computer or if its
> registration is wrong, or if the library version is old.
>
> Please try to use the following command that should registrate the
> scrrun.dll library on your computer:
>
> regsvr32 scrrun.dll
>
> You can execute this command via Start > Run. Then press Enter.
>
> If the registration is finished successfully, please restart
Windows
> OS and try the reverse engineering feature in TDM once again.
>
> If the registration fails or if you have an older version of the
> scrrun.dll library on your computer or don't have it at all,
please
> download and install the latest Scripting update from Microsoft
site
> via the links below:
>
> * For Windows XP and Windows 2000:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C717D943-
> 7E4B-4622-86EB-95A22B832CAA&displaylang=en
>
> * For other Windows versions:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=0A8A18F6-
> 249C-4A72-BFCF-FC6AF26DC390&displaylang=en
>
> Please let our team know if the problem is solved then. Thanks
very
> much in advance.
>
> Vladka & Toad Data Modeler Developers Team
>
> >
> > Great feedback - thanks. I think you've found a bug - so the
> developers will need to assist here. They're in Europe - so it's
the
> weekened already for them. So will have to wait till they're back
> online Monday (Sunday night our time) .....
> >
> > As for the export - I mean an Oracle schema export of the tables
> minus the data using exp. That way we can see if it's an object
type
> or something else we did not account for that special in your
> database. Will also need your init.ora (spfile) settings and your
> client NLS setting.
> >
> > Finally, on that last screen, you only need to check use tcp/ip
> and provide data if you want to connect from a machine directly
> (i.e. without going through client installed libs). So for example
I
> never check this box - but that's an FYI, I don't think it caused
> your error.
> >
> > So if you can email that export file to bert.scalzo@ - I will
> get it into the right hands. Thanks and have a good weekened :)
> >
> > Bert
> >
> >
> > -----Original Message-----
> > From: toaddm@yahoogroups.com on behalf of Joe Wheeler
> > Sent: Fri 8/25/2006 3:20 PM
> > To: toaddm@yahoogroups.com
> > Subject: RE: [toaddm] Reverse Engineer Error
> >
> > Responses below. Please let me know if you need any further
> information.
> >
> > Thanks,
> > Joe
> >
> >
> > Joseph Wheeler
> > (404) 526-7359
> >
> >
> >
> >
> > "Bert Scalzo" <bert.scalzo@>
> > Sent by: toaddm@yahoogroups.com
> > 08/25/2006 11:31 AM
> > Please respond to
> > toaddm@yahoogroups.com
> >
> >
> > To
> > <toaddm@yahoogroups.com>
> > cc
> >
> > Subject
> > RE: [toaddm] Reverse Engineer Error
> >
> >
> >
> >
> >
> >
> > Couple of background questions:
> >
> > 1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
> > Oracle 9.2.0.5.0
> >
> > 2. What version client installed on PC - same level of detail
> please
> > Client is 9.2.0.1.0
> > 3. Can you send an export file minus the data so we can try to
> recreate
> > Export file of the table, or export file from Toad Data Modeler?
> If you
> > mean from Toad DM, I haven't been able to successfully complete
> the
> > reverse engineer process, so I don't have anything to export.
> > 4. any special user defined database object types or anything
else
> special
> > being used
> >
> > 5. did you choose all the following:
> > - main menu -> reverse engineering -> universal reverse
> engineering Yes
> > - on the RE screen
> > - execute script 9i (essentially tell us it's a 9i database) Yes
> > - connection via Native ODAC (not using ODBC or ADO) Yes
> > - two wrenches button to specify the SID and Oracle Home Yes
> >
> >
> >
> > See my screen snapshot for example of what I'm asking ....
> >
> > Bert
> >
> > -----Original Message-----
> > From: toaddm@yahoogroups.com on behalf of Joe
> > Sent: Fri 8/25/2006 10:21 AM
> > To: toaddm@yahoogroups.com
> > Subject: [toaddm] Reverse Engineer Error
> >
> > When attempting to reverse engineer an Oracle 9i database using
> the
> > Toad Data Modeler trial version, I receive the following error:
> >
> > Source: Microsoft JScript runtime error
> > Template Oracle 9i_main
> > Description: Automation server can't create object
> > Line 1147
> > Column 2
> >
> > Ideas or suggestions? I'm not logged in as DBA, but wouldn't
think
> > that would be necessary for this.
> >
> > I like the overall look and feel of the product, but if I can't
> > reverse engineer I don't see as large a need to purchase the
> product.
> > Any assistance that you could give on this would be greatly
> > appreciated.
> >
> > Thanks,
> > Joe
> > .
> >
>
Great news - and glad to be of service. Keep us posted on your progress. We're planning for new features going forward, so any input you have about anything you'd like to see added would be useful :)
From: toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of Joe Wheeler Sent: Monday, August 28, 2006 6:14 AM To: toaddm@yahoogroups.com Subject: Re: [toaddm] Re: Reverse Engineer Error
Vladka, I had to reinstall the latest scripting update from Microsoft, but that did the trick. Thanks to you, Bert and the development team for such speedy resolution!
Joe
Joseph Wheeler (404) 526-7359
"vladka" <vladimira.nitrova@quest.com> Sent by: toaddm@yahoogroups.com
08/28/2006 06:49 AM
Please respond to toaddm@yahoogroups.com
To
toaddm@yahoogroups.com
cc
Subject
[toaddm] Re: Reverse Engineer Error
Hello Joe and Bert,
Thanks for all the information, it helped us a lot. Here I'm with possible solution to the trouble.
The problem points to the line: var CheckList = new ActiveXObject("Scripting.Dictionary");
It seems that the TDM is not able to create the scripting object Dictionary. The Scripting::Dictionary object is an object that is part of the Microsoft Scripting Runtime Library (scrrun.dll). So this trouble can occur e.g. if Microsoft Scripting Runtime Library is missing or is not registrated on your computer or if its registration is wrong, or if the library version is old.
Please try to use the following command that should registrate the scrrun.dll library on your computer:
regsvr32 scrrun.dll
You can execute this command via Start > Run. Then press Enter.
If the registration is finished successfully, please restart Windows OS and try the reverse engineering feature in TDM once again.
If the registration fails or if you have an older version of the scrrun.dll library on your computer or don't have it at all, please download and install the latest Scripting update from Microsoft site via the links below:
Please let our team know if the problem is solved then. Thanks very much in advance.
Vladka & Toad Data Modeler Developers Team
> > Great feedback - thanks. I think you've found a bug - so the developers will need to assist here. They're in Europe - so it's the weekened already for them. So will have to wait till they're back online Monday (Sunday night our time) ..... > > As for the export - I mean an Oracle schema export of the tables minus the data using exp. That way we can see if it's an object type or something else we did not account for that special in your database. Will also need your init.ora (spfile) settings and your client NLS setting. > > Finally, on that last screen, you only need to check use tcp/ip and provide data if you want to connect from a machine directly (i.e. without going through client installed libs). So for example I never check this box - but that's an FYI, I don't think it caused your error. > > So if you can email that export file to bert.scalzo@... - I will get it into the right hands. Thanks and have a good weekened :) > > Bert > > > -----Original Message----- > From: toaddm@yahoogroups.com on behalf of Joe Wheeler > Sent: Fri 8/25/2006 3:20 PM > To: toaddm@yahoogroups.com > Subject: RE: [toaddm] Reverse Engineer Error > > Responses below. Please let me know if you need any further information. > > Thanks, > Joe > > > Joseph Wheeler > (404) 526-7359 > > > > > "Bert Scalzo" <bert.scalzo@...> > Sent by: toaddm@yahoogroups.com > 08/25/2006 11:31 AM > Please respond to > toaddm@yahoogroups.com > > > To > <toaddm@yahoogroups.com> > cc > > Subject > RE: [toaddm] Reverse Engineer Error > > > > > > > Couple of background questions: > > 1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6) > Oracle 9.2.0.5.0 > > 2. What version client installed on PC - same level of detail please > Client is 9.2.0.1.0 > 3. Can you send an export file minus the data so we can try to recreate > Export file of the table, or export file from Toad Data Modeler? If you > mean from Toad DM, I haven't been able to successfully complete the > reverse engineer process, so I don't have anything to export. > 4. any special user defined database object types or anything else special > being used > > 5. did you choose all the following: > - main menu -> reverse engineering -> universal reverse engineering Yes > - on the RE screen > - execute script 9i (essentially tell us it's a 9i database) Yes > - connection via Native ODAC (not using ODBC or ADO) Yes > - two wrenches button to specify the SID and Oracle Home Yes > > > > See my screen snapshot for example of what I'm asking .... > > Bert > > -----Original Message----- > From: toaddm@yahoogroups.com on behalf of Joe > Sent: Fri 8/25/2006 10:21 AM > To: toaddm@yahoogroups.com > Subject: [toaddm] Reverse Engineer Error > > When attempting to reverse engineer an Oracle 9i database using the > Toad Data Modeler trial version, I receive the following error: > > Source: Microsoft JScript runtime error > Template Oracle 9i_main > Description: Automation server can't create object > Line 1147 > Column 2 > > Ideas or suggestions? I'm not logged in as DBA, but wouldn't think > that would be necessary for this. > > I like the overall look and feel of the product, but if I can't > reverse engineer I don't see as large a need to purchase the product. > Any assistance that you could give on this would be greatly > appreciated. > > Thanks, > Joe > . >
Vladka,
I had to reinstall the latest scripting
update from Microsoft, but that did the trick. Thanks to you, Bert
and the development team for such speedy resolution!
Joe
Joseph Wheeler
(404) 526-7359
"vladka" <vladimira.nitrova@...> Sent by: toaddm@yahoogroups.com
08/28/2006 06:49 AM
Please respond to
toaddm@yahoogroups.com
To
toaddm@yahoogroups.com
cc
Subject
[toaddm] Re: Reverse Engineer Error
Hello Joe and Bert,
Thanks for all the information, it helped us a lot. Here I'm with
possible solution to the trouble.
The problem points to the line:
var CheckList = new ActiveXObject("Scripting.Dictionary");
It seems that the TDM is not able to create the scripting object
Dictionary. The Scripting::Dictionary object is an object that is
part of the Microsoft Scripting Runtime Library (scrrun.dll). So
this trouble can occur e.g. if Microsoft Scripting Runtime Library
is missing or is not registrated on your computer or if its
registration is wrong, or if the library version is old.
Please try to use the following command that should registrate the
scrrun.dll library on your computer:
regsvr32 scrrun.dll
You can execute this command via Start > Run. Then press Enter.
If the registration is finished successfully, please restart Windows
OS and try the reverse engineering feature in TDM once again.
If the registration fails or if you have an older version of the
scrrun.dll library on your computer or don't have it at all, please
download and install the latest Scripting update from Microsoft site
via the links below:
Please let our team know if the problem is solved then. Thanks very
much in advance.
Vladka & Toad Data Modeler Developers Team
>
> Great feedback - thanks. I think you've found a bug - so the
developers will need to assist here. They're in Europe - so it's the
weekened already for them. So will have to wait till they're back
online Monday (Sunday night our time) .....
>
> As for the export - I mean an Oracle schema export of the tables
minus the data using exp. That way we can see if it's an object type
or something else we did not account for that special in your
database. Will also need your init.ora (spfile) settings and your
client NLS setting.
>
> Finally, on that last screen, you only need to check use tcp/ip
and provide data if you want to connect from a machine directly
(i.e. without going through client installed libs). So for example I
never check this box - but that's an FYI, I don't think it caused
your error.
>
> So if you can email that export file to bert.scalzo@... - I will
get it into the right hands. Thanks and have a good weekened :)
>
> Bert
>
>
> -----Original Message-----
> From: toaddm@yahoogroups.com
on behalf of Joe Wheeler
> Sent: Fri 8/25/2006 3:20 PM
> To: toaddm@yahoogroups.com
> Subject: RE: [toaddm] Reverse Engineer Error
>
> Responses below. Please let me know if you need any further
information.
>
> Thanks,
> Joe
>
>
> Joseph Wheeler
> (404) 526-7359
>
>
>
>
> "Bert Scalzo" <bert.scalzo@...>
> Sent by: toaddm@yahoogroups.com
> 08/25/2006 11:31 AM
> Please respond to
> toaddm@yahoogroups.com
>
>
> To
> <toaddm@yahoogroups.com>
> cc
>
> Subject
> RE: [toaddm] Reverse Engineer Error
>
>
>
>
>
>
> Couple of background questions:
>
> 1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
> Oracle 9.2.0.5.0
>
> 2. What version client installed on PC - same level of detail
please
> Client is 9.2.0.1.0
> 3. Can you send an export file minus the data so we can try to
recreate
> Export file of the table, or export file from Toad Data Modeler?
If you
> mean from Toad DM, I haven't been able to successfully complete
the
> reverse engineer process, so I don't have anything to export.
> 4. any special user defined database object types or anything else
special
> being used
>
> 5. did you choose all the following:
> - main menu -> reverse engineering -> universal reverse
engineering Yes
> - on the RE screen
> - execute script 9i (essentially tell us it's a 9i database) Yes
> - connection via Native ODAC (not using ODBC or ADO) Yes
> - two wrenches button to specify the SID and Oracle Home Yes
>
>
>
> See my screen snapshot for example of what I'm asking ....
>
> Bert
>
> -----Original Message-----
> From: toaddm@yahoogroups.com
on behalf of Joe
> Sent: Fri 8/25/2006 10:21 AM
> To: toaddm@yahoogroups.com
> Subject: [toaddm] Reverse Engineer Error
>
> When attempting to reverse engineer an Oracle 9i database using
the
> Toad Data Modeler trial version, I receive the following error:
>
> Source: Microsoft JScript runtime error
> Template Oracle 9i_main
> Description: Automation server can't create object
> Line 1147
> Column 2
>
> Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
> that would be necessary for this.
>
> I like the overall look and feel of the product, but if I can't
> reverse engineer I don't see as large a need to purchase the
product.
> Any assistance that you could give on this would be greatly
> appreciated.
>
> Thanks,
> Joe
> .
>
Hello Joe and Bert,
Thanks for all the information, it helped us a lot. Here I'm with
possible solution to the trouble.
The problem points to the line:
var CheckList = new ActiveXObject("Scripting.Dictionary");
It seems that the TDM is not able to create the scripting object
Dictionary. The Scripting::Dictionary object is an object that is
part of the Microsoft Scripting Runtime Library (scrrun.dll). So
this trouble can occur e.g. if Microsoft Scripting Runtime Library
is missing or is not registrated on your computer or if its
registration is wrong, or if the library version is old.
Please try to use the following command that should registrate the
scrrun.dll library on your computer:
regsvr32 scrrun.dll
You can execute this command via Start > Run. Then press Enter.
If the registration is finished successfully, please restart Windows
OS and try the reverse engineering feature in TDM once again.
If the registration fails or if you have an older version of the
scrrun.dll library on your computer or don't have it at all, please
download and install the latest Scripting update from Microsoft site
via the links below:
* For Windows XP and Windows 2000:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C717D943-
7E4B-4622-86EB-95A22B832CAA&displaylang=en
* For other Windows versions:
http://www.microsoft.com/downloads/details.aspx?FamilyId=0A8A18F6-
249C-4A72-BFCF-FC6AF26DC390&displaylang=en
Please let our team know if the problem is solved then. Thanks very
much in advance.
Vladka & Toad Data Modeler Developers Team
>
> Great feedback - thanks. I think you've found a bug - so the
developers will need to assist here. They're in Europe - so it's the
weekened already for them. So will have to wait till they're back
online Monday (Sunday night our time) .....
>
> As for the export - I mean an Oracle schema export of the tables
minus the data using exp. That way we can see if it's an object type
or something else we did not account for that special in your
database. Will also need your init.ora (spfile) settings and your
client NLS setting.
>
> Finally, on that last screen, you only need to check use tcp/ip
and provide data if you want to connect from a machine directly
(i.e. without going through client installed libs). So for example I
never check this box - but that's an FYI, I don't think it caused
your error.
>
> So if you can email that export file to bert.scalzo@... - I will
get it into the right hands. Thanks and have a good weekened :)
>
> Bert
>
>
> -----Original Message-----
> From: toaddm@yahoogroups.com on behalf of Joe Wheeler
> Sent: Fri 8/25/2006 3:20 PM
> To: toaddm@yahoogroups.com
> Subject: RE: [toaddm] Reverse Engineer Error
>
> Responses below. Please let me know if you need any further
information.
>
> Thanks,
> Joe
>
>
> Joseph Wheeler
> (404) 526-7359
>
>
>
>
> "Bert Scalzo" <bert.scalzo@...>
> Sent by: toaddm@yahoogroups.com
> 08/25/2006 11:31 AM
> Please respond to
> toaddm@yahoogroups.com
>
>
> To
> <toaddm@yahoogroups.com>
> cc
>
> Subject
> RE: [toaddm] Reverse Engineer Error
>
>
>
>
>
>
> Couple of background questions:
>
> 1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
> Oracle 9.2.0.5.0
>
> 2. What version client installed on PC - same level of detail
please
> Client is 9.2.0.1.0
> 3. Can you send an export file minus the data so we can try to
recreate
> Export file of the table, or export file from Toad Data Modeler?
If you
> mean from Toad DM, I haven't been able to successfully complete
the
> reverse engineer process, so I don't have anything to export.
> 4. any special user defined database object types or anything else
special
> being used
>
> 5. did you choose all the following:
> - main menu -> reverse engineering -> universal reverse
engineering Yes
> - on the RE screen
> - execute script 9i (essentially tell us it's a 9i database) Yes
> - connection via Native ODAC (not using ODBC or ADO) Yes
> - two wrenches button to specify the SID and Oracle Home Yes
>
>
>
> See my screen snapshot for example of what I'm asking ....
>
> Bert
>
> -----Original Message-----
> From: toaddm@yahoogroups.com on behalf of Joe
> Sent: Fri 8/25/2006 10:21 AM
> To: toaddm@yahoogroups.com
> Subject: [toaddm] Reverse Engineer Error
>
> When attempting to reverse engineer an Oracle 9i database using
the
> Toad Data Modeler trial version, I receive the following error:
>
> Source: Microsoft JScript runtime error
> Template Oracle 9i_main
> Description: Automation server can't create object
> Line 1147
> Column 2
>
> Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
> that would be necessary for this.
>
> I like the overall look and feel of the product, but if I can't
> reverse engineer I don't see as large a need to purchase the
product.
> Any assistance that you could give on this would be greatly
> appreciated.
>
> Thanks,
> Joe
> .
>
Great feedback - thanks. I think you've found a bug - so the developers will need to assist here. They're in Europe - so it's the weekened already for them. So will have to wait till they're back online Monday (Sunday night our time) .....
As for the export - I mean an Oracle schema export of the tables minus the data using exp. That way we can see if it's an object type or something else we did not account for that special in your database. Will also need your init.ora (spfile) settings and your client NLS setting.
Finally, on that last screen, you only need to check use tcp/ip and provide data if you want to connect from a machine directly (i.e. without going through client installed libs). So for example I never check this box - but that's an FYI, I don't think it caused your error.
So if you can email that export file to bert.scalzo@... - I will get it into the right hands. Thanks and have a good weekened :)
Bert
-----Original Message-----
From: toaddm@yahoogroups.com on behalf of Joe Wheeler
Sent: Fri 8/25/2006 3:20 PM
To: toaddm@yahoogroups.com
Subject: RE: [toaddm] Reverse Engineer Error
Responses below. Please let me know if you need any further information.
Thanks,
Joe
Joseph Wheeler
(404) 526-7359
"Bert Scalzo" <bert.scalzo@...>
Sent by: toaddm@yahoogroups.com
08/25/2006 11:31 AM
Please respond to
toaddm@yahoogroups.com
To
<toaddm@yahoogroups.com>
cc
Subject
RE: [toaddm] Reverse Engineer Error
Couple of background questions:
1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
Oracle 9.2.0.5.0
2. What version client installed on PC - same level of detail please
Client is 9.2.0.1.0
3. Can you send an export file minus the data so we can try to recreate
Export file of the table, or export file from Toad Data Modeler? If you
mean from Toad DM, I haven't been able to successfully complete the
reverse engineer process, so I don't have anything to export.
4. any special user defined database object types or anything else special
being used
5. did you choose all the following:
- main menu -> reverse engineering -> universal reverse engineering Yes
- on the RE screen
- execute script 9i (essentially tell us it's a 9i database) Yes
- connection via Native ODAC (not using ODBC or ADO) Yes
- two wrenches button to specify the SID and Oracle Home Yes
See my screen snapshot for example of what I'm asking ....
Bert
-----Original Message-----
From: toaddm@yahoogroups.com on behalf of Joe
Sent: Fri 8/25/2006 10:21 AM
To: toaddm@yahoogroups.com
Subject: [toaddm] Reverse Engineer Error
When attempting to reverse engineer an Oracle 9i database using the
Toad Data Modeler trial version, I receive the following error:
Source: Microsoft JScript runtime error
Template Oracle 9i_main
Description: Automation server can't create object
Line 1147
Column 2
Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
that would be necessary for this.
I like the overall look and feel of the product, but if I can't
reverse engineer I don't see as large a need to purchase the product.
Any assistance that you could give on this would be greatly
appreciated.
Responses below.
Please let me know if you need any further information.
Thanks, Joe
Joseph Wheeler
(404) 526-7359
"Bert Scalzo"
<bert.scalzo@...> Sent by: toaddm@yahoogroups.com
08/25/2006 11:31 AM
Please respond to
toaddm@yahoogroups.com
To
<toaddm@yahoogroups.com>
cc
Subject
RE: [toaddm] Reverse Engineer Error
Couple of background questions:
1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
Oracle 9.2.0.5.0
2. What version client installed on PC - same level of detail please Client is 9.2.0.1.0
3. Can you send an export file minus the data so we can try to recreate Export file of
the table, or export file from Toad Data Modeler? If you mean from
Toad DM, I haven't been able to successfully complete the reverse engineer
process, so I don't have anything to export.
4. any special user defined database object types or anything else special
being used
5. did you choose all the following:
- main menu -> reverse engineering -> universal reverse engineering
Yes
- on the RE screen
- execute script 9i (essentially tell us it's a 9i database)
Yes
- connection via Native ODAC (not using ODBC or ADO)
Yes
- two wrenches button to specify the SID and Oracle Home
Yes
See my screen snapshot for example of what I'm asking ....
When attempting to reverse engineer an Oracle 9i database using the
Toad Data Modeler trial version, I receive the following error:
Source: Microsoft JScript runtime error
Template Oracle 9i_main
Description: Automation server can't create object
Line 1147
Column 2
Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
that would be necessary for this.
I like the overall look and feel of the product, but if I can't
reverse engineer I don't see as large a need to purchase the product.
Any assistance that you could give on this would be greatly
appreciated.
Couple of background questions:
1. Oracle 9i - but specifically, what version (e.g. 9.2.0.6)
2. What version cleint installed on PC - same level of detail please
3. Can you send an export file minus the data so we can try to recreate
4. any special user defined database object types or anyhting else special being
used
5. did you choose all the following:
- main menu -> reverse engineering -> universal reverse engineering
- on the RE screen
- execute script 9i (essentially tell us it's a 9i database)
- connection via Native ODAC (not using ODBC or ADO)
- two wrenches button to specify the SID and Oracle Home
See my screen snapshot for example of what I'm asking ....
Bert
-----Original Message-----
From: toaddm@yahoogroups.com on behalf of Joe
Sent: Fri 8/25/2006 10:21 AM
To: toaddm@yahoogroups.com
Subject: [toaddm] Reverse Engineer Error
When attempting to reverse engineer an Oracle 9i database using the
Toad Data Modeler trial version, I receive the following error:
Source: Microsoft JScript runtime error
Template Oracle 9i_main
Description: Automation server can't create object
Line 1147
Column 2
Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
that would be necessary for this.
I like the overall look and feel of the product, but if I can't
reverse engineer I don't see as large a need to purchase the product.
Any assistance that you could give on this would be greatly
appreciated.
Thanks,
Joe
When attempting to reverse engineer an Oracle 9i database using the
Toad Data Modeler trial version, I receive the following error:
Source: Microsoft JScript runtime error
Template Oracle 9i_main
Description: Automation server can't create object
Line 1147
Column 2
Ideas or suggestions? I'm not logged in as DBA, but wouldn't think
that would be necessary for this.
I like the overall look and feel of the product, but if I can't
reverse engineer I don't see as large a need to purchase the product.
Any assistance that you could give on this would be greatly
appreciated.
Thanks,
Joe
does not do scripts in current version (must connect to the database) - but it's on our list for soemtime soon :)
-----Original Message-----
From: toaddm@yahoogroups.com on behalf of John Pocknell
Sent: Fri 8/25/2006 9:08 AM
To: toaddm@yahoogroups.com
Subject: [toaddm] Reverse Engineering from a Script
Hi,
I have a customer who wants to RE a PostgreSQL script into TDM to get
a visual representation of the objects. Is this possible or, in fact,
is it possible with other DDL scripts (Oracle, SQL Server, etc) ?
Excellent - thanks.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
>>> vaclav.frolik@... 08/25/06 03:29pm >>>
Hi Norman,
I see what you mean. Earlier, only checkboxes were available, but some
users wanted the CTRL and SHIFT selection functionality. You can
select
multiple tables using CTRL or SHIFT and then please right click the
selection. A new menu will appear. First three options are for the
highlighted tables, the other three options are for all tables.
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still
check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms and
conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
You can reverse engineer PostgreSQL, Oracle, SQL Server etc.
databases, however, the database must exist physically. Import for SQL script
is not available.
Note: RE features are only in the commerical version of Toad
Data Modeler.
Regards,
Vaclav
From:
toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of John
Pocknell Sent: Friday, August 25, 2006 4:09 PM To: toaddm@yahoogroups.com Subject: [toaddm] Reverse Engineering from a Script
Hi,
I have a customer who wants to RE a PostgreSQL script into TDM to get
a visual representation of the objects. Is this possible or, in fact,
is it possible with other DDL scripts (Oracle, SQL Server, etc) ?
I see what you mean. Earlier, only checkboxes were available,
but some users wanted the CTRL and SHIFT selection functionality. You can
select multiple tables using CTRL or SHIFT and then please right click the selection.
A new menu will appear. First three options are for the highlighted tables, the
other three options are for all tables.
Regards,
Vaclav
From:
toaddm@yahoogroups.com [mailto:toaddm@yahoogroups.com] On Behalf Of Norman
Dunbar Sent: Friday, August 25, 2006 3:55 PM To: toaddm@yahoogroups.com Subject: RE: [toaddm] My First Bug :o(
Hi Vaclav,
I've been testing further and I think there is a confusion (on my part
probably) :
The A button has a hint 'Select all' - this is fine and always works.
The D buttons's hint is 'Delete selection' - I think it should be
'Unselect all' as this is what it does.
The I button's hint is fine. (Invert selection)
However, the list box also allows entries to be highlighted using
click, shift+click and CTRL+click in the normal manner. My problem is
that having done a bit of development work, this indicates a selection
to me. I was assuming the I button would invert the selection and the D
button would remove the selected entries from the listbox - as per it's
current hint which is 'Delete selection'.
It's slightly confusing to have both a check option and a selection - I
think that the selection (highlighting of entries) should be removed and
only the checkboxes be allowed.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should
still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may
also be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms
and conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
Hi,
I have a customer who wants to RE a PostgreSQL script into TDM to get
a visual representation of the objects. Is this possible or, in fact,
is it possible with other DDL scripts (Oracle, SQL Server, etc) ?
Regards,
John
Hi Vaclav,
I've been testing further and I think there is a confusion (on my part
probably) :
The A button has a hint 'Select all' - this is fine and always works.
The D buttons's hint is 'Delete selection' - I think it should be
'Unselect all' as this is what it does.
The I button's hint is fine. (Invert selection)
However, the list box also allows entries to be highlighted using
click, shift+click and CTRL+click in the normal manner. My problem is
that having done a bit of development work, this indicates a selection
to me. I was assuming the I button would invert the selection and the D
button would remove the selected entries from the listbox - as per it's
current hint which is 'Delete selection'.
It's slightly confusing to have both a check option and a selection - I
think that the selection (highlighting of entries) should be removed and
only the checkboxes be allowed.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still
check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms and
conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
I’ve just tested the functionality
of the “I” button. It works OK. If everything is selected,
then the I button unselects everything, but if you select only few
tables and click the I button, then the selection will be inverted.
Regards,
Vaclav
Afternoon all,
When reverse engineering, I get a list of tables. I don't want to
include all of them, so I select a number and click the 'D' button to
delete seletion. It simply clears the ticks from all the tables (in
otherwords unselect all).
The 'I' button has a similar effect - it doesn't invert the selection,
but unselects everything.
The 'A' button is fine and does indeed 'select all'.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should
still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email messages
and attachments sent to or from any Environment Agency address may also be
accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms
and conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
Morning Vaclav,
>> Toad Data Modeler (TDM) allows you to reverse engineer a database
>> structure with hundreds of tables and there is also an "autolayout"
>> feature (Click Model->Layout->Autolayout),
Indeed, I know this as I have used it. Unfortunately, my auto arrange
output was 20 pages wide, one page deep and everything simply aligned
side by side. :o(
>> You can also add parts of your model into submodels
>> and save your layout (Model->Layout->Save).
I'll give this a try - soon.
>> Note: all reverse engineering features are
>> available in the commercial version, not the freeware version of
TDM.
I'm using the trial version at present - thanks.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still
check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms and
conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
Afternoon all,
When reverse engineering, I get a list of tables. I don't want to
include all of them, so I select a number and click the 'D' button to
delete seletion. It simply clears the ticks from all the tables (in
otherwords unselect all).
The 'I' button has a similar effect - it doesn't invert the selection,
but unselects everything.
The 'A' button is fine and does indeed 'select all'.
Cheers,
Norm. [TeamT]
Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.
Internal : 7 28 2051
External : 0113 231 2051
Information in this message may be confidential and may be legally privileged.
If you have received this message by mistake, please notify the sender
immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still
check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under
the Freedom of Information Act, Data Protection Act or for litigation. Email
messages and attachments sent to or from any Environment Agency address may also
be accessed by someone other than the sender or recipient, for business
purposes.
If we have sent you information and you wish to use it please read our terms and
conditions which you can get by calling us on 08708 506 506. Find out more
about the Environment Agency at www.environment-agency.gov.uk
--- In toaddm@yahoogroups.com, "normandunbar" <norman.dunbar@...>
wrote:
>
> --- In toaddm@yahoogroups.com, "Jesse, Rich" <Rich.Jesse@> wrote:
> >
> > First post!!!
> >
> > My Wish List for CASE--erm, Toad Data Modeler-- starts with good
> > integration between TDM and the traditional Toad, so I will no
longer
> > have to write my schema code in Toad, paste them into TDM's Text
> > Objects, have TDM generate the schema, then paste that text back
into
> > Toad for creation.
> >
> > Short and sweet and to-the point. Thanks!
> >
> > Rich -- [TeamT on the Toad for Oracle lists] :)
> >
>
> Mine is for a tool that can reverse engineer a database with
hundreds
> of tables, and still do a grand job of 'auto arrange'. However, I
feel
> that this is beyond most software on the market - except, perhaps,
> some of those extremely expensive circuit board designers that cost
> thousands of pounds every 6 months or so :o(
>
> Cheers,
> Norm. [TeamT Too]
>
Hi,
thanks for your suggestions! To your wishlist items:
- The integration with Toad is being planned.
- Toad Data Modeler (TDM) allows you to reverse engineer a database
structure with hundreds of tables and there is also an "autolayout"
feature (Click Model->Layout->Autolayout), which can help you to re-
arrange your entity-relationship diagram objects with respect
dependencies. You can also add parts of your model into submodels
and save your layout (Model->Layout->Save). If you reverse engineer
your database structure again, you can load your previously saved
layout and also submodels will be loaded. This may help you to keep
your model clear. Note: all reverse engineering features are
available in the commercial version, not the freeware version of TDM.
Regards,
Vaclav
--- In toaddm@yahoogroups.com, "Jesse, Rich" <Rich.Jesse@...> wrote:
>
> First post!!!
>
> My Wish List for CASE--erm, Toad Data Modeler-- starts with good
> integration between TDM and the traditional Toad, so I will no longer
> have to write my schema code in Toad, paste them into TDM's Text
> Objects, have TDM generate the schema, then paste that text back into
> Toad for creation.
>
> Short and sweet and to-the point. Thanks!
>
> Rich -- [TeamT on the Toad for Oracle lists] :)
>
Mine is for a tool that can reverse engineer a database with hundreds
of tables, and still do a grand job of 'auto arrange'. However, I feel
that this is beyond most software on the market - except, perhaps,
some of those extremely expensive circuit board designers that cost
thousands of pounds every 6 months or so :o(
Cheers,
Norm. [TeamT Too]
First post!!!
My Wish List for CASE--erm, Toad Data Modeler-- starts with good
integration between TDM and the traditional Toad, so I will no longer
have to write my schema code in Toad, paste them into TDM's Text
Objects, have TDM generate the schema, then paste that text back into
Toad for creation.
Short and sweet and to-the point. Thanks!
Rich -- [TeamT on the Toad for Oracle lists] :)