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

In article <7ed5e93a.0307150620.7378ac44_at_posting.google.com>, hypermommy_at_comcast.net says...
> 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
>

What does your ASP connection string look like? Here are the basic components:

"Provider=MSDASQL.1;Persist Security Info=False;Data Source=Name_Of_DSN;User ID=USERNAME;Password=PASSWORD;"

• Tom