firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix

Re: [Firebird-odbc-devel] Connect IBProvider in VB

[Peter G. <pe...@go...>]

The parameters you selected are the key ones and will certainly suffice for
your evaluation.

-----Original Message-----
From: Bart Smissaert [mailto:bar...@gm...] 
Sent: 05 March 2011 11:13
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] Connect IBProvider in VB


Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?

Do you find that IBProvider is faster than the IB Phoenix ODBC driver?

RBS

On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore
<pe...@go...> wrote:
> Why the double backslash in the Data source?
>
> I use IBProvider and find it great. I use Delphi myself and here is a
> typical connection string
>
> Provider=LCPI.IBProvider.2;Password=MYPASSWORD;Persist Security
> Info=True;User ID=MYUSER;Data
>
Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
>
garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
>
rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
>
char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
>
nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
>
to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
>
_unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
>
uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up
> date_field_rule=0;modify_trans_type=0;modify_trans_level=65536
>
> Hope this helps
>
> Regards
> peter
>
> -----Original Message-----
> From: Bart Smissaert [mailto:bar...@gm...]
> Sent: 05 March 2011 10:23
> To: fir...@li...
> Subject: [Firebird-odbc-devel] Connect IBProvider in VB
>
>
> I know this is somewhat off-topic, but maybe somebody could tell me
> where to get clear instructions how to connect to
> Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
> out the free version to see if it might be faster than the
> IB Phoenix ODBC driver, but sofar I have been unable to connect.
> I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
> C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
> I have tried various connection strings similar and with all kind of
> variations to this one:
>
> Provider=LCPI.IBProvider.3;
> Data Source=localhost:C:\\DB\S6.FDB;
> User id=UN;
> password=PW;
> ctype=win1251;
> auto_commit=true
>
> But sofar no success at all.
> I am sure there must be something simple I am doing wrong, but I can't see
> it.
>
> RBS
>
>
----------------------------------------------------------------------------
> --
> What You Don't Know About Data Connectivity CAN Hurt You
> This paper provides an overview of data connectivity, details
> its effect on application quality, and explores various alternative
> solutions. http://p.sf.net/sfu/progress-d2d
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
signature
> database 5927 (20110304) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
signature
> database 5927 (20110304) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
>
>
----------------------------------------------------------------------------
--
> What You Don't Know About Data Connectivity CAN Hurt You
> This paper provides an overview of data connectivity, details
> its effect on application quality, and explores various alternative
> solutions. http://p.sf.net/sfu/progress-d2d
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 

Re: [Firebird-odbc-devel] Connect IBProvider in VB

[Bart S. <bar...@gm...>]

Thanks, I figured this out now.
I connected from a string in a text file and that had linebreaks.
I thought these linebreaks were dealt with in my code, but they
weren't and clearing these
linebreaks sorted it out and I can connect fine now.
Will have a look at your connection string. Did you find that you
needed all those extra parameters or did you find they were
beneficial?

Do you find that IBProvider is faster than the IB Phoenix ODBC driver?

RBS

On Sat, Mar 5, 2011 at 10:30 AM, Peter Gore
<pe...@go...> wrote:
> Why the double backslash in the Data source?
>
> I use IBProvider and find it great. I use Delphi myself and here is a
> typical connection string
>
> Provider=LCPI.IBProvider.2;Password=MYPASSWORD;Persist Security
> Info=True;User ID=MYUSER;Data
> Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
> garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
> rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
> char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
> nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
> to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
> _unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
> uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up
> date_field_rule=0;modify_trans_type=0;modify_trans_level=65536
>
> Hope this helps
>
> Regards
> peter
>
> -----Original Message-----
> From: Bart Smissaert [mailto:bar...@gm...]
> Sent: 05 March 2011 10:23
> To: fir...@li...
> Subject: [Firebird-odbc-devel] Connect IBProvider in VB
>
>
> I know this is somewhat off-topic, but maybe somebody could tell me
> where to get clear instructions how to connect to
> Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
> out the free version to see if it might be faster than the
> IB Phoenix ODBC driver, but sofar I have been unable to connect.
> I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
> C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
> I have tried various connection strings similar and with all kind of
> variations to this one:
>
> Provider=LCPI.IBProvider.3;
> Data Source=localhost:C:\\DB\S6.FDB;
> User id=UN;
> password=PW;
> ctype=win1251;
> auto_commit=true
>
> But sofar no success at all.
> I am sure there must be something simple I am doing wrong, but I can't see
> it.
>
> RBS
>
> ----------------------------------------------------------------------------
> --
> What You Don't Know About Data Connectivity CAN Hurt You
> This paper provides an overview of data connectivity, details
> its effect on application quality, and explores various alternative
> solutions. http://p.sf.net/sfu/progress-d2d
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 5927 (20110304) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 5927 (20110304) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
>
> ------------------------------------------------------------------------------
> What You Don't Know About Data Connectivity CAN Hurt You
> This paper provides an overview of data connectivity, details
> its effect on application quality, and explores various alternative
> solutions. http://p.sf.net/sfu/progress-d2d
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

Re: [Firebird-odbc-devel] Connect IBProvider in VB

[Peter G. <pe...@go...>]

Why the double backslash in the Data source?

I use IBProvider and find it great. I use Delphi myself and here is a
typical connection string

Provider=LCPI.IBProvider.2;Password=MYPASSWORD;Persist Security
Info=True;User ID=MYUSER;Data
Source=MyFBData;Location=MyServer:d:\data\fbdata\myfbdata.fdb;ctype=WIN1252;
garbage_collect=True;dialect=3;auto_commit=True;auto_commit_level=65536;bicu
rsor=False;free_threading=True;array_vt_type=True;inner_trans=True;truncate_
char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;u
nicode_mode=True;unicode_stmt=True;std_exec_sp=True;clear_param_info=True;au
to_param_describe=True;force_param_describe=True;named_param_prefix=:;ignore
_unprepare=True;exec_sp_named_param=False;odbc_call_sp=0;auto_commit_ddl=0;a
uto_commit_ddl_level=4096;query_pool_size=8;auto_insert_field_rule=0;auto_up
date_field_rule=0;modify_trans_type=0;modify_trans_level=65536

Hope this helps

Regards
peter

-----Original Message-----
From: Bart Smissaert [mailto:bar...@gm...] 
Sent: 05 March 2011 10:23
To: fir...@li...
Subject: [Firebird-odbc-devel] Connect IBProvider in VB


I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
variations to this one:

Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true

But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see
it.

RBS

----------------------------------------------------------------------------
--
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5927 (20110304) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 

[Firebird-odbc-devel] Connect IBProvider in VB

[Bart S. <bar...@gm...>]

I know this is somewhat off-topic, but maybe somebody could tell me
where to get clear instructions how to connect to
Firebird (1.5) with IBProvider in VB, using ADO. I am trying to test
out the free version to see if it might be faster than the
IB Phoenix ODBC driver, but sofar I have been unable to connect.
I copied cc3250mt.dll and _IBProvider_x3_free_i.dll to
C:\WINDOWS\SYSTEM32\ and did a Regsvr32 on the last file.
I have tried various connection strings similar and with all kind of
variations to this one:

Provider=LCPI.IBProvider.3;
Data Source=localhost:C:\\DB\S6.FDB;
User id=UN;
password=PW;
ctype=win1251;
auto_commit=true

But sofar no success at all.
I am sure there must be something simple I am doing wrong, but I can't see it.

RBS

Re: [Firebird-odbc-devel] sqlserver/openquery/odbc

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

On 10.02.2011 21:08, unordained wrote:
> I've got another team trying to access my firebird database from sqlserver, using
> 'openquery' (they're pulling from themselves, me, and another access database, and that
> seemed like the cleanest solution at the time.)
>
> Their queries are purely read-only queries.
>
> At the moment, my database is mostly locked up because of a migration script running;
> almost all records are being touched by a very long-running process.
>
> It seems in the ODBC configuration GUI that their only options result in either:
> a) something like read-committed + no-rec-version + nowait, which blows up with
> deadlock errors (because it's told not to wait on the new record versions, which won't
> be available possibly for days)
> b) something like read-committed + no-rec-version + wait, which just hangs forever
> (because my code's not going to commit for days.)
>
> Neither of those is good.
>
> I'm not sure what transaction settings they're using in sqlserver, and I haven't found
> any documentation about how sqlserver configures openquery (based on the sqlserver
> transaction settings?), and how that passes through to the ODBC layer -- but is there
> any way I can get them to use the transaction mode I want, which is just a plain read-
> committed, rec-version (wait won't matter), or what I always use, snapshot isolation? I
> don't see anywhere to configure exactly that in the ODBC GUI, and what we change there
> *seems* to have an effect, so regardless of sqlserver/openquery, what we configure
> matters -- but I can't configure what I want. Is there a registry setting, a text file,
> some other place you can configure stuff like this?
>
>
Hi,

ODBC driver 2.0 RC2 uses read-committed/rec-version by default (versions 
before RC2 used read-committed/no_rec-version).
Read/Write and Wait/NoWait are configured in ODBC configuration GUI.

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

[Firebird-odbc-devel] sqlserver/openquery/odbc

[unordained <uno...@cs...>]

I've got another team trying to access my firebird database from sqlserver, using 
'openquery' (they're pulling from themselves, me, and another access database, and that 
seemed like the cleanest solution at the time.)

Their queries are purely read-only queries.

At the moment, my database is mostly locked up because of a migration script running; 
almost all records are being touched by a very long-running process.

It seems in the ODBC configuration GUI that their only options result in either:
a) something like read-committed + no-rec-version + nowait, which blows up with 
deadlock errors (because it's told not to wait on the new record versions, which won't 
be available possibly for days)
b) something like read-committed + no-rec-version + wait, which just hangs forever 
(because my code's not going to commit for days.)

Neither of those is good.

I'm not sure what transaction settings they're using in sqlserver, and I haven't found 
any documentation about how sqlserver configures openquery (based on the sqlserver 
transaction settings?), and how that passes through to the ODBC layer -- but is there 
any way I can get them to use the transaction mode I want, which is just a plain read-
committed, rec-version (wait won't matter), or what I always use, snapshot isolation? I 
don't see anywhere to configure exactly that in the ODBC GUI, and what we change there 
*seems* to have an effect, so regardless of sqlserver/openquery, what we configure 
matters -- but I can't configure what I want. Is there a registry setting, a text file, 
some other place you can configure stuff like this?

I can't tell if they can do anything like SET TRANSACTION inside an OpenQuery call -- 
my impression was that it had to be a single, valid statement (a select/insert/etc.) 
and that other command types weren't allowed to be mixed in. And that each one is 
independent, so they can't use one OpenQuery for SET TRANSACTION, and another for 
SELECT. But I'm not sqlserver guru.

Thanks,

-Philip

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

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

Hi Alexander,

On 28.01.2011 10:29, Alexander Potapchenko wrote:
> On 27.01.2011 16:48, Alexander Potapchenko wrote:
>> Reproduced. It is SQLGetData bug with column number 0 (if bookmarks
>> are enabled).
>> The Firebird bug tracker is not available now -
>> http://tracker.firebirdsql.org/secure/Dashboard.jspa and I will create
>> issue when this problem will be solved.
>>
>>
>> Regards
>> Alexander
> Hi Ocke,
>
> I have created the issue -
> http://tracker.firebirdsql.org/browse/ODBC-106 and I have attached the
> fixed driver for your testing there.
Thanks for the fast fix. It works. Now I stumble about the next problem 
when I try to insert a row. But that's another story I have to debug.
All I get is a error message which include only wild characters.

Best regards,

Ocke
>
>
> Regards,
> Alexander

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

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

On 27.01.2011 16:48, Alexander Potapchenko wrote:
> Reproduced. It is SQLGetData bug with column number 0 (if bookmarks 
> are enabled).
> The Firebird bug tracker is not available now - 
> http://tracker.firebirdsql.org/secure/Dashboard.jspa and I will create 
> issue when this problem will be solved.
>
>
> Regards
> Alexander
Hi Ocke,

I have created the issue - 
http://tracker.firebirdsql.org/browse/ODBC-106 and I have attached the 
fixed driver for your testing there.


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

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

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

On 27.01.2011 15:27, Ocke Janssen wrote:
> 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.
>
>
Reproduced. It is SQLGetData bug with column number 0 (if bookmarks are 
enabled).
The Firebird bug tracker is not available now - 
http://tracker.firebirdsql.org/secure/Dashboard.jspa and I will create 
issue when this problem will be solved.


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

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
>

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

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

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

Hi Alexander,

>>
> Hi Ocke,
>
> Do you use Firebird ODBC driver 2.0.0.150 RC2 32-bit?
> Do you have any idea how I can reproduce your problem quickly (via
> openoffice or C++ example)?
> I have tried to reproduce the problem with IBExpert/ODBC Viewer (it uses
> SQLFetchScroll/SQLGetData), but it works fine.
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) :-(
- 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'm using 2.0.0.150 RC2 64-bit.

- oj

>
>
> Regards,
> Alexander

Re: [Firebird-odbc-devel] OdbcFb 2.0 raises error when delete empty set

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

On 27.01.2011 11:25, Ivan Ravin wrote:
> No rows updated or deleted
I think that SQLExecute returns SQL_SUCCESS_WITH_INFO (warning) instead 
of SQL_ERROR.
I think it is correctly.


Regards,
Alexander

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

[Firebird-odbc-devel] OdbcFb 2.0 raises error when delete empty set

[Ivan R. <iv...@ni...>]

OdbcFb 2.0 raises error when execute DELETE statement on empty table or
delete on empty set:

 

delete from DCT$Objects where Object_Name='AH_EXPORT_FACT'
 
[ODBC Firebird Driver]No rows updated or deleted
Execution Failed!

 

 

There is no such error with 1.2 driver, but every 2.0 driver raise it:

OdbcJdbc v2-0-Beta Ver 02.00.00.0144
OdbcJdbc Ver RC1_2-0-0148
OdbcJdbc Ver RC1_2-0-0150
 

And error message looks like UPDATE statement on empty set will raise it too

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

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

On 27.01.2011 10:58, Ocke Janssen wrote:
> Hi,
>
> My name is Ocke Janssen, I'm the project lead of the dba.openoffice.org
> project and I got a problem ;-)
>
> While trying to fetch bookmarks I crash inside the newest ODBC version
> of Firebird.
>
>
>        KernelBase.dll!74edb727()
>        [Frames below may be incorrect and/or missing, no symbols loaded
> for KernelBase.dll]
>        KernelBase.dll!74edb727()
>        OdbcFb.dll!_CxxThrowException(void * pExceptionObject=0x00cfbfe4,
> const _s__ThrowInfo * pThrowInfo=0x0df9f060)  Line 161    C++
>        OdbcFb.dll!IscDbcLibrary::Sqlda::getSqlTypeName()  + 0x23b bytes
>     C++
>        OdbcFb.dll!IscDbcLibrary::Sqlda::getColumnTypeName()  + 0x2b bytes
>      C++
>        OdbcFb.dll!IscDbcLibrary::IscStatementMetaData::getSqlTypeName()
> + 0x16 bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcDesc::defFromMetaDataOut()  + 0xd5
> bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::prepareGetData()  +
> 0x3a bytes    C++
>        OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::sqlGetData()  + 0x1e3
> bytes    C++
>        OdbcFb.dll!_SQLGetData@24()  + 0x60 bytes    C++
>        odbc32.dll!5899b7bf()
>   >
> odbcbasemi.dll!connectivity::odbc::OTools::getBytesValue(connectivity::odbc::OConnection
> * _pConnection=0x09978674, void * _aStatementHandle=0x011125b0, long
> columnIndex=0, short _fSqlType=-2, unsigned char&  _bWasNull='
', const
> com::sun::star::uno::Reference<com::sun::star::uno::XInterface>  &
> _xInterface={...})  Line 494 + 0x3a bytes    C++
>
> odbcbasemi.dll!connectivity::odbc::OResultSet::move(connectivity::IResultSetHelper::Movement
> _eCursorPosition=FIRST, long _nOffset=0, unsigned char __formal='
')
> Line 1657 + 0x6e bytes    C++
>
> The SQL_ATTR_USE_BOOKMARKS is VARIABLE (2) and the type which I use for
> SQLGetaData is -2(SQL_C_VARBOOKMARK)
>
> Do you have any hint what I'm doing wrong?
>
> Best regards,
>
> Ocke Janssen
>
>
Hi Ocke,

Do you use Firebird ODBC driver 2.0.0.150 RC2 32-bit?
Do you have any idea how I can reproduce your problem quickly (via 
openoffice or C++ example)?
I have tried to reproduce the problem with IBExpert/ODBC Viewer (it uses 
SQLFetchScroll/SQLGetData), but it works fine.


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

[Firebird-odbc-devel] AUTOREPLY SQLGetData and bookmarks while us...

[<ul...@gm...>]

Vielen Dank für Ihr e-mail. Ich bin bis 28.1. auf einer Konferenz in Frankfurt und nur schwer erreichbar.
 
In dringenden Fällen wenden Sie sich bitte an ho...@gm... 
 

 
Ulrich Hutter
Programmierung & Geschäftsführung
und stolzer Vater: www.hutter.at/konrad

GMS Zentrale
5582 St.Michael im Lungau, Katschberg 423
Tel: +43/4734/627 50, Fax: +43/4734/627 51
ul...@gm..., www.gms.info  
Firma: GMS Hutter GmbH & Co KG, Rechtsform: GmbH & Co KG, Firmensitz: Salzburg, Firmenbuchnummer: FN 172325 w, Firmenbuchgericht: Handelsgericht 
Salzburg, DVR: 1042688, Komplementär: Hutter GmbH, Sitz: 5582 St. Michael, Katschberg 423,  FB-Gericht Salzburg, FN 196476k
 
Wichtiger Hinweis: Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich 
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns 
und vernichten Sie die empfangene E-Mail. Vielen Dank. 
 
 
Hi,

My name is Ocke Janssen, I'm the project lead of the dba.openoffice.org project and I got a problem ;-)

While trying to fetch bookmarks I crash inside the newest ODBC version of Firebird.


      KernelBase.dll!74edb727()
      [Frames below may be incorrect and/or missing, no symbols loaded for KernelBase.dll]
      KernelBase.dll!74edb727()
      OdbcFb.dll!_CxxThrowException(void * pExceptionObject=0x00cfbfe4, const _s__ThrowInfo * pThrowInfo=0x0df9f060)  Line 161    C++
      OdbcFb.dll!IscDbcLibrary::Sqlda::getSqlTypeName()  + 0x23b bytes    C++
      OdbcFb.dll!IscDbcLibrary::Sqlda::getColumnTypeName()  + 0x2b bytes     C++
      OdbcFb.dll!IscDbcLibrary::IscStatementMetaData::getSqlTypeName() + 0x16 bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcDesc::defFromMetaDataOut()  + 0xd5 bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::prepareGetData()  + 0x3a bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::sqlGetData()  + 0x1e3 bytes    C++
      OdbcFb.dll!_SQLGetData@24()  + 0x60 bytes    C++
      odbc32.dll!5899b7bf()
 > odbcbasemi.dll!connectivity::odbc::OTools::getBytesValue(connectivity::odbc::OConnection * _pConnection=0x09978674, void * _aStatementHandle=0x011125b0, long columnIndex=0, short _fSqlType=-2, unsigned char & _bWasNull='
', const com::sun::star::uno::Reference<com::sun::star::uno::XInterface> & _xInterface={...})  Line 494 + 0x3a bytes    C++
 odbcbasemi.dll!connectivity::odbc::OResultSet::move(connectivity::IResultSetHelper::Movement _eCursorPosition=FIRST, long _nOffset=0, unsigned char __formal='
') Line 1657 + 0x6e bytes    C++

The SQL_ATTR_USE_BOOKMARKS is VARIABLE (2) and the type which I use for SQLGetaData is -2(SQL_C_VARBOOKMARK)

Do you have any hint what I'm doing wrong?

Best regards,

Ocke Janssen


-- <http://www.oracle.com/>
Ocke Janssen | Software Developer
Phone: +40 23646500
OracleOffice

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

<http://www.oracle.com/commitment>

	Oracle is committed to developing practices and products that help
protect the environment




------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


To: fir...@li...

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

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

Hi,

My name is Ocke Janssen, I'm the project lead of the dba.openoffice.org 
project and I got a problem ;-)

While trying to fetch bookmarks I crash inside the newest ODBC version 
of Firebird.


      KernelBase.dll!74edb727()
      [Frames below may be incorrect and/or missing, no symbols loaded 
for KernelBase.dll]
      KernelBase.dll!74edb727()
      OdbcFb.dll!_CxxThrowException(void * pExceptionObject=0x00cfbfe4, 
const _s__ThrowInfo * pThrowInfo=0x0df9f060)  Line 161    C++
      OdbcFb.dll!IscDbcLibrary::Sqlda::getSqlTypeName()  + 0x23b bytes 
   C++
      OdbcFb.dll!IscDbcLibrary::Sqlda::getColumnTypeName()  + 0x2b bytes 
    C++
      OdbcFb.dll!IscDbcLibrary::IscStatementMetaData::getSqlTypeName() 
+ 0x16 bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcDesc::defFromMetaDataOut()  + 0xd5 
bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::prepareGetData()  + 
0x3a bytes    C++
      OdbcFb.dll!OdbcJdbcLibrary::OdbcStatement::sqlGetData()  + 0x1e3 
bytes    C++
      OdbcFb.dll!_SQLGetData@24()  + 0x60 bytes    C++
      odbc32.dll!5899b7bf()
 > 
odbcbasemi.dll!connectivity::odbc::OTools::getBytesValue(connectivity::odbc::OConnection 
* _pConnection=0x09978674, void * _aStatementHandle=0x011125b0, long 
columnIndex=0, short _fSqlType=-2, unsigned char & _bWasNull='
', const 
com::sun::star::uno::Reference<com::sun::star::uno::XInterface> & 
_xInterface={...})  Line 494 + 0x3a bytes    C++
 
odbcbasemi.dll!connectivity::odbc::OResultSet::move(connectivity::IResultSetHelper::Movement 
_eCursorPosition=FIRST, long _nOffset=0, unsigned char __formal='
') 
Line 1657 + 0x6e bytes    C++

The SQL_ATTR_USE_BOOKMARKS is VARIABLE (2) and the type which I use for 
SQLGetaData is -2(SQL_C_VARBOOKMARK)

Do you have any hint what I'm doing wrong?

Best regards,

Ocke Janssen


-- 
<http://www.oracle.com/>
Ocke Janssen | Software Developer
Phone: +40 23646500
OracleOffice

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

<http://www.oracle.com/commitment>

	

Oracle is committed to developing practices and products that help
protect the environment

Re: [Firebird-odbc-devel] Cannot setup system DSN on Windows 7 64bit - test fails

[Robert M. <ro...@ch...>]

Hi

I had assumed the default was TCP/IP but I changed the path to 
localhost:c:\....  and it works like a charm.  Much appreciated :)

Thanks
Rob


On 17/12/2010 9:36 a.m., Dimitry Sibiryakov wrote:
> 16.12.2010 21:03, Robert Martin wrote:
>> Any suggestions would really help :)
>     Use TCP/IP connection string instead of XNET.
>

Re: [Firebird-odbc-devel] Cannot setup system DSN on Windows 7 64bit - test fails

[Robert m. <ro...@ch...>]

Hi

I had assumed the default was TCP/IP but I changed the path to 
localhost:c:\....  and it works like a charm.  Much appreciated :)

Thanks
Rob


On 17/12/2010 9:36 a.m., Dimitry Sibiryakov wrote:
> 16.12.2010 21:03, Robert Martin wrote:
>> Any suggestions would really help :)
>     Use TCP/IP connection string instead of XNET.
>

Re: [Firebird-odbc-devel] Cannot setup system DSN on Windows 7 64bit - test fails

[Dimitry S. <sd...@ib...>]

16.12.2010 21:03, Robert Martin wrote:
> Any suggestions would really help :)

   Use TCP/IP connection string instead of XNET.

-- 
   SY, SD.

[Firebird-odbc-devel] Cannot setup system DSN on Windows 7 64bit - test fails

[Robert M. <ro...@ch...>]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    Hi<br>
    <br>
    When I configure a System DSN in a clients Windows 7 64bit and do a
    'test' I get a 'Open database ....Db location... failed' error
    message.&nbsp; I try the services button and get 'sqlcode -904, fbcode
    335544792 - Cannot attach to services manager'. <br>
    <br>
    We are running FB 2.0 superserver (client did the install but I
    believe it is Super server looking in task mgr) 32bit, ODBC 2.0.0
    32bit.<br>
    <br>
    Our application the creates its own file DSN can connect to the DB
    and access data fine.&nbsp; I ran '<span class="pBody postableBody">C:\Windows\SysWOW64\odbcad<wbr>32'

    </span>to configure the odbc driver.&nbsp; <br>
    <br>
    Any suggestions would really help :)<br>
    <br>
    Thanks<br>
    Rob<br>
  </body>
</html>

Re: [Firebird-odbc-devel] ODBC connection fails

[Helen B. <he...@ii...>]

At 07:54 PM 16/12/2010, Ken Benson wrote:
>I would love to see the screen shot ... but, when I view that posting -
>there's no screen shot in it. :-( 

Keep scrolling down - the screenshots got moved to the end.

HB

Re: [Firebird-odbc-devel] ODBC connection fails

[Ken B. <ke...@bk...>]

I would love to see the screen shot ... but, when I view that posting -
there's no screen shot in it. :-( 

-----Original Message-----
From: Helen Borrie [mailto:he...@ii...] 
Sent: Wednesday, December 15, 2010 2:49 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

At 10:37 AM 16/12/2010, Ken Benson wrote:
>>>>Whoever wrote those apps has hard-coded a username and password into
>their code, that are not the SYSDBA/masterke combination
>>>>that the whole world knows (which is *entirely* expected).  If you 
>>>>know
>what they are, then you will have to set them up in
>>>>your server.  There's no way to discover them if you don't know them.
>
>
>Just so I'm clear - you mean the two apps I'm trying to connect using 
>ODBC, right?

I guess so.


>Here's the deal - one of those apps is MAP DESIGNER from Pervasive. It 
>has fields for User/password - and if the ODBC connection is left 
>blank, this application prompts with a box for USER/PASSWORD/ROLE ... 
>nothing I put in this box satisfies the app.

Then that says the access to the objects you are trying to access have been
(correctly) set up with SQL Privileges that have been bundled in a ROLE.
SQL Privileges belong to a database, not a server. 

This is *still* not an ODBC issue...If you have been connecting to that
database using isql (which doesn't use ODBC) and the SYSDBA credentials *for
your server*, you should be able to ascertain the roles that have been
defined in that database, using SHOW ROLES.  SHOW GRANT should show you the
name[s] of the user[s] that have been granted the respective roles.  To make
it work, you will need to define that/those user[s] in your server's
security database, logged in as SYSDBA.  And then, when you attempt to
connect, you will need that user's login credentials PLUS the role name
(which may or may not be case-sensitive, so assume it is...copy exact case
from what SHOW ROLES displays and wrap in double quotes if SHOW ROLES
displays something other than all-caps.

>The other app is the Database Browser. It has the capability to connect 
>directly - or via ODBC. It will connect to the database, directly. It 
>will NOT connect to the same database via ODBC.

If we are talking about the same database browser (DBrowser.exe) then look
at my posting from last week, which shows a screenshot of a successful ODBC
connection made by that application.  However, that browser is pretty
generic...it probably doesn't even know about roles.

HB




----------------------------------------------------------------------------
--
Lotusphere 2011
Register now for Lotusphere 2011 and learn how to connect the dots, take
your collaborative environment to the next level, and enter the era of
Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Firebird-odbc-devel] ODBC connection fails

[Robert m. <ro...@ch...>]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    Hi<br>
    <br>
    When I configure a System DSN in a clients Windows 7 64bit and do a
    'test' I get a 'Open database ....Db location... failed' error
    message.&nbsp; I try the services button and get 'sqlcode -904, fbcode
    335544792 - Cannot attach to services manager'. <br>
    <br>
    We are running FB 2.0 superserver (client did the install but I
    believe it is Super server looking in task mgr) 32bit, ODBC 2.0.0
    32bit.<br>
    <br>
    Our application the creates its own file DSN can connect to the DB
    and access data fine.&nbsp; I ran '<span class="pBody postableBody">C:\Windows\SysWOW64\odbcad<wbr>32'
    </span>to configure the odbc driver.&nbsp; <br>
    <br>
    Any suggestions would really help :)<br>
    <br>
    Thanks<br>
    Rob<br>
    <br>
  </body>
</html>

Re: [Firebird-odbc-devel] ODBC connection fails

[Helen B. <he...@ii...>]

At 10:37 AM 16/12/2010, Ken Benson wrote:
>>>>Whoever wrote those apps has hard-coded a username and password into
>their code, that are not the SYSDBA/masterke combination 
>>>>that the whole world knows (which is *entirely* expected).  If you know
>what they are, then you will have to set them up in 
>>>>your server.  There's no way to discover them if you don't know them.
>
>
>Just so I'm clear - you mean the two apps I'm trying to connect using ODBC,
>right?

I guess so.


>Here's the deal - one of those apps is MAP DESIGNER from Pervasive. It has
>fields for User/password - and if the ODBC connection is left blank, this
>application prompts with a box for USER/PASSWORD/ROLE ... nothing I put in
>this box satisfies the app.

Then that says the access to the objects you are trying to access have been (correctly) set up with SQL Privileges that have been bundled in a ROLE.  SQL Privileges belong to a database, not a server. 

This is *still* not an ODBC issue...If you have been connecting to that database using isql (which doesn't use ODBC) and the SYSDBA credentials *for your server*, you should be able to ascertain the roles that have been defined in that database, using SHOW ROLES.  SHOW GRANT should show you the name[s] of the user[s] that have been granted the respective roles.  To make it work, you will need to define that/those user[s] in your server's security database, logged in as SYSDBA.  And then, when you attempt to connect, you will need that user's login credentials PLUS the role name (which may or may not be case-sensitive, so assume it is...copy exact case from what SHOW ROLES displays and wrap in double quotes if SHOW ROLES displays something other than all-caps.

>The other app is the Database Browser. It has the capability to connect
>directly - or via ODBC. It will connect to the database, directly. It will
>NOT connect to the same database via ODBC.

If we are talking about the same database browser (DBrowser.exe) then look at my posting from last week, which shows a screenshot of a successful ODBC connection made by that application.  However, that browser is pretty generic...it probably doesn't even know about roles.

HB