generic connectivity: ORA-12541

From: Srinivas <pabbathi_at_yahoo.com>
Date: 7 Mar 2002 08:03:28 -0800
Message-ID: <ee91da38.0203070803.4ae1f5dd@posting.google.com>

Oracle Gurus,

I am having trouble connecting to a SQL Server 2000 database from Oracle 8.1.7 (on Windows 2000) using generic connectivity.

These are my configurations on the 8.1.7 server -

tnsnames.ora

Entry1 = (Description =
(address = (protocol=tcp)(host=entry1)(port=1521))
(connect_data=(sid=Entry1))(HS=ok)

)

listener.ora

sid_list_listener=
(sid_list =
(sid_desc =
(program=hsodbc)
(sid_name=entry1)
(oracle_home=f:\oracle\ora81)

)

initentry1.ora in $oracle_home\hs\admin\

hs_fds_connect_info = entry1
hs_fds_trace_level = OFF
hs_fds_trace_file_name = NONE

I have a DSN called Entry1 pointing to the SQL Server 2000 that I want to connect to.

When I "TNSPING ENTRY1"

I get the error - TNS-12541: TNS:no listener

What did I do wrong to cause this error?

srinivas Received on Thu Mar 07 2002 - 10:03:28 CST