关于bcp 问题,急啊,在本人电脑上可以,到了服务器就不行了,愁死我了!

[JACKYANQUN]

declare @parYear char(20),@parMonth char(20),@parTemDay datetime,@parPayroll char(10),@parKindS char(10)
set @parYear='2005'
set @parMonth='08'
set @parPayroll='%'
set @parKindS='%'
set @parTemDay=cast(ltrim(rtrim(@parYear))+'/'+ltrim(rtrim(@parMonth))+'/01'as datetime)
declare @parDay char(10)--此变量是为了确定当月的天数
select @parDay=datepart(day,dateadd(ms,-3,dateadd(mm,datediff(m,0,@parTemDay)+1,0)))

select a.No,a.Name,a.Sex,a.IDCardNo,a.InDate,a.Department,b.salary,b.OtherSupply,b.EatCost,b.InsuranceCost,b.Roomcost,b.ManageCost,
(b.salary+b.OtherSupply)as Total,(b.salary+b.OtherSupply-b.EatCost-b.InsuranceCost-b.ManageCost-b.roomcost) AS Payroll,
ltrim(rtrim(@parYear))+'/'+ltrim(rtrim(@parMonth))+'/01'as DateFrom,
ltrim(rtrim(@parYear))+'/'+ltrim(rtrim(@parMonth))+'/'+cast(@parDay as char(2)) as DateTo
into #temp3
from tblEmployee a inner join tblSal b on a.[No] = b.[No]
where a.no not in (select no from tblTaxtoHK) and b.Year=ltrim(rtrim(@parYear)) and b.Month=ltrim(rtrim(@parMonth))

select No,Name,Sex,(''''+IDCardNo) as IDCardNo,InDate,Department,Salary,OtherSupply,Total,EatCost,
(case when b.fldCriterionI>=a.payroll then 0 else a.payroll-b.fldCriterionI end)*b.fldTaxRateR-b.fldDeductI as fldTaxR,
InsuranceCost,ManageCost,Roomcost,(Total-EatCost-InsuranceCost-ManageCost-roomcost) AS Payroll,DateFrom,DateTo
into ##temp30
from #temp3 a,tblTaxCriterion b
where a.payroll >= b.fldIncomeFromI and a.payroll< b.fldIncomeToI
order by a.No

exec master..xp_cmdshell 'bcp "select * from ##temp30 order by [no]" queryout d:\saltax.xls -c -q -S"it_yanqun" -U"sa" -P""'

drop table #temp3
drop table ##temp30
end

为什么在我本人的电脑上面都可以转excel,到了服务器上就提示:sql state=s1000,nativeerror=0
error=[microsoft][odbc sqlserverdirver] odbcbcp/驱动程序版本不匹配.
我该怎么办啊?

[xyxfly]

Sqlsrv32.dll 和 Odbcbcp.dll .dll 不具有相同的版本。在客户端安装客户实用工具,然后重新启动应用程序。


http://topic.csdn.net/t/20040406/09/2930102.html
这类好象也没解决

[leongwong]

在客户端装个SQL的连接工具看看