Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Connection fine when testing during setup but doesn't work in ASP code

Re: ODBC Connection fine when testing during setup but doesn't work in ASP code

From: Hypermommy <hypermommy_at_comcast.net>
Date: 15 Jul 2003 11:57:10 -0700
Message-ID: <7ed5e93a.0307151057.5b62677d@posting.google.com>


hypermommy_at_comcast.net (Hypermommy) wrote in message news:<7ed5e93a.0307150620.7378ac44_at_posting.google.com>...
> Hi all,
>
> Hope you can give me a hint of what to be looking for here. We've got
> an Oracle ODBC connection that we just set up this morning and it
> works fine when you click on the "test connection" button on one of
> the setup screens. However, when I attempt to use this ODBC
> connection in my ASP code, I get an
> "ORA-12154: TNS:could not resolve service name" error. We were
> getting that yesterday when we were incorrectly trying to set up the
> ODBC connection, but we don't get that anymore during setup and, in
> fact, get a successful test of connection. Except for when I try to
> use it.....
>
> Thanks in advance for any and all avenues of investigation you can
> give me.
>
> Denise

Hi all... found the answer. Turns out that the ODBC connection didn't save properly after we'd tested it. Saved it right and problem gone. Thanks anyway. Received on Tue Jul 15 2003 - 13:57:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US