SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Froot r gewd SubKamran's Avatar
    Join Date
    May 2002
    Location
    North Star State
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error - BLOB data

    I'm almost at the virge of importing my mySQL tables to my SQL Server, but I get 3 errors...all the same.

    What is this?

    Code:
    Cannot instantiate Storage Object for source column 3 ('pets') Blob data.
    Multiple step OLE DB operation generated errors. Check each OLE DB Status value, if available. No work was done.
    The 3 errors are all the same, but with different columns having problems...

    The row for that specific one is EMPTY, and it's field type is 'text,' there are about 114 rows with the same value (i.e. nothing). It's an empty table except for the blank rows. Only the 'id' field is filled in for each

    In detail:

    Code:
    For table 'Users_Misc'
    
    Fields:
    
    user_id      | autonumber
    pets         | text
    reasons_nbti | text
    ***Some others***
    
    Values for ALL 114 rows:
    
    *auto_id*
    NULL
    NULL
    Etc Etc
    If I can fix this, I have successfully transfered my mySQL database to my SQL Server database!
    "Sometimes little is more."
    Kamran A
    Web Dev/Designer
    Keyboard not found: Please Press F1 to Continue

  2. #2
    Froot r gewd SubKamran's Avatar
    Join Date
    May 2002
    Location
    North Star State
    Posts
    597
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


    I still can't figure it out...I turned on 'NULL' but it doesn't make a difference...

    I don't really even know what the error means...how come it doesn't do it to every field that has a data type of 'TEXT'?
    "Sometimes little is more."
    Kamran A
    Web Dev/Designer
    Keyboard not found: Please Press F1 to Continue


Bookmarks

Posting Permissions

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