[ psqlodbc-Bugs-1000467 ] Can't use (b)lobs with Omnis Studio v4

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000467 ] Can't use (b)lobs with Omnis Studio v4
Date: 2005-12-07 14:04:38
Message-ID: 20051207140438.8E8A41125088@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-odbc

Bugs item #1000467, was opened at 2005-12-07 14:23
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000467&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: Postponed
Priority: 3
Submitted By: Nobody (None)
Assigned to: Ludek Finstrle (luf)
Summary: Can't use (b)lobs with Omnis Studio v4

Initial Comment:
Hi.

My company uses PGSQL v8.1 as backend database and Raining Data's Omnis Studio v4.1 as developpement tool (see http://www.omnis.net/. There is a demo version).

LOB (blobs, clobs) can't be used with Postgresql and ODBC, either using lo or bytea. Queries fail or the app' crashes.

I tried different settings with psqlOBDC with no luck.

I've joined my log.

If you have questions or need more details : nte(at)mustinformatique(dot)fr

Thanks.

Nathanael TERRIEN.

----------------------------------------------------------------------

>Comment By: Ludek Finstrle (luf)
Date: 2005-12-07 15:04

Message:
I upload logs and delete second report ...

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2005-12-07 15:03

Message:
I see no problem with lo or bytea:
[SQLExecute]
CREATE TABLE VCS_ComponentData (vcs_ID int4 NOT NULL,vcs_ChunkID int4 NULL,vcs_ChunkSize int4 NULL,vcs_ChunkChecksum int4 NULL,vcs_Data

This isn't SQL command. Do you read what driver report?

STATEMENT ERROR: errnum=7, errmsg='Error while executing the query'
CONN ERROR: errnum=108, errmsg='ERROR: syntax error at end of input au caractĨre 137'

Please don't create new bug report. Either log in before you report bug or send additional information to pgsql-odbc mailing list.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000467&group_id=1000125

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2005-12-07 14:05:49 [ psqlodbc-Bugs-1000468 ] BIS : Can't use (b)lobs with Omnis Studio v4 (with file)
Previous Message noreply 2005-12-07 14:03:06 [ psqlodbc-Bugs-1000467 ] Can't use (b)lobs with Omnis Studio v4