Solved

Read BLOBS from Firebird per ODBC-Connection

Posted on 2008-06-20
3
1,316 Views
Last Modified: 2013-12-09
In Access we need to extraxt a string from a Firebird BLOB-field.
The table containing the BLOB-field is linked over ODBC.
How can we extract the pure text?
0
Comment
Question by:prooffice
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 44

Assisted Solution

by:Leigh Purvis
Leigh Purvis earned 250 total points
ID: 21829977
How do you currently connect to the table?  A linked table via ODBC?
What do you see as the contents of the table when you open it from Access?
Is it binary data in that field - or just ASCII text (as you refer to extracting a string...)

How do you *want* to extract it?
Programatically?  Into a file?
Create a binary file that was inserted into the field?
What datatype is the field?  (What datatype does Jet see it as in the linked table?)
0
 

Author Comment

by:prooffice
ID: 21991930
Sorry for the dealy. We encountered some other problems, we had to solve first.

We link to the tably via ODBC. The table of all 'normal' fields are visible.
The BLOB-Field is displayed as 'BLOB'
It is just ASCII-text in the field.

I want to read the data via a recordset. Once I got the value I want to save it to a different table.
Need more info?
0
 

Accepted Solution

by:
prooffice earned 0 total points
ID: 22191431
We were able to change the format of that field in the Firebird datatabse to plain text.
So we can read all data now without problems.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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