Issue 24274

Summary:	ODBC Postgres Fails
Product:	Base	Reporter:	adalseno <adalseno>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows ME
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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'