2 Replies Latest reply: Aug 21, 2014 5:51 AM by abdelmalek khettouf RSS

    [Error] Did not recognize connector reply

      Hi all,


      I'm stuck with a loading issue


      I built a table under SQL Server that containts instructions (SQL queries) for data loading on QV,


      On my QV application I browse the table and execute each instruction


      One of my instructions is trying to load ~ 300 fields


      If I run directly the query in SQL Server Management Studio it perfectly works, when I'm trying to load the same under QV I have this error message (cf. image below)




      Have anyone faced the same problem before?


      Thanks a lot

        • Re: [Error] Did not recognize connector reply
          Pradip Sen

          Could you upload the script?

            • Re: Re: [Error] Did not recognize connector reply

              Hello, below the script


              N.B : for some confidentiality reasons I've changed some parameters, but it's not a big deal


              OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database;Data Source=Sever;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ID;Use Encryption for Data=False;Tag with column collation when possible=False];



              LOAD ID,







              SQL SELECT *

              FROM "GENERIC".dbo."GENERATOR";


              let nb_process=fieldvaluecount('ID');

              trace nb_process:$(nb_process);


              let my_user=QVUser();


              for a=0 to $(nb_process)-1

                let my_id=peek('ID',$(a),'process');

                let my_process=peek('Process',$(a),'process');

                let my_load=peek('Load',$(a),'process');

                trace $(my_load);

                let my_instruction=peek('Instruction',$(a),'process');

                trace $(my_instruction);

                let my_target_qvd=peek('Target_QVD',$(a),'process');

                trace $(my_target_qvd);



              load $(my_load);



              trace process over;

              let count_row=NoOfRows('data');

              store data into $(my_target_qvd);

              drop table data;


              let curr_process=$(a)+1;

              trace processed :$(curr_process) out of  $(nb_process);