Oracle Database Discussions

When I tried to use Oracle ODBC 32bit test, I got the error
"SQLState: 08001
Native error code: 12154
Driver Message:[Microsoft][ODBC Driver for Oracle] [Oracle]ORA-12154: TNS: could not resolve service name"

When I tried to link the database in Access, I got the same error
"ODBC - call failed. [Microsoft][ODBC Driver for Oracle][Oracle]ORA-12154: TNS: could not resolve service name (#12154)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnetAttr failed IM006 0
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnetAttr failed (#0)"

When I go to to CMD, and type in "tnsping myserver.ewincite", I got the error "TNS-03505: Failed to resolve name".

The weird thing is when I go to SQL Plus and type in the same user id, password and myserver.ewincite as the Host String, I could get in successfully.

This used to work before, the only thing I did recently was installing MDAC 2.8, and I did have wireles network connection problem, but it is fixed now.

I did have more than 1 TNSNames.ora.
I have it in c:\orawin95\network\admin, c:\orawin95\network\admin\sample, and c:\oracle8win\network\admin, and c:\oracle8win\network\admin\sample.
I renamed all of them except the one in c:\oracle8win\network\admin. I also rename all the sqlnet.ora except the one in c:\oracle8win\network\admin, but still get the same error.

This is my TNSNames.ora:
MYSERVER.EWINCITE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYSERVER.EWINCITE)
)
)

This is my SQLNET.ORA:
NAMES.DEFAULT_DOMAIN = ewincite.com
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Please let me know what I can do to fix it. Thank you so much.