I am trying out Toad DataModeller to see if it fits our company. I have stumbled into one problem that I need to resolve. SInce this is a trial can’t I use Quest support (I guess) so I try this forum instead.
When I try to do a reveres enginering of a database can’t I use the native client sice it wont find the tnsname.ora. The log gives me the following reason: 'Assumed oracle home path: c\tnsnames.ora. ’
This is strange since tnsnames.ora is never placed directly under c: Our clients is pointed out in the registry and I have also add the environment key TNS_ADMIN. Even if I place a tnsnames.ora on C: will it not work since the assumed directory is c without :
Toad for Oracle will find the tnsnames.ora file without any problems but TDM will not. The TCP/IP connection works fine.
According to the Release notes:
Reverse engineering, connection method and tnsnames.ora file: TDM3 follows global system variable or registry key tns_admin and then, when there is no such variable or key, searches for the tnsnames.ora in the install directory.
I have tried it all…