Start=>run=>cmd
now do a "lsnrctl status" if doesn't look good then do a "lsnrct start". In
addition to this check the services see if it is running.
Robert
"Srinivas" <pabbathi_at_yahoo.com> wrote in message
news:ee91da38.0203070803.4ae1f5dd_at_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 - 14:49:29 CST
