Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Exclamation Unanswered: Importing MySQL BLOB to MSSQL

    Hi all!
    I'm trying importing a MySQL database to my MSSQL server. I've donwloaded the MySQL ODBC drivers and I can connect succesfully throught a DSN to my MySQL server. Everything works fine EXEPT my BLOB field. I'm using a BLOB field for storing a binary file.

    When I choose preview while importing my bob field is empty.

    I'm desperate!

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Viewing a BLOB is pretty much a waste of time. Use DTS or a linked server to move it, and life should be good.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts