Forum Discussion
EL-WAKIL
Sep 18, 2022Copper Contributor
Correct the Code
Hello ,
Would you please correct the code as I am receiving the below error :
select * from openquery(DRUPAL,'select o.* from (select max(vid), nid from content_type_irb_application_form group by nid) i inner join content_type_irb_application_form o on o.nid = i.nid and o.vid = i.vid')
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select o.* from (select max(vid), nid from content_type_irb_application_form group by nid) i inner join content_type_irb_application_form o on o.nid = i.nid and o.vid = i.vid" for execution against OLE DB provider "MSDASQL" for linked server "DRUPAL".
olafhelper Thank you for the response; I have solved the issue.
- olafhelperBronze Contributor
Re: Correct the Code
EL-WAKIL , how could one with that less on information and without having your enviroment to test it?
What's that for a linked server for?
Can you access that server directly?
Olaf
- EL-WAKILCopper Contributor
olafhelper Thank you for the response; I have solved the issue.