Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fetch type out of range errors when using OpenOffice 3.3 [ODBC115] #112

Closed
firebird-automations opened this issue Mar 7, 2011 · 9 comments

Comments

@firebird-automations
Copy link

Submitted by: sboyd (sboyd)

Attachments:
OdbcFb.zip
Firebird_ODBC_2.0.0.151_Win32.exe

When attempting to display data from a Firebird table using OpenOffice 3.3 is "Fetch type out of range" error is thrown.

According to Alexander Potaphenko:

After the additional analysis of the driver source code I have found
wrong and implicit type conversion of the cursor (conversion to type
SQL_CURSOR_FORWARD_ONLY).

Commits: c1a2596 3aa6532

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

The attached driver for testing.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11913 ]

@firebird-automations
Copy link
Author

Commented by: sboyd (sboyd)

That seems to have fixed it. I'll let you know if I have any more difficulties. Thank You

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0 [ 10044 ]

@firebird-automations
Copy link
Author

Commented by: Leonardo (leo08970)

Hi Alexander,

I still have the same issue with new DLL. I have installed last ODBC (Firebird_ODBC_2.0.0.150_Win32.exe) and the replace DLL in \systems32 by the one you upload. Is there anything that I have to do ? OpenOffice version is 3.3.0

However, sboyd said that it worked in his case.

Jordi.

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Hi Jordi,
Please try to uninstall old version and install the attached full version.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: Firebird_ODBC_2.0.0.151_Win32.exe [ 11919 ]

@firebird-automations
Copy link
Author

Commented by: Leonardo (leo08970)

Hi Alexander,

you fixed it.

Using Firebird_ODBC_2.0.0.150_Win32.exe you attached me (I did not use attached DLL) , I can open tables using Openoffice 3.3.0.
I'm now going to check it a little bit more, because I'm planning to use it to create some reports from data stored in Firebird database.

Thanks a lot for your help and fast answer. I'll keep you informed .

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants