SQL1822N Unexpected error code "-1700.F" received from data source "Excel
Wrapper". Associated text and tokens are "General non-recoverable COM error".
SQLSTATE=560BD
显示数据不全,一旦达到一定量后 就会报错退出. 大家看看是什么错误.谢谢了!
连接方式如下:
CREATE WRAPPER Excel LIBRARY 'db2lsxls.dll' ;
CREATE SERVER biochem_lab WRAPPER Excel ;
CREATE NICKNAME NICK1 (A Varchar(40), B Varchar(40), C Varchar(40), D Varchar(40), E Varchar(40), F Varchar(40), G Varchar(40), H Varchar(40), I Varchar(40), J Varchar(40)
, K Varchar(40), L Varchar(40), M Varchar(40), N Varchar(40), O Varchar(40), P Varchar(40), Q Varchar(40), R Varchar(40), S Varchar(40), T Varchar(40),
U Varchar(40), V Varchar(40), W Varchar(40), X Varchar(40), Y Varchar(40), Z Varchar(40), AA Varchar(40), AB Varchar(40), AC Varchar(40), AD Varchar(40),
AE Varchar(40), AF Varchar(40), AG Varchar(40), AH Varchar(40), AI Varchar(40), AJ Varchar(40), AK Varchar(40), AL Varchar(40), AM Varchar(40), AN Varchar(40),
AO Varchar(40), AP Varchar(40), AQ Varchar(40)) FOR SERVER biochem_lab OPTIONS (FILE_PATH 'C:CompoundMaster.xls')
收起