hi, guys,

need help desperately. I have an Oracle 8i v. 8.1.5.0.0 on Windows NT. I have a front-end application written in C accessing it through Microsoft ODBC for Oracle. I always get the error "ORA-12154 TNS could not resolve service name" whenever I connect to the database using the Microsoft ODBC driver. I have already setup my Tnsnames.ora using Net8 Assistant and is as follows:

EPPIC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnow)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EPPIC)
)
)

I've tried using Tnsping and I get the error "TNS-03505: Failed to resolve name".

Using the same service name, "EPPIC", I am able to connect to the database using Oracle ODBC Driver. I am really at a loss here.

The Microsoft ODBC driver for Oracle I am using is v. 2.273.6526.00, while the Oracle ODBC driver version is 8.01.05.00.

Thanks for replying to this query.
.