Oracle Database Discussions

Hi All,

I've been trying to chase this problem down for over a month now and I have had no luck. When I try to connect to an Oracle server through MS Access I get the TNS: No Listener error. The kicker is when I go to the odbc data source administrator in windows I am able to connect to the oracle server. My computer is windows 2007 and I have Oracle 11.2 installed. Could anyone assist?

When I type lsnrctl start in the command prompt it says it has been already started.

Here is my tnsnames.ora:

ORMANRPT.WORLD=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=bspz1565.bhdc.att.com)
(PORT=1521)
)
(CONNECT_DATA=
(SID=ORMANRPT)
)
)

Here is my sqlnet.ora:

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
names.default_domain=world

here is my listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\cb260e\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\cb260e\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\cb260e