Re: :ODBC fails, SQL*Plus works

Scott Stansbury <[email protected]> Wed, 5 Oct 2011 15:59:43 -0400

Newsgroups	gmane.comp.lang.perl.modules.dbi.general
Message-ID	<[email protected]>

On Oct 5, 2011, at 1:47 PM, Kong, Alan wrote:
> 
> It is different than typing the whole connection description in the command prompt as it will bypass tnsnames.ora entry. ODBC is looking for the tnsnames.ora entry for connection description, so using the above connection method, I bet it will fail also.  If this is the case, that means your tnsnames.ora entry is somehow corrupted by the unknown characters.  What I am usually do is to type the tnsnames.ora entry manually, it should fix your problem.
>  
> Hope this is the case.


It appears that was a contributing factor. Thanks for your help!

Scott...