How to work with image data within as SQL Server Stored Procedure

Options

View

Last

Unread

Previous Topic Next Topic

This topic and its replies were posted before the current version of LEADTOOLS was released and may no longer be applicable.

#1 Posted : Friday, January 23, 2009 6:56:48 AM(UTC)

Dan

Groups: Registered
Posts: 1

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)


	Try the latest version of LEADTOOLS for free for 60 days by downloading the evaluation: https://www.leadtools.com/downloads Wanna join the discussion? Login to your LEADTOOLS Support account or Register a new forum account.

#2 Posted : Sunday, January 25, 2009 4:22:00 AM(UTC)

Adam Boulad

Groups: Guests
Posts: 3,022

Was thanked: 2 time(s) in 2 post(s)

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.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.