Out of memory error during insertion of data in database

Question

chaitali laulkar on 26 Nov 2015

0
Link

Direct link to this question

https://in.mathworks.com/matlabcentral/answers/257655-out-of-memory-error-during-insertion-of-data-in-database

Answered: Chad on 7 Sep 2017

I am trying to establish database connectivity with MS Access in matlab using ODBC connection. Got success in connectivity. For first 2-3 times I got success in inserting data.Then i changed datatype of some of the fields of my table in MS access and accordingly changed query in matlab code, but now it is giving error ' out of memory' while inserting data. please help .

I have tried same again by creating another table in same database with 2 field. It is not giving error now inserting but giving same error when i am trying to execute 'Select * from t2' query.

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answer 1

Chad on 7 Sep 2017

0
Link

Direct link to this answer

https://in.mathworks.com/matlabcentral/answers/257655-out-of-memory-error-during-insertion-of-data-in-database#answer_280698

Responding to a 2 year old issue, but I can also replicate this issue. The problem comes when tables have varchar(max) as a column type. changing this to varchar(1000) fixes my issue, but opens up possible issues later on. Also switching to a JDBC connection while still using varchar(max) fixed the problem as well. Only the ODBC connection was an issue.