Member Avatar for culebrin

Hi, i've been with this in my neck a month ago, I need to write and read a image file to an Informix DB, but through a COM+ application (3 tier app). I googled this several times with no luck. So please any help would be apreciated.

I have tried with the followings examples:

http://support.microsoft.com/kb/194975/en-us
http://support.microsoft.com/kb/316887/en-us
http://support.microsoft.com/kb/317034/en-us
http://support.microsoft.com/kb/308042/en-us
http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html

And nothing, also i've tried with the Informix functions: LoToFILE and FileToBlob, those could save the file into the DB, but when i tried to Write into the client, it just save the file on the MTS server, and I don't have permissions to send it to the client.

Please, if someone could give me a working example on how I do this, I just be eternally thankful.

Thank you very much for your patient.
Omar D.

  • 1 Contributor
  • 1 Reply
  • 140 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by culebrin
Member Avatar for culebrin

I haven't found the solution yet, nobody has an idea about this? :( now, i'm really desperated...

The reason why I can't use the codes mainly is that the components used to update the database uses an UpdateBatch command and it returns me an error, I guess it's because a blob can't be used to construct an Insert or Update transaction (UpdateBatch command constructs those transactions).

I can't use that component. If I made another component, how can I save the blob field on the database and how can I read it... I tried this with those examples above but no luck.

Any help are welcomed...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.