March 21, 2016 at 8:32 am
Hi, i am trying to use CLR to make integration task, by this i create a dll in c# with several function this dll work fine on other way to invoke, this dll use web service to CRUD data,
the problem is when i invoke the function to execute integration task.
This is the way i exec the function.
Declare @server varchar(max) = 'DHUESPED-PC\SQLEXPRESS',
@Database varchar(max) = 'dbccu',
@Usuario varchar(max) ='sa',
@Clave varchar(max) = '$i130961735',
@wQuery varchar(MAx) = QUOTENAME('select * from Usuario for xml path(','''' )+'usuario'+QUOTENAME('), type, Elements','''' )
select QUOTENAME(@Server,'''' ),QUOTENAME(@Database,'''' ),QUOTENAME(@Usuario,'''' ),QUOTENAME(@Clave,'''' ),@wQuery
declare @var nvarchar(max) = dbo.fnConsultar(QUOTENAME(@Server,'''' ),QUOTENAME(@Database,'''' ),QUOTENAME(@Usuario,'''' ),QUOTENAME(@Clave,'''' ),@wQuery)
select @var
Different Message error raised by function execution.
1. Unable to connect to the remote server.
2. The operation has timed out.
Message error at webservice
1, Verify the server and instance name and check that no firewall is blocking UDP trafic to port 1434.
with firewall turned of continue raising same error.
i am using SQLEXPRESS 2012
March 21, 2016 at 9:09 am
What is CRL?
March 21, 2016 at 9:35 am
CLR
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply