We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

ADO and Field Blob - Oracle

antenor
antenor asked
on
Medium Priority
1,463 Views
Last Modified: 2010-05-18
my application is ported to Oracle, but i found ADO doesn't support BLOB
data type in Delphi 7 and "Microsoft OLE DB Provider for Oracle".
it could use driver of oracle, but I want to use of the Microsoft.
how to solve this problem?


thanks
Comment
Watch Question

Top Expert 2004

Commented:
what about

TBlobField(Dataset.FieldByName('fieldname')).Loadfromfile('imagefilename',ftblob);
//instead of Loadfromfile -> LoadFromStream would be also possible

not sure syntax about the last ftBlob-param

meikl ;-)

Author

Commented:
the Problem this at the moment that I go to Open the DataSet
Top Expert 2004

Commented:
>the Problem this at the moment that I go to Open the DataSet
what happens?

Author

Commented:
if the instruction sql to possess a field CLOB/BLOB occurs an error when trying to give a Open.
Top Expert 2004

Commented:
what dataset do you use?
is there any sql-statement in use?

Commented:
what !!!!!!!!! "found ADO doesn't support BLOB data type in Delphi 7" thats WRONG ADO supports it and i use them very often. And kretzschmars exsample should work.
Software Developer
CERTIFIED EXPERT
Commented:
Microsoft OleDB provider for oracle doesn't support the BLob fields

you can use Oracle db provider instead of microsoft one, you can download it freely from oracle website

and you can use dbExpress instead of Ado, it's faster than ado, also using native oracle components like DOA or ODAC, will be the best solution

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.