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

    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
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP

Posting Permissions

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