Problems with OPENQUERY parameters

, ,
1

We are migrating data from Adabas to Sql Server. My routine is ready where I’ve learnt from Machine Learning course . I’m having a trouble into the second advanced sql because It owns a input parameter. The Advanced Sql, without the input parameter works just fine.
If I type into the Test Input into the parameter CaeProcurado the value 20761, it gives me a error.

I just dont know whow to solve it

2

Hi Rohit,

even I am not familiar with Adabas, you should provide some more details about the error message itself as well as some version numbers for Adabas and SQL Server.
If possible, share the sql statement as well.

This might help other to provide you a solution for your issue.

Regards,
Holger