ODBC connection failed

[Guest]

I cannot establish an ODBC connection. I am using Microsoft ODBC for Oracle
driver 2.573.9090.00 MSORCL32.DLL Apr 19, 2004.
The error is:
ORA-12514: TNS listener does not currently know of service requested in
connect descriptor (-1)
I looked at the Oracle listener.log file, it looks like it is confusing the
SERVICE_NAME with the HOST, at least these two entries are reversed in the
TNSNAMES file. Also, it fails to show the SERVER = DEDICATED parameter. Any
ideas?

 

[Guest]

Here are the error messages in the sqlnet.log file:

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=igsaaaegdbmrds2.er.usgs.gov)(CID=(PROGRAM=C:\Program
Files\FileMaker\FileMaker Developer 7\FileMaker
Developer.exe)(HOST=IGSAAAHMWSG306)(USER=pschrube)))(ADDRESS=(PROTOCOL=TCP)(HOST=130.11.48.206)(PORT=1521)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
10.1.0.2.0 - Production
Time: 24-MAR-2006 08:06:06
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0


***********************************************************************
Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
Files\FileMaker\FileMaker Developer 7\FileMaker
Developer.exe)(HOST=IGSAAAHMWSG306)(USER=pschrube))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.2.0
- Production
Time: 24-MAR-2006 08:06:06
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0