Issue 24274 - ODBC Postgres Fails
Summary: ODBC Postgres Fails
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows ME
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-10 17:46 UTC by adalseno
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description adalseno 2004-01-10 17:46:13 UTC 
Hi I've just installed OOo 1.1 and using calc I got this problem: I tried to 
access my data on a PostgreSQL database, which has schema in it, using my ODBC 
datasource. The source manager can connect to the database, in fact I can see 
all my tables, but my queries will always fail stating "Attribute OID not 
found".
Any suggestion? Should I use jdbc? Will it fix the problem?

I've also tried on a PC with Win98 and I got the same message.
Comment 1 Frank Schönheit 2004-01-12 08:32:56 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 2 marc.neumann 2004-01-12 09:47:09 UTC 
Hi,

please have a look at the FAQ at:

http://dba.openoffice.org/FAQ/specific.html#postgres_oid

This is an issue with the postgres driver and not with OOo.
I close this issue as invalid.

Bye Marc
Comment 3 marc.neumann 2004-01-12 09:47:32 UTC 
closed
Comment 4 adalseno 2004-01-12 20:36:26 UTC 
Yes, it works! .
I tried to browse OOo site to find a solution myself, but I could not!
Thanks

PS Postgres is version 7.3.4 ODBC Driver is 7.03.01.00
Comment 5 hans_werner67 2004-02-02 12:27:52 UTC 
change subcomponent to 'none'