My machine is win xp os with oracle 8 and mssql 2000 database.when i try to import data to mssql database from oracle through "Microsoft ODBC for oracle" get an error TNS name could not resolve,but few days before it was working fine.I can directly access the data from oracle db through SQl plus and "TOAD" software.Please give solutions