I am getting value from this server
select *from OPENROWSET('SQLNCLI',
'server=abc.xxx.x.xx;Uid=xyz;Pwd=#####;
database=[db];
Persist Security Info=False',
'select * from AlahlidbN.dbo.mstudent') as GetContractFromERP
where GetContractFromERP.IsSent=0
Now i want to transfer records to Mysql stored procedure through linked server in MSSQL server
I am using like this.
What I have tried:
select *from OPENROWSET('SQLNCLI',
'server=abc.xxx.x.xx;Uid=xyz;Pwd=#####;
database=[db];
Persist Security Info=False',
'select * from AlahlidbN.dbo.mstudent') as GetContractFromERP
where GetContractFromERP.IsSent=0
Exec ('call mobileapp.sp_GetStudentContractFromERP('''''+GetContractFromERP.stdID+''',"GetContractFromERP.type","GetContractFromERP.text","GetContractFromERP.Msg","GetContractFromERP.show","GetContractFromERP.StdOne")')
at LINKED