Oracle Database Discussions

Hi, I am trying to set up a link from oracle 8.1.7 to sql2000 on different win2000 servers.

I have set up an ODBC connection and if I test this with MS Access on same machine as Oracle server I am able to link to tables on SQL server.
This ODBC connection only works if I use port 1433.

Then I edited tnsnames.ora & listener.ora in Oracle_Home/network/admin

192.168.15.7 is ip of sql machine and redrouter is sql sid name, when i try tnsping I get:
TNS-1254: TNS:no listener



ODS1SERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.34)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ods1)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ODS2)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ODS2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ODS2)
)
)

REDROUTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = redrouter)
)
(HS = OK)
)




LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = jambor-1)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ODS2)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = ODS2)
)
(SID_DESC =
(SID_NAME = redrouter)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM=hsodbc)
)
)

Any help?? Do I need to have SQL2000 client installed on Oracle Server machine??