ODBC Magento SQL

ODBC Magento SQL

Postby dbmkt » Sun 23 Apr 2017 20:35

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.
dbmkt
 
Posts: 1
Joined: Sun 23 Apr 2017 20:29

Re: ODBC Magento SQL

Postby MaximG » Fri 28 Apr 2017 11:57

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.
MaximG
Devart Team
 
Posts: 745
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers