Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Read BLOBS from Firebird per ODBC-Connection

Posted on 2008-06-20
3
Medium Priority
?
1,336 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 1000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article, we’ll look at how to deploy ProxySQL.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

926 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