Home » questions » How can I insert picture to and select picture from SQL server database using VBscript?

How can I insert picture to and select picture from SQL server database using VBscript?

3
2006-08-09 20:23:14, Category: Programming & Design
I tried to insert picture to a column in my SQL Server database, and the picture name could not be found in the database after insertion and i tried to select but it select nothing. How do I name my Table column and so on. I have used the Insert and Select Statements.

Answers

  1. Terminator

    On 2006-08-16 08:29:49


    It won't work like u said database is not for holding pics, it just allow datas that means the path of the pic so just try to add the URL of the pic to the concern place

  2. weida

    On 2006-08-13 00:12:49


    You may use the access query tool "Advanced Access Builder" at http://www.download5000.com/page25449.aspx or http://www.dlkj.net/sqlBuilder , it allows you to visually build complete SQL scripts.

  3. tep

    On 2006-08-09 21:45:45


    Maybe the properties of the column you made is not a BLOB. Make it a BLOB... I hope this will work out for you...