Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Connection fine when testing during setup but doesn't work in ASP code
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