在SPLUS中直接连接SQLSERVER 2005,例子如下
> insurdur<-importData(type="direct-sql",user="sa", password="sa" ,server="crserver", table="insur_dur" ,database="death");
> insurdur
insur.dur name
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 Z Z
需要注意的是,如果在运行importData函数导入时报告如下错误:
Problem in openOrImportData(file = file, type = typ..: Error -1 returned when opening data source '' for reading.
Internal error message was 'Cannot load library: STDBSQLS.DLL:'.
Use traceback() to see the call stack
则表明您正在运行的机器没有装上相应的SQLSERVER客户端软件或者您已经装上SQLSERVER客户端软件但版本不一致。我当前的客户机环境为SQL2000 CLIENT.