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

In article <7ed5e93a.0307150620.7378ac44 (AT) posting (DOT) google.com>,
hypermommy (AT) comcast (DOT) net says...
components:

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

-- Tom