Sorry about this but after seeing the forum names, my request better fits here then in the SQL 2000 forum.

I need to copy a bunch of tables from a Oracle DB to a SQL 2000 DB. My problem is is that I can't figure out how to make a connection to the Oracle DB. I'm trying to use the DTS Import/Export Wizard in Enterprise Manager with Microsoft OLE DB Provider for Oracle.

Could someone lead me or tell me how this is done? Here's the TNS name that I use with Toad if it helps..

========
ORACWEB.WAFLINK.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = titan.waflink.com)(PORT = 3500))
    )
    (CONNECT_DATA = (SID = ORACWEB)(SERVER = DEDICATED))
  )
=========

 BTW, no matter what I try for the server name, I get the error "ORA-125641: TNS:no listener"

Thanks!!

try creating a linkserver to oracle using the oracle provider.


Jaime E. Maccou