Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-02 : 08:33:39
|
| AnyIdea writes "Can anybody tell how to import a table with the text column from SQL Server 2000 to MySQL 4.0.17?I tried this using ODBC connection but got an error message saying, "Query-based Insertion or updating of BLOB values is not supported"." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-02 : 08:35:34
|
| That is probably due to the ODBC driver you're using for MySQL. Another driver may work for you. Take a look here:http://www.sqlsummit.com/ODBCVend.htmAlso consider using an OLE DB provider for MySQL (if there is one), it will probably work better. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
DTS problem with TEXT column import to MySQL Database HELP!