April 15, 2011 at 5:11 pm
I'm trying to query a MySQL database via a SQL2008 linked server and am getting the following error:
OLE DB provider "MSDASQL" for linked server "DENEB" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.26]MySQL client ran out of memory".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT * FROM sitescape.SS_ChangeLogs" against OLE DB provider "MSDASQL" for linked server "DENEB".
My query is as follows:
SELECT * FROM OPENQUERY(DENEB, 'SELECT * FROM sitescape.SS_ChangeLogs')
I can successfully query ANY individual columns from the MySQL source table above with the exception of one which, I'm pretty sure, is defined in the MySQL table as a "longtext". This is probably similar to MSSQL's "ntext" or "text". Even querying just the longtext column alone generates the error.
I need to be able to query the table in it's entirety in effort to bring the MySQL table into a SQL Server equivalent. Any ideas of what I can do to beat/circumvent the error?
The MySQL source table is about 150k rows. I don't
April 16, 2011 at 1:12 am
Have you tried a non-odbc driver to get the data? Is the mysql db on the same server? Have you get the error after a longer time?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 18, 2011 at 8:32 am
Have you tried a non-odbc driver to get the data? Is the mysql db on the same server? Have you get the error after a longer time?
Thank you for your response.
To answer your questions:
No, I hav not tried a different driver to get the data. All data that isn't defined as longtext comes across fine. It's just that one data type.
The data is not on the same server.
I do not understand your third question.
April 18, 2011 at 9:24 am
The third question was, whether you get the error after a longer time of execution.
Have you tried to cast the longtext column to nvarchar? Or create a view in mysql and convert it to another datatype?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 18, 2011 at 9:24 am
The third question was, whether you get the error after a longer time of execution.
Have you tried to cast the longtext column to nvarchar? Or create a view in mysql and convert it to another datatype?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply