Mike P Ready wrote: > Group- > Okay, this is probably a really dumb one but I haven't run into this before. > I just moved to a new project group and took over an existing PC which has > two OracleHomes (d:\Oracle\Ora81 or c:\Oracle\Ora81) one can switch between. > I installed Active State Perl 5.6.1 build 629, DBD-Oracle 1.06 and DBI 1.14. > When I attempt to run a program (using either Oracle Home), I get an error > at the connect string line - e.g. for line 29 below
OK, there is a registry setting that determines which ORACLE_HOME it looks in for the tnsnames.ora to resolve the alias. do you have the home selector installed? it would be with the universal installer. use that to switch between the homes. also it's not a real good idea to have both homes listed in the path. well, it's not on unix anyway, that's where i run my databases. -- -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] ------------------------------------------------------------------------ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ------------------------------------------------------------------------ IBM: Ideas Bring Money
