SQL Server Performance Forum – Threads Archive

Can anyone Help me?

Hi All,
When i was trying to Export Data From MS-Sql to MySql Using DTS, i get very strange error like,
"Query based insertion or updating of BLOB values is not Supported"
I have senn so many peoples are struggling with this problem. So kindly help us. Please…
Can anyone help in this regards? Thanks

Do you have the latest sql service pack and mdac versions?
Do you have a unique index on the mysql destination table?

Does MySQL support BLOB type? Madhivanan Failing to plan is Planning to fail

Yes! —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

hi
i dont have created mysql tables manually and so it is not indexed. Mysql will definitly support BLOB. So what would be the problem?

Since you are exporting to MySQL, check out their website, if you can find something useful. Also, see if this helps:http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Put a unique index on the mysql table and see if it helps. Can be something how the cursor is built up and then a unique row identifier can help.

]]>