[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1345
  • Last Modified:

Read BLOBS from Firebird per ODBC-Connection

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
prooffice
Asked:
prooffice
  • 2
2 Solutions
 
Leigh PurvisDatabase DeveloperCommented:
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
 
proofficeAuthor Commented:
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
 
proofficeAuthor Commented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now