Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2001
    Location
    chennai
    Posts
    21

    Unanswered: insert image

    hii
    Use an exe called textcopy.exe in the binn directory of the MSSQL server root directory. and pass parameters to it.
    this will insert an image.
    it should be an jpg or a bmp image
    K.Ramakrishnan
    Chennai

  2. #2
    Join Date
    Apr 2003
    Posts
    4

    more about image

    hii
    CAN YOU SAY MORE ABout creating exe file and passing parameters to it.i want to store an image with many other fieds as a row in the SQL server 2000

  3. #3
    Join Date
    Apr 2003
    Posts
    4

    more about image

    hii
    CAN YOU SAY MORE ABout creating exe file and passing parameters to it.i want to store an image with many other fieds as a row in the SQL server 2000
    please mail me at

    subyphilip@indiatimes.com

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, you can refer to TEXTCOPY file from C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\DBLib\ directory and also refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2003
    Location
    N Delhi
    Posts
    11
    Hi,
    I have tried textcopy.exe utility of DB Library.
    Its fine to copy images in and out of SQL Server.
    You can insert documents to a field (image or text) of table and as well can get back the same document using textcopy.exe.
    You can find more info about using textcopy.exe by looking at help. Just type textcopy /? at command prompt.

    Bye,

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, and also in BOOKS ONLINE too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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