Post reply

Adding/Uploading a file to an IMAGE column in SQL Server 2005

  • June 13, 2006 at 3:00 pm

    #366381

    Hi,

    I'm a real newbie to SQL Server...Could someone please help me how to add/upload a file to an IMAGE column ? Im looking for a tool feature where the user can upload a file directly to the database (not using code).

    Thanks.

  • June 14, 2006 at 5:47 am

    #643600

    I don't think you can do that without code.  You have to convert the file contents to a some sort of binary stream, depending on your application code.  How you do thiswill depend on your application (desktop or web based) and how you connect to the database (ODBC, JDBC, ADO, Ado.Net etc.).



    Mark

  • June 14, 2006 at 6:19 am

    #643609

    Thanks Mark.

    I managed to upload a file in a simple script using OPENROWSET.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply