This query gets no errors
Select *
FROM openquery(MLT_MAGENTO,'Select *
from SalesOrders s where s.updated_at >= ''2017-04-22''')
This query returns an error.
[Devart][ODBC][Magento]Error accessing web service. Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes)
Msg 7350, Level 16, State 2, Line 14
Cannot get the column information from OLE DB provider "MSDASQL" for linked server
Select *
FROM openquery(MLT_MAGENTO,'Select *
from SalesOrders s where s.updated_at >= ''2017-04-22'' and s.updated_at <= ''2017-04-23''')
I am not sure what is going on.
ODBC Magento SQL
Re: ODBC Magento SQL
The "Allowed memory size" error is not related to using our driver, but to specific settings of Magento itself. These settings depend on the environment in which you are using this Web Service. That is why we could not reproduce the described problem in our test environment, as well as the exact setting parameters values of Magento. However, we can provide you a complete list of these parameters values of our environment if it is needed. In our test environment we use Magento Community Edition 1.9.2.0, Apache 2.4.12, and MySQL 5.6.25, PHP 5.5.26.