- Thu May 16, 2013 2:08 pm
#62477
Hi,
In my MSSQL 2008 R2 installation I have a "linked server" linked to to my "IBM DB2 for i"(AS400) . It works perfectly.
...but running sql statement via executeQuery function it doesn't work.
I received this error:
select cdarma , dsarma from openquery (i5 , 'select cdarma , dsarma from mgart00f fetch first 10 rows only')exception 'SQLException' with message 'Could not execute query [Native Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.]' in C:\Program Files (x86)\Zend\processmaker\gulliver\thirdparty\creole\drivers\mssql\MSSQLConnection.php:174 Stack trace: #0 C:\Program Files (x86)\Zend\processmaker\workflow\engine\classes\class.pmFunctions.php(246): MSSQLConnection->executeQuery('select cdarma ,...') #1 C:\Program Files (x86)\Zend\processmaker\workflow\engine\plugins\prova\provaApplication3.php(44): executeQuery('select cdarma ,...', '30313110350b5f9...') #2 C:\Program Files (x86)\Zend\processmaker\workflow\public_html\sysGeneric.php(680): require_once('C:\Program File...') #3 {main}
Same sql instruction works in MSSQL. Who can help me to go deep into this in order to fix this issue?
Thanks.
Regards,
Daniele
In my MSSQL 2008 R2 installation I have a "linked server" linked to to my "IBM DB2 for i"(AS400) . It works perfectly.
...but running sql statement via executeQuery function it doesn't work.
I received this error:
select cdarma , dsarma from openquery (i5 , 'select cdarma , dsarma from mgart00f fetch first 10 rows only')exception 'SQLException' with message 'Could not execute query [Native Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.]' in C:\Program Files (x86)\Zend\processmaker\gulliver\thirdparty\creole\drivers\mssql\MSSQLConnection.php:174 Stack trace: #0 C:\Program Files (x86)\Zend\processmaker\workflow\engine\classes\class.pmFunctions.php(246): MSSQLConnection->executeQuery('select cdarma ,...') #1 C:\Program Files (x86)\Zend\processmaker\workflow\engine\plugins\prova\provaApplication3.php(44): executeQuery('select cdarma ,...', '30313110350b5f9...') #2 C:\Program Files (x86)\Zend\processmaker\workflow\public_html\sysGeneric.php(680): require_once('C:\Program File...') #3 {main}
Same sql instruction works in MSSQL. Who can help me to go deep into this in order to fix this issue?
Thanks.
Regards,
Daniele