ODBC Magento SQL

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
dbmkt
Posts: 1
Joined: Sun 23 Apr 2017 20:29

ODBC Magento SQL

Post by 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.

MaximG
Devart Team
Posts: 1024
Joined: Mon 06 Jul 2015 11:34

Re: ODBC Magento SQL

Post by 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.

Post Reply