Post reply

Store picture files in a data base

  • June 13, 2004 at 2:04 am

    #180387

    Hi

     

    I have 1200 picture files (.jpg) in my hard disk and i want to store them in a sql table , the target raw was declared as  picture type

     

    how can i import them ?

     

    I really appreciate your help

     

    regards

     

    Ricardo

  • June 14, 2004 at 2:07 am

    #510218

    Hi,

    Following link got how to store image in database.

    You can make a loop and store all images in one shot.

    http://www.databasejournal.com/features/mssql/article.php/1443521

    regards

    - sudhir

  • June 14, 2004 at 3:33 am

    #510228

    I tried that, but it could not find textcopy. I am getting error as

    'textcopy' is not recognized as an internal or external command,

    operable program or batch file.

    NULL

     

    Any help on where to find out 'Textcopy' would be appreciated.

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • June 14, 2004 at 4:40 am

    #510232

    Hallo

    It seems to be that the textcopy.exe is not installed in sqlserver.  You can see this file in sql2000 CD.   Just copy this file into your binn directory and try it again...

    Best regards

     

    Joseph

     

     

  • June 16, 2004 at 1:45 am

    #510593

    Joesph,

    Textcopy is installed, the problem was path was not set properly. Now I have set path correctly. It is working fine now.

    Anyhow thanks for your reply

     

     

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • June 30, 2004 at 11:54 pm

    #512800

    i tried but i receive this error

    ERROR: Text or image pointer and timestamp retrieval failed.

    any idea?

    regards

Viewing 6 posts - 1 through 5 (of 5 total)

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