Geek asks and answers

A large varchar field throws a "Requested conversion is not supported" error using openquery with a connected MySQL server

I am trying to migrate a table from MySql to MSSQL using openquery, but I keep getting the following error message:

OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].description" from OLE DB provider "MSDASQL" for linked server "MYSQL".

The SQL query I'm trying to run is:

insert into dbo.tickets (id, description, createdAt)
select * from openquery(MYSQL, 'select * from mydb.tickets')

Since openqueryI already copied a couple of tables, but this trick deceived me.

On either side of the database field description varchar(8000). There is no line in MySql where the description is null and the longest description is only 5031 characters.

I tried to create a new view in MySql with the same data structure, but got the same error. I cannot determine which row has an invalid description field because the table contains more than 65,000 rows.

SQL, OutOfMemoryException Management Studio. sql-dumped 60 .

?

!

+3
2

, TEXT MySql MSSQL.

+4

, CAST(field as char(4000)) .

MySQL 5.1 :

create table tmp_patrick (summary_text varchar(4096));
insert into tmp_patrick values ('foo');

SQL Server 2008 R2 SP1 (10.50.2500), 64- MySQL ODBC, 5.1, 5.2w:

select * from openquery(MYSQL, 'select summary_text from scratch.tmp_patrick')

:

OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].summary_text" from OLE DB provider "MSDASQL" for linked server "MYSQL".

CAST:

select * from openquery(MYSQL, 'select CAST(summary_text as char(4000)) from scratch.tmp_patrick')

. char (4001).

, 4000 .

+8

More articles:


All Articles