Find Jobs
Hire Freelancers

Need Microsoft Access OLE Header Strip Routine for SQL Server

$750-1500 USD

Completed
Posted almost 10 years ago

$750-1500 USD

Paid on delivery
Overview: I need a .NET CLR function written to interrogate and strip the Microsoft Access OLE image and package headers from binary data stored in SQL Server. Background: Microsoft Access allows for storage of image (PNG, JPEG, etc) as well as package data (eg MS Word documents) as binary text data in SQL server. I need to be able to retrieve this data from a web application outside of MS Access. This can be done by reading text or binary image data, scanning the OLE header and then parsing out the structured or image file behind the header. There are a lot of code snippets available out on the Internet that illustrate how this can be done. A good example can be reviewed here: [login to view URL] Requirements: I specifically need to be able to retrieve OLE stripped data from within SQL Server by way of a User Defined Function (UDF). The UDF will most likely need to be able to access the .NET CLR to achieve this. Sample solution T-SQL syntax: SELECT [login to view URL]([login to view URL]) FROM [login to view URL] The created UDF would call a .NET CLR function that would correctly parse the passed in data field myImage, determine its type (eg PDF or JPEG) and return a device independent bitmap or perhaps a standard PNG to be rendered to a web page bound picture control. One of the tricks here would be to generically interrogate the OLE header for a variety of stored types (eg JPEG, GIF, PDF, MS Word and a few others). This is tough to do because the OLE header can vary depending on the stored Access data package type. There are specs for the OLE header on the Internet and published by Microsoft.
Project ID: 5928986

About the project

18 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, Thanks for posting the detailed explanation of the project requirements. Very few buyers post their requirements in such a straightforward manner. As to the complexities involved, I think it's better to develop this CLR function in a modular way, whereby we can write ad-hoc identification and parsing logic for each content-type (JPG, PNG etc. in your case). It will make it easier to maintain the project in future, as and when there are new content types to be added to the CLR function, and also to mitigate any bugs or issues found within any particular image type. We can also use configuration files which can contain the unique identification bytes for each image type, based on which the CLR function can call the ad-hoc parser module to extract the image contents. We can develop this solution for you. We will also provide the full source code of the project along with copyright declaration. Please feel free to post a message if you have any questions. This is an interesting project and I look forward to have a chance to work on it. With best regards, Sachin Bhatt JSK Software
$1,000 USD in 10 days
5.0 (19 reviews)
5.5
5.5
18 freelancers are bidding on average $1,255 USD for this job
User Avatar
Hie. I got through requirements 2-3 times. I was trying to understand the requirements fully. I have understood now that what you really want. In short you want a udf in sql server which will take input as image binary data and will return a path of output png/bmp. The only difficult part here is OleHeader stripping. Well If this is possible, Then in am 99% confident that I can do it. I am confident also because I know image processing, udfs with CLR functions etc. If you give me a chance then i will prove my self. Thanks
$947 USD in 20 days
4.8 (141 reviews)
7.8
7.8
User Avatar
Hi, I have 9 years experience in C#, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web API and SQL Server for back-end. Involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have delivered highly successful projects in ASP.NET, VB.NET Win-Forms with complex logic in SQL Server Stored Procedures. Thanks
$1,333 USD in 20 days
4.9 (57 reviews)
6.7
6.7
User Avatar
Hello Deisner, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access and VBA to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,
$1,263 USD in 20 days
4.9 (21 reviews)
5.3
5.3
User Avatar
Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to have a detailed document of your requirements so that we can discuss the each and every point in details. Thanks, Murtaza
$1,250 USD in 21 days
5.0 (11 reviews)
4.6
4.6
User Avatar
Hello, We are an Ahmedabad (India) based software and mobility solutions provider company having the team of dynamic & highly technical developers. We are having developer having experience in the range of 2-12 years on .Net, C#, JQuery, MVC, DevExpress, DotNetNuke, Telerik, Linq, WPF, WCF, MySQL, Microsoft Azure, SSRS, SAAS, PHP, Joomla, Wordpress, Magento, HTML5, CSS3, etc. I am also having an experience on mobile technologies like Android, iPhone, IOS, Phonegap, Corodova, etc. We reviewed your requirement detail and Interested to work on the same. We are having core expertise of working on exactly similar projects. You can check our portfolio, past and current projects so that you can get better confidence on our skills and expertise. We can assign the dedicated resources to work on your projects. Our rich knowledge, domain experience will help to finish the work on time, with good quality and under budget. We are interested to start working immediately on your project. Kindly provide your Skype ID so that we can discuss further also I can show you the demo of our projects through screen sharing session. Looking forward to get quick and positive response. Best Regards, BD Professional
$1,555 USD in 25 days
5.0 (3 reviews)
4.7
4.7
User Avatar
I will bring practical experience working with Ms Access OLE Fields(Image Storage & Ms Word Documents) from Visual Basic applications since Access 2000. I can bring that experience to bear on this project. I propose to develop and supply a solution using VB.Net that will utilize a UDF to read the Ms Access OLE field, return the type of data stored there as well as return pure binary data stripped of its header. Additionally, the function will also handle conversion between image types to enable you have binary data that can be rendered to your web page. Please contact me if you have questions on any or all aspects of my offer.
$1,500 USD in 20 days
5.0 (3 reviews)
3.8
3.8
User Avatar
I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per client work suitability My core skills are LAMP .Net - Windows & Web HTML/HTML 5 CSS3/CC4 Java Script and related frameworks JQuery and related frameworks AJAX,XML,JSON VB,VBA,COM/DCOM,VB Script,Macros,Excel,Classic ASP MySQL,MS SQL,MS Access,Oracle PL-SQL - Developer and Admin Flash(AS2,AS3) Crystal Reports ColdFusion (Adobe and Railo) IIS,Apache,DNS - Admin with Windows,Linux MVC,CMS and related frameworks
$1,666 USD in 20 days
5.0 (4 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$1,250 USD in 20 days
5.0 (5 reviews)
2.3
2.3
User Avatar
A proposal has not yet been provided
$2,222 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam This is Neil, And i am Ready to create a .NET function for you through which you can retrieve Image (PNG,JPEG) from a web application outside of MS Access. So for any Further Clarifications feel free to contact me..
$900 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir At first thanks to you for post this beautiful project on freelancer site & giving a chance to work. sir we are a new in freelancer website or digital platform but we are 1+ years experience company in my City. 1 years is not a big time in market but our everyone designer are more than 7 years experience in this professional. in short we are definitely doing this project as you want. Thanking you Sayantan das +919547816382 West Bengal pin -0713205 India.
$1,250 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have developed application that store image and QR barcode data in ole field in binary format into Ms Access previously.
$1,000 USD in 17 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Rockville, United States
5.0
10
Payment method verified
Member since Sep 11, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.