Inserting a jpg as a blob with ODBC using C#

Posted by jmgawlik on 01-Apr-2009 12:03

First, I am not sure if this is the appropriate forum for this question. If not, I apologize now.

I am trying to store a jpg image as a blob in my Progress DB using C# but I cannot find a good sample of this sort of thing. I was hoping someone might be able to point me in the right direction. Everything I have tried so far gives me SQL syntax errors so I'm stuck.

By the way, if it matters, I am using OE10.1B02 and VS 2005.

Thanks.

All Replies

Posted by Admin on 01-Apr-2009 17:03

John,


Can you give us an example of what you have attempted?  Posting the SQL syntax errors will help.  One of the first things I check for when I or anyone in my team has SQL syntax errors to Progress via ODBC or 'OE Dataserver for MS SQL' is to make sure your SQL datatype maps to the proper Progress datatype.  Another thing to think about is, field lengths (max length or precision), but I only have issues with that when pulling data from progress.

take a look at this thread: http://communities.progress.com/pcom/message/33977

ProParse api mentioned in the above thread is referenced in the following thread: http://communities.progress.com/pcom/message/21942#21942

This thread is closed