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

Re: [Firebird-odbc-devel] Transaction

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

>Gabriel Centenari wrote:
>> Hi,
>>
>> I'm new in firebird (Firebird-2.1.1.17910-0_Win32).
>> I'm trying to migrate from MsSql.
>> I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC 
>> (Firebird_ODBC_1.2.0.69-Win32).
>>
>> In Mssql I open a Transaction sending: BEGIN TRAN
>>
>> Now I'm trying to open using: SET TRANSACTION
>> But the server response:
>>
>> invalid transaction handle (expecting explicit transaction start)
>>
>> What am I doing wrong?

At 02:09 AM 5/12/2008, Alexander Potapchenko wrote:

>   
>Please use Firebird support list.
>http://tech.groups.yahoo.com/group/firebird-support/
>Subscribe: fir...@ya...

No Alexander, I sent Gabriel here because this is an ODBC-specific question:  someone needs to tell him how the ODBC driver implements SET TRANSACTION (gets handle, initialises handle) so that he can use it in his program. The docs refer to "declaring" a transaction (which is not in SQL) but they don't say what you have to do.

>For Firebird 2.1 you need ODBC  Driver V2.0 
>(http://firebirdsql.org/index.php?op=files&id=odbc 
><http://firebirdsql.org/index.php?op=files&id=odbc>)

Thanks,
Helen

Re: [Firebird-odbc-devel] ODBC Driver v.2 Release Candidate 1 is Ready

[eg <eg...@gm...>]

Alexander Potapchenko wrote:
> Hi all,
> 
> ODBC Driver v.2 RC1 (2.0.0.148) got out, all packages (with sources and 
> changelog) are available here:
> http://firebirdsql.org/index.php?op=files&id=odbc 
> <http://firebirdsql.org/index.php?op=files&id=odbc>
> Please test these thoroughly and report experiences, good or bad, to the 
> firebird-odbc-devel list.
> 
> Regards
> Alexander

I would like to test this with our embedded application.
There does not seem to be a .lib file provided with the dll package. Is 
it possible to get one?

I tried to make one (for VS2008) from the DLL using the procedure found 
in:  http://support.microsoft.com/?id=131313  ... but I get connection 
errors at run time. Those errors are not there if I link my app with an 
older library and just drop the new DLL in place (so I am pretty sure 
the procedure didn't work).

I know I can build it from sources... but then I also need to find the 
correct versions of firebird header files (ibase.h, iberror.h, etc). 
What version of these header files were used and should be used to build 
the odbcfb.dll?

Re: [Firebird-odbc-devel] Commas, Stored Procedures and string parameters

[Jorge A. B. <jor...@gm...>]

Done: http://tracker.firebirdsql.org/browse/ODBC-52

2008/12/4 Alexander Potapchenko <ale...@re...>

> Jorge Andrés Brugger wrote:
> > call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')
> >
> > and works fine. But it including a comma in string, like:
> >
> > call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')
> >
> > it fails with "SQL Error code -104 Unexpected end of command - line 1,
> > column 51"
> >
> >
> It is a bug, the tracker at your service.
>
> Alexander
> --
> Alexander Potapchenko
> http://www.red-soft.biz
> Senior developer
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

Re: [Firebird-odbc-devel] Commas, Stored Procedures and string parameters

[Jorge A. B. <jor...@gm...>]

If I replace "call" for "execute procedure" works fine, comma included.

Could be a "call" implementation bug?

2008/12/4 Jorge Andrés Brugger <li...@da...>

> Hi.
>
> I´ve a SP that receives a string (varchar) as parameter. It´s something
> like:
>
> CREATE PROCEDURE SP_EMITIR_PEDIDO_INTERNO (
>    sucursal smallint,
>    numero_pedido_interno integer,
>    usuario smallint,
>    observaciones varchar(2500))
> as
> begin
>  /* do something */
>  exit;
> end
>
>  From my app, I call it as:
>
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')
>
> and works fine. But it including a comma in string, like:
>
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')
>
> it fails with "SQL Error code -104 Unexpected end of command - line 1,
> column 51"
>
> ¿Why?
>
> Thanks.
>
> --
> Jorge Andrés Brugger
> Informática
> DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
> Comodoro Rivadavia, Chubut, Argentina
> Teléfono (0297) 446-4444 int. 103
> Correo electrónico: jbr...@da...
> Website: www.dasu.com.ar
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

Re: [Firebird-odbc-devel] Commas, Stored Procedures and string parameters

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

Jorge Andrés Brugger wrote:
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')
>
> and works fine. But it including a comma in string, like:
>
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')
>
> it fails with "SQL Error code -104 Unexpected end of command - line 1, 
> column 51"
>
>   
It is a bug, the tracker at your service.

Alexander
-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

[Firebird-odbc-devel] Commas, Stored Procedures and string parameters

[Jorge A. B. <li...@da...>]

Hi.

I´ve a SP that receives a string (varchar) as parameter. It´s something 
like:

CREATE PROCEDURE SP_EMITIR_PEDIDO_INTERNO (
    sucursal smallint,
    numero_pedido_interno integer,
    usuario smallint,
    observaciones varchar(2500))
as
begin
  /* do something */
  exit;
end

 From my app, I call it as:

call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')

and works fine. But it including a comma in string, like:

call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')

it fails with "SQL Error code -104 Unexpected end of command - line 1, 
column 51"

¿Why?

Thanks.

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

Re: [Firebird-odbc-devel] Transaction

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

Gabriel Centenari wrote:
> Hi,
>
> I'm new in firebird (Firebird-2.1.1.17910-0_Win32).
> I'm trying to migrate from MsSql.
> I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC 
> (Firebird_ODBC_1.2.0.69-Win32).
>
> In Mssql I open a Transaction sending: BEGIN TRAN
>
> Now I'm trying to open using: SET TRANSACTION
> But the server response:
>
> invalid transaction handle (expecting explicit transaction start)
>
> What am I doing wrong?
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>   
Please use Firebird support list.
http://tech.groups.yahoo.com/group/firebird-support/
Subscribe: fir...@ya...
For Firebird 2.1 you need ODBC  Driver V2.0 
(http://firebirdsql.org/index.php?op=files&id=odbc 
<http://firebirdsql.org/index.php?op=files&id=odbc>)

Regards,
Alexander
-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

Re: [Firebird-odbc-devel] OLAP-Navigator (was: odbc driver question)

[Nikolay S. <nik...@re...>]

Thomas,

Let's move this topic to olap-navigator-general. It is probably 
off-topic in firebird-odbc-devel.

Please see my comments below.

Thomas Steinmaurer wrote:
> Nikolay,
>
>   
>> Jorge was not exactly precise. :-)
>>
>> There is no specific long-term ODBC development budget at Red Soft.
>>
>> 1) So on one side, ODBC driver development is currently driven by client 
>> requests. This is when I can become heavily involved.
>> About half of ODBC bug fixes in builds since 145 are done because 
>> BroadView Software asked them done.
>>
>> So in my Open Source life right now I spend more time with the project 
>> which adds OLAP extensions and GUI to Firebird databases:
>> http://olap-navigator.sourceforge.net/
>>     
>
>  From previous email conversation you might know that I'm building a 
> data warehousing system with Mondrian and Firebird. The lack of a 
> capable and modern looking OLAP client for Mondrian is IMHO one major 
> drawback when comparing an Open Source OLAP solution with e.g. the 
> Microsoft world (Analysis Services, ...).
>
> I've tried the JPivot based solution included in Mondrian. Well, a first 
> start and possibly a solution for prototypical implementations for 
> ad-hoc queries, but compared to commercial products it looks plain oldish.
>
> I've also tried the freely available JPalo 2.0 OLAP client which can 
> interact with a XML/A server. It looks much more modern and a first try 
> was encouraging with less data volume, but it went out to be VERY slow 
> when working with larger data volumes. The web-based JPivot application 
> was much more responsive in that case.
>   
In olap-navigator we spent a great deal of effort to implement 
server-side grid rendering and page-by-page navigation.
So its rendering performance should be ok.
> So I have downloaded your OLAP navigator. I've deployed the .war file on 
> my Apache Tomcat web server, but where to start now to get connected to 
> my Mondrian cube?
>   
I tried to explain the procedure on project wiki, but this is probably 
not enough.
Please get in touch with me via some Instant messanging, e.g. 
nikolay.samofatov Skype name or 114101470 ICQ and I will walk you 
through the set-up process.
> Do you know any other OLAP client with support for Mondrian? It does not 
> need to be a web-based application. The Pentaho Spreadsheet Services 
> might be a solution for an integration into Excel, but AFAIK it's rather 
> expensive due to the mandatory Pentaho subscription. Another one I came 
> across is IntraSight (http://www.activeinterface.com/intrasight.html). 
> Ever tried that?
>   
No, I didn't try it. The landscape in Open Source BI changes rather 
quickly. New tools appear and get abandoned in a matter of months. I'm 
not used to that from my Firebird experience :-)

For ad-hoc OLAP browsing we use updated and heavily modified JRubik. 
Since the main repository of JRubik appears abandoned, I may put it into 
olap-navigator CVS if you are interested.

Olap Navigator is not really an ad-hoc slicer dicer, although it would 
be easy to create one based on it,
Instead Olap Navigator aims to be Data Warehouse GUI builder. The end 
product (defined in Olap Naviator resources) is geared not to 
sophisticated analysts, but to regular users.

We also use pretty sophisticated ETL toolset for Firebird - Red Replicator.
It is probably mis-named because replication logging is only a little 
part of its functionality. In data warehousing environment we use it to 
maintain materialized views across database links (via Firebird API, 
Oracle flashback/versions query, ODBC, or even FTP). I probably can open 
its source as well - this needs to be discussed with Sean Leyne of 
BroadView and Red Soft management, but I see no major obstacles for that 
either.

> Thanks.
>   
-- 
Nikolay Samofatov, MBA
Red Soft International
+1 416 710 6854

[Firebird-odbc-devel] Transaction

[Gabriel C. <gab...@xs...>]

Hi,

I'm new in firebird (Firebird-2.1.1.17910-0_Win32).
I'm trying to migrate from MsSql.
I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC 
(Firebird_ODBC_1.2.0.69-Win32).

In Mssql I open a Transaction sending: BEGIN TRAN

Now I'm trying to open using: SET TRANSACTION
But the server response:

invalid transaction handle (expecting explicit transaction start)

What am I doing wrong?

[Firebird-odbc-devel] Transaction

[Gabriel C. <gab...@xs...>]

Hi,

I'm new in firebird (Firebird-2.1.1.17910-0_Win32).
I trying to migrate from MsSql.
I'm promgraming in Clarion 6.3 and connecting to firebird via ODBC 
(Firebird_ODBC_1.2.0.69-Win32).

In Mssql I open a Transaction sending: BEGIN TRAN

Now I'm trying to open using: SET TRANSACTION
But the server response:

invalid transaction handle (expecting explicit transaction start)

What am I doing wrong?

Lic. Gabriel H. Centenari

Re: [Firebird-odbc-devel] OLAP-Navigator (was: odbc driver question)

[Thomas S. <ts...@ib...>]

Nikolay,

> Jorge was not exactly precise. :-)
> 
> There is no specific long-term ODBC development budget at Red Soft.
> 
> 1) So on one side, ODBC driver development is currently driven by client 
> requests. This is when I can become heavily involved.
> About half of ODBC bug fixes in builds since 145 are done because 
> BroadView Software asked them done.
> 
> So in my Open Source life right now I spend more time with the project 
> which adds OLAP extensions and GUI to Firebird databases:
> http://olap-navigator.sourceforge.net/

 From previous email conversation you might know that I'm building a 
data warehousing system with Mondrian and Firebird. The lack of a 
capable and modern looking OLAP client for Mondrian is IMHO one major 
drawback when comparing an Open Source OLAP solution with e.g. the 
Microsoft world (Analysis Services, ...).

I've tried the JPivot based solution included in Mondrian. Well, a first 
start and possibly a solution for prototypical implementations for 
ad-hoc queries, but compared to commercial products it looks plain oldish.

I've also tried the freely available JPalo 2.0 OLAP client which can 
interact with a XML/A server. It looks much more modern and a first try 
was encouraging with less data volume, but it went out to be VERY slow 
when working with larger data volumes. The web-based JPivot application 
was much more responsive in that case.

So I have downloaded your OLAP navigator. I've deployed the .war file on 
my Apache Tomcat web server, but where to start now to get connected to 
my Mondrian cube?

Do you know any other OLAP client with support for Mondrian? It does not 
need to be a web-based application. The Pentaho Spreadsheet Services 
might be a solution for an integration into Excel, but AFAIK it's rather 
expensive due to the mandatory Pentaho subscription. Another one I came 
across is IntraSight (http://www.activeinterface.com/intrasight.html). 
Ever tried that?


Thanks.


-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/

Re: [Firebird-odbc-devel] Unable to download 2.0.148

[Puri V. <pur...@ya...>]

Thanks, Jorge and Alexander!!! I already downloaded it!!! Thanks again for your quick response

Puri Vidal




________________________________
De: Jorge Andrés Brugger <li...@da...>
Para: fir...@li...
Enviado: martes, 25 de noviembre, 2008 15:33:38
Asunto: Re: [Firebird-odbc-devel] Unable to download 2.0.148

Site is currently down. I´ve uploaded files to 
http://www.ideaworks.com.ar/fbodbc/ for the meantime.

Redsoft should also have a download site, not sure about exact url.....

Regards.

Puri Vidal escribió:
> Hello!
>  
> I want to try ER/Studio with Firebird (2.0) so I need its ODBC driver. 
> After looking for information in firebird support mailing lists, I see 
> it is recommended to use version 2.0.148. Trying to download it from 
> http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc using right click 
> and save as on Version 2.0 RC1 - Windows Full Install 32bit 
> ( http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_win32.exe )
> I get an error window (in spanish, so this is a translation):
>  
> Internet Explorer can not download ...bird_ODBC_2.0.0.148_win32.exe 
> from www.firebirdsql.org <http://www.firebirdsql.org/>.
> Internet Explorer can not open this Internet site. It is not 
> available. Try it again later.
>  
> Is there a mirror or any other site where I can download this version? 
> It not, can I use version 1.2 (downloadee without any problems)?
>  
> Thank you in advance for your help
>  
> Puri Vidal
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>  

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



      

Re: [Firebird-odbc-devel] Unable to download 2.0.148

[Jorge A. B. <li...@da...>]

Site is currently down. I´ve uploaded files to 
http://www.ideaworks.com.ar/fbodbc/ for the meantime.

Redsoft should also have a download site, not sure about exact url.....

Regards.

Puri Vidal escribió:
> Hello!
>  
> I want to try ER/Studio with Firebird (2.0) so I need its ODBC driver. 
> After looking for information in firebird support mailing lists, I see 
> it is recommended to use version 2.0.148. Trying to download it from 
> http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc using right click 
> and save as on Version 2.0 RC1 - Windows Full Install 32bit 
> ( http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_win32.exe )
> I get an error window (in spanish, so this is a translation):
>  
> Internet Explorer can not download ...bird_ODBC_2.0.0.148_win32.exe 
> from www.firebirdsql.org <http://www.firebirdsql.org/>.
> Internet Explorer can not open this Internet site. It is not 
> available. Try it again later.
>  
> Is there a mirror or any other site where I can download this version? 
> It not, can I use version 1.2 (downloadee without any problems)?
>  
> Thank you in advance for your help
>  
> Puri Vidal
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>   

-- 
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

Re: [Firebird-odbc-devel] Unable to download 2.0.148

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

Puri Vidal wrote:
> Hello!
>  
> I want to try ER/Studio with Firebird (2.0) so I need its ODBC driver. 
> After looking for information in firebird support mailing lists, I see 
> it is recommended to use version 2.0.148. Trying to download it from 
> http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc using right click 
> and save as on Version 2.0 RC1 - Windows Full Install 32bit 
> ( http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_win32.exe )
> I get an error window (in spanish, so this is a translation):
>  
> Internet Explorer can not download ...bird_ODBC_2.0.0.148_win32.exe 
> from www.firebirdsql.org <http://www.firebirdsql.org/>.
> Internet Explorer can not open this Internet site. It is not 
> available. Try it again later.
>  
> Is there a mirror or any other site where I can download this version? 
> It not, can I use version 1.2 (downloadee without any problems)?
>  
> Thank you in advance for your help
>  
> Puri Vidal
Hi,
Firebird site is temporary unavailable. You can use Red Soft mirror:

http://www.red-soft.biz/files/downloads/odbc/changes-v20.log
http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_win32.exe
http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_x64.exe
http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_Win32.zip
http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_x64.zip
http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.amd64.tar.gz
http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz
http://www.red-soft.biz/files/downloads/odbc/OdbcFb-Source-RC1-2.0.0148.tar.gz 
<http://www.red-soft.biz/files/downloads/odbc/changes-v20.log,http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_win32.exe,http://www.red-soft.biz/files/downloads/odbc/Firebird_ODBC_2.0.0.148_x64.exe,http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_Win32.zip,http://www.red-soft.biz/files/downloads/odbc/OdbcFb_DLL_RC1_2-0-0148_x64.zip,http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.amd64.tar.gz,http://www.red-soft.biz/files/downloads/odbc/OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz,http://www.red-soft.biz/files/downloads/odbc/OdbcFb-Source-RC1-2.0.0148.tar.gz>

Regards
Alexander

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

[Firebird-odbc-devel] Unable to download 2.0.148

[Puri V. <pur...@ya...>]

Hello!
 
I want to try ER/Studio with Firebird (2.0) so I need its ODBC driver. After looking for information in firebird support mailing lists, I see it is recommended to use version 2.0.148. Trying to download it from http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc using right click and save as on Version 2.0 RC1 - Windows Full Install 32bit ( http://www.firebirdsql.org/download/prerelease/odbc/Firebird_ODBC_2.0.0.148_win32.exe )
I get an error window (in spanish, so this is a translation):
 
Internet Explorer can not download ...bird_ODBC_2.0.0.148_win32.exe from www.firebirdsql.org.
Internet Explorer can not open this Internet site. It is not available. Try it again later.
 
Is there a mirror or any other site where I can download this version? It not, can I use version 1.2 (downloadee without any problems)?
 
Thank you in advance for your help
 
Puri Vidal



      

Re: [Firebird-odbc-devel] ODBC Driver v.2 Release Candidate 1 is Readyto Test

[Minoru Y. <yo...@ti...>]

Alexander Potapchenko <ale...@re...> 
Fri, 21 Nov 2008 11:05:35 +0300 wrote:
>Minoru Yoshida wrote:
>> Hi,
>>
>> BLOB text column is not transliteration with UTF8 connection.
>> http://tracker.firebirdsql.org/browse/ODBC-44
>>
>> I retry it with RC1(Build 148 ).
>>
>> My environment: 
>>
>> - FB V2.0.4 
>> - Client connection: UTF8
>>
>> Case 1. Defaut charset: UTF8
>>
>> - VARCHAR is fine 
>> - BLOB text is NOT fine. 
>>
>> Case 2. Default charset: SJIS_0208(japanese charset)
>>
>> - VARCHAR is fine 
>> - BLOB text is fine. 
>> (Of cause, characters range is SJIS_0208 only) 
>>
>> I think that result must be the same at UTF8 client connection.
>>
>> Why is a result different? 
>>   
>I remember this strange problem (Firebird+ODBC+*ADO*), but my hands have 
>not reached its decision still. :-)
>I will revert to consideration of this problem in the near future.

I wait for your good decision. Thanks.

--
Regards,
Minoru

Re: [Firebird-odbc-devel] ODBC Driver v.2 Release Candidate 1 is Readyto Test

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

Minoru Yoshida wrote:
> Hi,
>
> BLOB text column is not transliteration with UTF8 connection.
> http://tracker.firebirdsql.org/browse/ODBC-44
>
> I retry it with RC1(Build 148 ).
>
> My environment: 
>
> - FB V2.0.4 
> - Client connection: UTF8
>
> Case 1. Defaut charset: UTF8
>
> - VARCHAR is fine 
> - BLOB text is NOT fine. 
>
> Case 2. Default charset: SJIS_0208(japanese charset)
>
> - VARCHAR is fine 
> - BLOB text is fine. 
> (Of cause, characters range is SJIS_0208 only) 
>
> I think that result must be the same at UTF8 client connection.
>
> Why is a result different? 
>   
I remember this strange problem (Firebird+ODBC+*ADO*), but my hands have 
not reached its decision still. :-)
I will revert to consideration of this problem in the near future.

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

Re: [Firebird-odbc-devel] ODBC Driver v.2 Release Candidate 1 is Readyto Test

[Minoru Y. <yo...@ti...>]

Hi,

BLOB text column is not transliteration with UTF8 connection.
http://tracker.firebirdsql.org/browse/ODBC-44

I retry it with RC1(Build 148 ).

My environment: 

- FB V2.0.4 
- Client connection: UTF8

Case 1. Defaut charset: UTF8

- VARCHAR is fine 
- BLOB text is NOT fine. 

Case 2. Default charset: SJIS_0208(japanese charset)

- VARCHAR is fine 
- BLOB text is fine. 
(Of cause, characters range is SJIS_0208 only) 

I think that result must be the same at UTF8 client connection.

Why is a result different? 

--
Regards,
Minoru

Alexander Potapchenko <ale...@re...> 
Thu, 20 Nov 2008 13:00:35 +0300 wrote:
>Hi all,
>
>ODBC Driver v.2 RC1 (2.0.0.148) got out, all packages (with sources and 
>changelog) are available here:
>http://firebirdsql.org/index.php?op=files&id=odbc 
><http://firebirdsql.org/index.php?op=files&id=odbc>
>Please test these thoroughly and report experiences, good or bad, to the 
>firebird-odbc-devel list.
>
>Regards
>Alexander
>-- 
>Alexander Potapchenko
>http://www.red-soft.biz
>Senior developer

[Firebird-odbc-devel] ODBC Driver v.2 Release Candidate 1 is Ready to Test

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

Hi all,

ODBC Driver v.2 RC1 (2.0.0.148) got out, all packages (with sources and 
changelog) are available here:
http://firebirdsql.org/index.php?op=files&id=odbc 
<http://firebirdsql.org/index.php?op=files&id=odbc>
Please test these thoroughly and report experiences, good or bad, to the 
firebird-odbc-devel list.

Regards
Alexander
-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

Re: [Firebird-odbc-devel] Firebird events through ODBC

[ionutz g. <ion...@ya...>]

Thanks (Multumesc) Dorin




________________________________
From: Dorin Vasilescu <dor...@ya...>
To: fir...@li...
Sent: Monday, November 10, 2008 1:57:24 PM
Subject: Re: [Firebird-odbc-devel] Firebird events through ODBC

 
There is already implemented for VFP
 
Check here
http://atvsoftware.com/
 
  
"ionutz gorea" <ion...@ya...> wrote in  message news:926...@we......
Hi,

Thanks for your answer......I'll look over the example and  I'll try to convert it into a Visual FoxPro one for  testing.

Regards
Ionutz




________________________________
 From: Alexander Potapchenko  <ale...@re...>
To: fir...@li...
Sent: Fri day, November 7, 2008 1:45:32  PM
Subject: Re:  [Firebird-odbc-devel] Firebird events through ODBC

ionutz gorea  wrote:
> Hi all,
>
> Is there a way to gain access to the  Firebird Events using the 
> standard IBPhoenix  ODBC?
>
Hi,
Yes, there is this feature in ODBC driver, you can  look at C++ examples 
here (TestEvent is included):
http://www.praktik.km.ua/downloads/OdbcTest.zip

Regards
Alexander

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior  developer

-------------------------------------------------------------------------
This  SF.Net email is sponsored by the Moblin Your Move Developer's  challenge
Build the coolest Linux based applications with Moblin SDK &  win great prizes
Grand prize is a trip for two to an Open Source event  anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-odbc-devel  mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


________________________________
 -------------------------------------------------------------------------
This  SF.Net email is sponsored by the Moblin Your Move Developer's  challenge
Build the coolest Linux based applications with Moblin SDK &  win great prizes
Grand prize is a trip for two to an Open Source event  anywhere in the  world
http://moblin-contest.org/redirect.php?banner_id=100&url=/ 
________________________________
 _______________________________________________
Firebird-odbc-devel  mailing  list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



      

Re: [Firebird-odbc-devel] Bug with OdbcParameter mapped to String

[Xiang <lxg...@ya...>]

I am learning asp.net. This issue has been annoying me for some time. 
On version 2.0.0.144, there are some abnormal behaviors in Visual Web Developer Express 2008:
1. The list of all tables in any one database(*.fdb) could not be displayed on the panel of database explorer through ODBC. (Even on driver ver2.0.0.147)
2. The string parameter issue as Dmitry Gusev reported. I am not familiar to ASP.NET, so I could not make sure what's the problem is until I found this conversation. sigh...It is really annoying. So it had better to announce it in the download page of ODBC driver at firebird.org. 

The first one above, I have one more thing to comment: *most of the time*, Visual Web Developer can not get the table list through ODBC connection. But sometimes, it can... ;-)

Regards


  "Alexander Potapchenko" <ale...@re...> ??????:490...@re......
  Dmitry Gusev wrote: 
    Not sure if this is the right place, but I've found a bug with OdbcParameter mapped to String column in SQL Query.

    My Environment:

      a.. Firebird-1.5.5.4926-3-Win32.exe 

      b.. Firebird_ODBC_2.0.0-Win32.exe 
      c.. Windows Vista Business 32bit 
      d.. .Net Framework 3.5 
    All tests should pass, but TestQueryWithStringParameter fails.

    I've downloaded Firebird .Net Provider and use FbXXX interfaces instead of OdbcXXX. With FbXXX all the tests passed.


  I can not reproduce it on last driver [Firebird_ODBC_2.0.0.147]. Please add it to the tracker (with the database (or database script) and full project sources).
  here: http://tracker.firebirdsql.org/browse/ODBC

  Regards,
  Alexander

  -- 

  Alexander Potapchenko
  http://www.red-soft.biz
  Senior developer 


------------------------------------------------------------------------------


  -------------------------------------------------------------------------
  This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
  Build the coolest Linux based applications with Moblin SDK & win great prizes
  Grand prize is a trip for two to an Open Source event anywhere in the world
  http://moblin-contest.org/redirect.php?banner_id=100&url=/


------------------------------------------------------------------------------


  _______________________________________________
  Firebird-odbc-devel mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] Firebird events through ODBC

[Dorin V. <dor...@ya...>]

There is already implemented for VFP

Check here
http://atvsoftware.com/


  "ionutz gorea" <ion...@ya...> wrote in message news:926...@we......
  Hi,

  Thanks for your answer......I'll look over the example and I'll try to convert it into a Visual FoxPro one for testing.

  Regards
  Ionutz




------------------------------------------------------------------------------
  From: Alexander Potapchenko <ale...@re...>
  To: fir...@li...
  Sent: Fri day, November 7, 2008 1:45:32 PM
  Subject: Re: [Firebird-odbc-devel] Firebird events through ODBC

  ionutz gorea wrote:
  > Hi all,
  >
  > Is there a way to gain access to the Firebird Events using the 
  > standard IBPhoenix ODBC?
  >
  Hi,
  Yes, there is this feature in ODBC driver, you can look at C++ examples 
  here (TestEvent is included):
  http://www.praktik.km.ua/downloads/OdbcTest.zip

  Regards
  Alexander

  -- 
  Alexander Potapchenko
  http://www.red-soft.biz
  Senior developer

  -------------------------------------------------------------------------
  This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
  Build the coolest Linux based applications with Moblin SDK & win great prizes
  Grand prize is a trip for two to an Open Source event anywhere in the world
  http://moblin-contest.org/redirect.php?banner_id=100&url=/
  _______________________________________________
  Firebird-odbc-devel mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel





------------------------------------------------------------------------------


  -------------------------------------------------------------------------
  This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
  Build the coolest Linux based applications with Moblin SDK & win great prizes
  Grand prize is a trip for two to an Open Source event anywhere in the world
  http://moblin-contest.org/redirect.php?banner_id=100&url=/


------------------------------------------------------------------------------


  _______________________________________________
  Firebird-odbc-devel mailing list
  Fir...@li...
  https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] Firebird events through ODBC

[ionutz g. <ion...@ya...>]

Hi,

Thanks for your answer......I'll look over the example and I'll try to convert it into a Visual FoxPro one for testing.

Regards
Ionutz




________________________________
From: Alexander Potapchenko <ale...@re...>
To: fir...@li...
Sent: Friday, November 7, 2008 1:45:32 PM
Subject: Re: [Firebird-odbc-devel] Firebird events through ODBC

ionutz gorea wrote:
> Hi all,
>
> Is there a way to gain access to the Firebird Events using the 
> standard IBPhoenix ODBC?
>
Hi,
Yes, there is this feature in ODBC driver, you can look at C++ examples 
here (TestEvent is included):
http://www.praktik.km.ua/downloads/OdbcTest.zip

Regards
Alexander

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



      

Re: [Firebird-odbc-devel] Firebird events through ODBC

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

ionutz gorea wrote:
> Hi all,
>
> Is there a way to gain access to the Firebird Events using the 
> standard IBPhoenix ODBC?
>
Hi,
Yes, there is this feature in ODBC driver, you can look at C++ examples 
here (TestEvent is included):
http://www.praktik.km.ua/downloads/OdbcTest.zip

Regards
Alexander

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer

Re: [Firebird-odbc-devel] Firebird events through ODBC

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

ionutz gorea wrote:
> Hi all,
>
> Is there a way to gain access to the Firebird Events using the 
> standard IBPhoenix ODBC?
>
> Ionutz
Hi,
Yes, there is this feature in ODBC driver, you can look at C++ examples 
here (TestEvent is included):
http://www.praktik.km.ua/downloads/OdbcTest.zip

Regards
Alexander

-- 
Alexander Potapchenko
http://www.red-soft.biz
Senior developer