导入dbf文件到sql server 2000 问题?
我用:
my_sql = 'SET ANSI_NULLS ON '
execute immediate :my_sql;
my_sql = 'SET ANSI_WARNINGS ON '
execute immediate :my_sql;
my_sql='SET MSDASQL ON '
execute immediate :my_sql;
my_sql="select * into "+ls_name1+" from openrowset('msdasql','Driver=Microsoft Visual FoxPro Driver;SourceDB="+ls_path+"\xssfdbf文件;SourceType=DBF','select * from "+ls_name1+".DBF')"
execute immediate :my_sql;
把一个dbf 文件导入到数据库中.(连接本地的服务器可以但是联机异地的服务器就不可一),错误是我的这条 select .................有错误.
为什么,是异地的服务器设置问题,还是这条语句这异地的服务器不能用