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

[Alexander P. <ale...@gm...>]

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'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

-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru