Issue 116523 - Firebird ODBC error in Base
Summary: Firebird ODBC error in Base
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO330m9
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: 3.4.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: oooqa, regression
Depends on:
Blocks:
 
Reported: 2011-01-19 21:17 UTC by dbarbul
Modified: 2017-05-20 10:30 UTC (History)
3 users (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 dbarbul 2011-01-19 21:17:01 UTC 
When I try to open any table from database connected by Firebird ODBC source I
get an error:

Data content could not be loaded
[ODBC Firebird driver]Fetch Type out of range

In earlier versions including 3.20 and 3.21 everything was working OK.
Comment 1 r4zoli 2011-01-20 12:01:06 UTC 
Can confirm it.

I tested on Win7 with FB 2.5 and FB ODBC 2.0.0.150Win32 downloadable today from
FB site.

OOo 3.3RC10 and DEV300m96 works same gives  Data content could not be loaded
error message, when clicks on tables to open, after I added the password.

More on error message:
SQL status: HY106
[ODBC Firebird Driver]Fetch type out of range

Feom Tools>SQL... command window I can run SELECT * FROM "Table" without any error.

It is a regression, when I use OOo 3.2.1 when I click on tables opens without
problem.

Workaround use JDBC 2.2.0snapshot20060810JDK1_5 driver with Java 1.6 described in: 
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase
Comment 2 r4zoli 2011-01-23 19:54:31 UTC 
Similar fetching problem with other database type, see forum posts:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=36844&p=173032#p173032
Comment 3 ocke.janssen 2011-01-26 11:30:59 UTC 
Could someone please it test again when running the macro attached to issue 5113

http://www.openoffice.org/nonav/issues/showattachment.cgi/22423/Universe%20settings.bas

This should take the driver result set type into account.
Comment 4 r4zoli 2011-01-26 12:48:07 UTC 
The right issue number is 15113.
I tested on win7 with OOo 3.3RC10.
I not use macro at all, only copied into macro editor, and try to run. 

The downloaded macro fails when I run it, with 

Basic runtime error
Property or method not found

The line of code "highlighted"  in the macro is

oDB.Store()

as in original issue.

If I use instead oDB.Store()
the suggested in 15113: oDB.DatabaseDocument.store()

another error 

Basic runtime error
An exception occurred,  ....I/O exception
Comment 5 ocke.janssen 2011-01-26 14:23:28 UTC 
What is the trick to see the tables in OOo? I've started odbctest and try to
retrieve all tables but what I got are the system tables. I see the table with
flamerobin where I created it.
Comment 6 ocke.janssen 2011-02-01 12:50:06 UTC 
Fixed in cws dba34d.

You need the newest ODBC driver from firebird or see
http://tracker.firebirdsql.org/browse/ODBC-106 for more information.
Comment 7 ocke.janssen 2011-02-10 08:52:13 UTC 
.
Comment 8 ocke.janssen 2011-03-17 10:11:54 UTC 
Please review. Thanks.
Comment 9 marc.neumann 2011-03-23 09:49:32 UTC 
verified in cws dba34d