Share
Report
5i use linked server in sql query and want to execute this query in dexterity 10. i use function executequery but it return error 7504. if i exlclude linked server from query then it run fine.
query is.
insert
into ddrtmp(employid,datedone,timein,timeout,dayclose)(
select
employeerefno,indate,intime,outtime,@dayclose as Dc
from "antiv-server".timeatd.dbo.Attendace_data
where indate between @dtfrom and @dtto and employeerefno = @empid
)
this command run on sql serve very well. but in dexterity it shows error.
*This post is locked for comments
All responses (
Answers (
