Solved

Read BLOBS from Firebird per ODBC-Connection

Posted on 2008-06-20
3
1,307 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
  • 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

821 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