Hi to all, I'm trying to create a remote view in SQL Server, this is my SELECT

SELECT Domicilios.idDomicilio, LTRIM(Domicilios.bairro) AS colonia,;
  LTRIM(Individuo.nome_individuo) AS nombre, Domicilios.idCidade,;
  Cidade.descricao AS ciudad,;
  LTRIM(Domicilios.logradouro) AS direccion;
 FROM ;
     dbo.Domicilios Domicilios ;
    INNER JOIN dbo.Cidade Cidade ;
   ON  Domicilios.idCidade = Cidade.idCidade ;
    INNER JOIN dbo.Paineis_Domicilios Paineis_domicilios ;
   ON  Domicilios.idDomicilio = Paineis_domicilios.idDomicilio ;
    INNER JOIN dbo.Individuo Individuo ;
   ON  Domicilios.idDomicilio = Individuo.idDomicilio;
 WHERE ( ( (  LEFT(Domicilios.iddomicilio,1) = ( ?Codigo_Pais );
   AND  Paineis_domicilios.Causa_Saida IS NULL );
   AND  Individuo.idIndividuo = ( 1 ) );
   AND  IIF(IsEmpty(?cCodigo_Ciudad),Domicilios.idCidade!="99999999",Domicilios.idCidade = ( ?cCodigo_Ciudad )) );
   AND  Domicilios.Bairro LIKE ( ?cNombre_colonia );
 ORDER BY 3, Domicilios.idDomicilio

But I keep getting errors from the SQL ODBC Driver. I use to create Local Views using IIF() in the where Clause without problem, why I can't in a Remote View?.
Thanks
Luis Navas