1.用ado指向本地盘的xls文件:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/a.xls;Extended Properties=EXCEL 8.0;Persist Security Info=False
2.接着在ado中执行
select sqrq as 申请日期,dw1 as 申报单位,dw2 as 用料单位,wzbm as 物资编码,wzmc as 物资名称,xhgg as 规格型号,cazh as 材质,jldw as 计量单位,lsjg as 历史价格,spjg as 参考价格,bid_flag as 是否招标,class as 物资类别,sqjg as 申请单价,sqsl as 申请数量,je as 合计金额,dhqx as 到货期限,jh_name as 计划性质,yt_name as 用途,jhq as 计划期,xmh as 项目号,xmmc as 项目名称,cd_name as 产地,bz as 备注 into [sheet1] from table IN [odbc] [odbc;Driver=SQL Server;UID=user;PWD=user;Server=data;DataBase=test;]
如果单独写一个程序,这样执行通过,在d盘生成一个a.xls文件,内容是从数据库中提出的数据。
但是改写为isapi的dll文件,显示odbc连接错误,不能连接到sql server data.
这是什么原因
在windows2003 server下正常,在winnt4 ,windows 2000 server 下显示sql server连接不上的错误。
大侠帮助.