Issue 60890 - Postgresql ODBC access with Base
Summary: Postgresql ODBC access with Base
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-01-20 15:45 UTC by afore
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 afore 2006-01-20 15:45:11 UTC 
System is WinXP on Dell Inspiron 8500 w/1GB ram. I open a postgresql database, 
ver 8.01 using Postgresql ODBC driver ver 8.00.01.02. I see the table and the 
queries shown underneath the table. I can view the query data, but when I try to 
view the table itself, I get 

SQL Status: 24000

[Microsoft][ODBC Driver Manager] Invalid cursor state 

So Base is unuseable for what I want to use it for. I can do the same with 
MSAccess, and it works fine as is PGAdmin III.
Comment 1 afore 2006-01-20 16:18:59 UTC 
Forgot to mention, I have the same database on a Suse linux 10.0 machine and on 
the winxp machine. Same ODBC driver for both, same problem for both.

Art
Comment 2 christoph.lukasiak 2006-02-07 15:59:55 UTC 
clu->afore: yes, that is really annoying - but this looks like a driver problem
- may you try this alternative driver:
http://dba.openoffice.org/drivers/postgresql/index.html#install_2.0 and
acknowledge my guess

thx
Comment 3 christoph.lukasiak 2006-03-08 09:13:32 UTC 
does this 'fix' your problem?
Comment 4 afore 2006-03-08 17:54:13 UTC 
The sdbc driver does work and I can access and modify the database with it. ODBC 
driver still does not work with  Base though. Since I am using Base to update the 
database which is accessed with an application that only uses ODBC, it will work 
fine.

Thanks for the info.
Comment 5 p9w.vu.31122010 2006-03-08 18:13:35 UTC 
I tested the uno package and it worked perfectly with PostgreSQL 8.1.2. I can
view tables, queries made with OOo and views created with CREATE VIEW AS on the
psql commandline, but still encountered some hickups with creating forms with
the form wizard.
Only when accepting the defaults it works. All other form layouts cause OOo to
crash.
Comment 6 christoph.lukasiak 2006-03-20 16:13:55 UTC 
issue will not be fixed because it seems to be a driver problem outside oo
Comment 7 christoph.lukasiak 2006-03-20 16:21:07 UTC 
clu->simonaw: please do not mix different cases or add further topics - if
anything else does not work for you, please write a seperate issue with a repro
step by step description

see: http://qa.openoffice.org/issue_handling/basic_rules.html

thx