HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Reading/Writing BLOB fields
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Reading/Writing BLOB fields

Reading/Writing BLOB fields 1 year, 3 months ago #1681

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Hello

I have a web site and I store images of the users in the database. I was able to load pictures into blob fields using Advanced ETL Processor and I can see the images in the browser. But when I tried to save blob data into OS files all files have no data. There are files in the directory but the file size is zero

Any advice?

Steve
Reply Quote

Re: Reading/Writing BLOB fields 1 year, 3 months ago #1682

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
What is the database type you are dealing with

Peter
Reply Quote

Re: Reading/Writing BLOB fields 1 year, 3 months ago #1683

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
It is MS SQl Server

Steve
Reply Quote

Re: Reading/Writing BLOB fields 1 year, 3 months ago #1684

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
I see

I guess you have got a blob field in the middle of the table
Can you try the following please:
use sql as data source and make sure that the blob filed is the last one in query
(no much we can do about it this how ODBC works)
select field1...., blob1 from table

Peter
Reply Quote

Re: Reading/Writing BLOB fields 1 year, 3 months ago #1685

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Yes,it works now thank you.
Steeve
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.18 seconds

Testimonials

"The DBSL Integration solution eliminated our data access bottle neck that previously impeded company growth. We are now able to provide solutions to long standing problems areas such as automated order processing and business reporting limitations. Additionally the solution allows for new opportunities to simply hook-on to our existing data sources. From development through testing the DBSL support  team continues to be helpful, resourceful and responsive to our company needs."

John Kil,
IT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top