sql server 2008 使用导入导出向导，从oracle 中导入数据（表）？？？？

when using asp and oracle 10g with OraOLEDB provider, we encounterd a weird problem that ADO connection cannot open oracle database.After a whole afternoon hard work, we found that it's caused by ORACLE_HOME system variable. When we set ORACLE_HOME system variable, everything is ok!Oh jesus!