MySQL Bugs: #15771: Can't tranfer image from MSSQL 2000 to MYSQL 4.1 with DTS en MYODBC 3.51.12

Bug #15771	Can't tranfer image from MSSQL 2000 to MYSQL 4.1 with DTS en MYODBC 3.51.12
Submitted:	15 Dec 2005 10:26	Modified:	28 May 2013 12:43
Reporter:	Eric Vansteelandt	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51.12	OS:	Windows (WINDOWS SERVER 2003)
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I've a problem using MSSQL 2000 DTS, to transfer data to a MYSQL Database. The problem concern long text and binary data.

I've à table under MSSQL with an image type field.
In the MySQL Database, the type of this fields is Blob.

When i use DTS to transfer data, it say to me that long texte and blob can't be transfer. 

I found exactly similar problem (with MYSQL 3.23.55) on forums, but i didn't found solution to resolve ma problem !

I downloaded le latest version of MYODBC driver (3.51.12), but no result !

can anyone help me ! 

Eric Vansteelandt
eric.vansteelandt@banque-bpsd.fr

How to repeat:
I've a problem using MSSQL 2000 DTS, to transfer data to a MYSQL Database. The problem concern long text and binary data.

I've à table under MSSQL with an image type field.
In the MySQL Database, the type of this fields is Blob.

When i use DTS to transfer data, it say to me that long texte and blob can't be transfer.

Sorry...I was not able to reproduce the bug. Could you please write here table definition what you try to transfer ?

Hi,

Here is the script (MSSQL 2000) of my table 

/*==============================================================*/
/* Table : EDITSIG                                              */
/*==============================================================*/
create table EDITSIG (
COGERB               numeric(7)           not null,
SIGIMG               image                null,
constraint PK_EDITSIG primary key  (COGERB)
)
go

Here is the script (MYSQL 4.1) of my table

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Lundi 19 Décembre 2005 à 09:06
-- Version du serveur: 4.1.14
-- Version de PHP: 4.3.10
-- 
-- Base de données: `bpsd_test`
-- 

CREATE TABLE editsig (
  COGERB decimal(7,0) NOT NULL default '0',
  SIGIMG mediumblob,
  PRIMARY KEY  (COGERB)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
        
When i try to match fields between the two tables in DTS PACKAGE MSSQL2000 via the ODBC Driver 3.51.12, there is no error, but 
when i execute the DTS package, i obtain this message :

	"Query based insertion or updating of BLOB values is not supported"
	
I tried a test changing the type of my field : mediumblob --> tinyblob and the DTS package was executed successfully. If the type size exeeds 255 characters, my DTS package will not work...

When i try to search with google the message : "Query based insertion or updating of BLOB values is not supported"
i see that the problem is referenced by some user but i they don't found solution !

Thanks you for your help !

By !

PS : Sorry for my english quality !

Images do get stored via ODBC client (server log with GIF picture).

Attachment: 15771.txt (application/x-download, text), 2.37 KiB.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.