MySQL Forums
Forum List  »  Connector/ODBC

Data extraction from mysql Ver 8.0.32 for Linux on x86_64
Posted by: Bruce Young
Date: February 28, 2024 12:49AM

Hi all,

any ideas on a resolution.

I am linking data from a mysql database into a SQL Server database.

On the SQL Server side I get:
Starting PROCEDURE [sugar].[sp_CDR_refresh_sugar_CQU_APPLICATION_CSTM] at Feb 28 2024 4:11PM
Msg 7347, Level 16, State 1, Procedure sugar.sp_CDR_refresh_sugar_CQU_APPLICATION_CSTM, Line 31 [Batch Start Line 0]
OLE DB provider 'MSDASQL' for linked server 'SUGARCRM' returned data that does not match expected data length for column '[MSDASQL].cqu_event_id_c'. The (maximum) expected data length is 72, while the returned data length is 68.

Completion time: 2024-02-28T16:12:24.4722260+10:00

Bogus error as 68 is smaller than 72, yet the error suggests its too big.

On the mysql side I see that that column is only 36 at maximum. Now 72 is fine as there can be differences.
mysql> select max(char_length(cqu_event_id_c)) from cqu_application_cstm;
| max(char_length(cqu_event_id_c)) |
| 36 |
1 row in set (2.41 sec)

But how do I get the data accross?

Options: ReplyQuote

Written By
Data extraction from mysql Ver 8.0.32 for Linux on x86_64
February 28, 2024 12:49AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.