帮忙找个错,是关于存储过程的

[smilegw]

创建存储过程如下:
create procedure up_gw
@sqlselect varchar(1000),
@server varchar(20),
@path varchar(20),
@user varchar(10),
@pass varchar(10)
as
declare @sql varchar(1000)
set @sql = 'bcp @sqlselect queryout @path -c -t, -S@server -U@user -P@pass'
EXEC master..xp_cmdshell @sql
GO
执行命令如下:
exec up_datedown 'SELECT * FROM ylbx..ts_zzry
WHERE ylbx..ts_zzry.dwbh =001','tf-server','c:\temp\text.txt','sa','sa'

然后提示错误:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
NULL


高手指点

[wzh1215]

又是动态执行：试试下面的
create procedure up_gw
@sqlselect varchar(1000),
@server varchar(20),
@path varchar(20),
@user varchar(10),
@pass varchar(10)
as
declare @sql varchar(1000)
set @sql = 'bcp @sqlselect queryout @path -c -t, -S @server -U @user -P @pass'
set @sql='EXEC master..xp_cmdshell '+@sql
exec sp_executesql @sql
,N'@sqlselect varchar(1000),@path varchar(20),@server varchar(20),@user varchar(10),@pass varchar(10)',@sqlselect,@path,@server,@user
GO