SQL Server Performance

Insert image into image col for Access

Discussion in 'General Developer Questions' started by ginoitalo, Apr 1, 2004.

  1. ginoitalo New Member

    I've inserted images into an sql table (image col) to view the image from an Access form

    This inserts the image successfully but Access doesn't display the picture:

    textcopy.exe /S myDesktop /U sa /P pass /D salesPeople /T tblImage /C personImage /W "WHERE ID = 001" /F c:picsguy.jpg /I /Z

    the Access error when double clicking the image container
    "a problem occurred while access data project was communicating with the ole server or activex control....restart the ole server...try again"

    If I insert the image directly from my Access form, it works like a charm.

    What seems to be the problem ?

  2. satya Moderator

  3. ginoitalo New Member

    Yes, Norton 2003

    I'm interested in why you ask ....
  4. ginoitalo New Member

    The Issue seems to be this:

    Added with Access, the data in the column is shown as:
    "Microsoft 3.0 photo editor photo"

    Added with TextCopy.exe, the data in the column is shown as:
    "Long Binary Data"

    So how do you get Access to display "Long Binary Data" as a picture

    I have no idea.
  5. satya Moderator

  6. destroyer New Member

    I am not able to insert an image in to sql server 2005 and frontend is c#.net.
    Plz help me........[:'(]
  7. FrankKalis Moderator

Share This Page