Blob Data from Sybase

Posted on 2009-05-26
Medium Priority
Last Modified: 2013-11-23

I have a sybase database need to extract the saved word documents in Sybase as blob data. I need to extract all those documents into a folder.

Please provide method how can I do that using Delphi or Visual Studio 2005

Your help is much appreciated.

Question by:ktuser
  • 2
LVL 19

Expert Comment

ID: 24475732
Sybase is not a database; it is a company that makes at least 4 database products.  Please post the product and version you are using.

Visual Studio 2005 is not a language, it is an IDE that supports a bunch of different languages.  Which one are you thinking of using?

Finally, it is usually easier to avoid the low-level database interface code (e.g. ctLib) and use something at a higher level like ODBC.  The ODBC drivers already know how to handle the protocol for getting blobs into and out of the database so you avoid that little slice of hell.

I would use ODBC with whatever language supports ODBC and has a native BLOB datatype.  Then you simply have to write a query and, for each result row, pull out the blob and (hopefully) a file name and then write the file to the target folder.

Don't expect this to be lightning fast either.


Author Comment

ID: 24476422
Thanks a lot Bill for your response.

The database is Sybase ASE 12.5 and I am planing to use VB.NET.

Appreciate you help now I got an idea how I can proceed with the project.

LVL 19

Accepted Solution

grant300 earned 2000 total points
ID: 24477690
VB.NET should do the trick nicely.

Remember your BLOBs are BINARY data, not strings, and you should be fine.


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

623 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