Inserting images into SQL7 using VB6

Posted on 2006-03-27
Last Modified: 2008-02-01
I am trying to insert (and retrive) image into SQL Server 7.

I have found some examples of how to do this, however it seems I need aTypeLib that I cannot find....  typelib with the IStream and IPersistStream Interfaces
Any idea where I can dload this??

Or an alternate method for insertng my images with Sample code?

Question by:ExtremeFitness
    LVL 28

    Accepted Solution

    LVL 2

    Author Comment


    Now do you know if there is a way I can insert the pic from the DB directly to an Imgbox or picbox etc???
    LVL 28

    Expert Comment

    Yes. After opening the recordset set the PictureBox's Datasource and DataField:

    Set Picture1.Datasource = rs
    Picture1.DataField = "YourFieldName"
    LVL 2

    Author Comment


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now