Welcome to LEAD Support Forum Login | Register | Faq  

    LEAD Support Forum
  Resource to find answers and post technical questions about LEAD products.
Search    
   

Re: How to work with image data within as SQL Server Stored Procedure
Started by Dan@Southern at 01-23-2009 12:01. Topic has 1 replies.

Print Search « Previous Thread Next Thread »
  01-23-2009, 12:01
Dan@Southern is not online. Last active: 2/13/2009 9:05:51 PM Dan@Southern

Not Ranked
Joined on 01-22-2009
Posts 1
How to work with image data within as SQL Server Stored Procedure
Reply Quote
I have images stored in a SQL Server Image column using the proprietary .cmp format.  I need to provide these images to third party apps directly from the database, but it needs to be in a .jpg format.  I was hoping I could make a call from within a stored procedure, using sp_OACreate and the other compainion system procs to work with the Lead dll's directly, to convert the image and then return it using a binary column in a temp table.

I have the following versions available to me:

15 Raster Imaging Pro (API, C++ and .NET classes)
14 Raster Imaging Pro (API)
11.5 Imaging (No API - ActiveX and VCL only)


   Report 
  01-25-2009, 9:27
Adam Boulad is not online. Last active: 12/15/2009 10:50:44 AM Adam Boulad



Top 10 Posts
Joined on 09-16-2007
Posts 1,125
Re: How to work with image data within as SQL Server Stored Procedure
Reply Quote

Dan,
You will need 2 things:
1. A way to retrieve the binary data of the CMP image into a memory buffer
2. Away to call any of our LEADTOOLS functions from within your stored procedures and pass that memory buffer to our functions.

If you figure out these 2 steps, you should be able to read the image from memory and save it to memory in any format, including JPEG.


Adam Boulad
LEADTOOLS Technical Support

   Report 
Post
LEAD Support Fo... » Developer » Database » Re: How to work with image data within as SQL Server Stored Procedure

Powered by Community Server, by Telligent Systems