Re: [Firebird-odbc-devel] SQLGetData and bookmarks while using OpenOffice.org

[Ocke J. <Ock...@or...>]

On 27.01.2011 12:55, Alexander Potapchenko wrote:
> On 27.01.2011 13:44, Ocke Janssen wrote:
>> Hi Alexander,
>> I upload a debug version for Windows on
>> ftp://qa-upload.services.openoffice.org/dba34d/OOo_DEV300m96_Win_x86_install-arc_en-US.zip
>>
>> You have to start sbase.exe and choose ODBC in the lowest listbox.
>> - Choose your db and press finish and store the odb file somewhere
>> - The tables folder will automatically selected
>> - But there are no tables (may a config problem on my side, I used
>> odbctest from MS and call SQLTables results only in 3 system tables and
>> nothing more) :-(
> You must use usr/pwd - SYSDBA/masterkey in DSN settings. The trusted
> authentication is fixed for 2.0 release.
>> - Go to the queries and create one ( select the "Create Query in SQL View"
>> - Enter a simple "select * from your_table_name"
>> - Run it
>> =>   Crash
>>
> I have tried to execute select * from EMPLOYEE (upper case) and it works
> fine with Firebird 2.5 and SQL dialect 3.
> The query - select * from employee returns SQL_ERROR (TABLE unknow)
> because your application generates query - select * from "employee" - it
> is wrong for Firebird server with dialect 3.
> You can use select * from "EMPLOYEE" - but this question for Firebird
> server developers.
> I don't see crash. I do something wrong?
I found the difference. Since I log in sysdba I see the tables I created.

While in Office go to the menu Edit->Database->AdvancedSettings
in the dialog select the 2nd page and check the last entry ("Ignore the 
result set type" the text is wrong it should be respect and not ignore:-)
Save/Close file and reopen it.
Double click on the table => crash.

- oj
>
>
>> I'm using 2.0.0.150 RC2 64-bit.
>>
>> - oj
> Your application is 32-bit and it uses 32-bit driver properly, 64-bit
> windows installer of the Firebird ODBC driver installs 32-bit and 64-bit
> drivers.
>
>
> Regards,
> Alexander
>