Actual odbc-driver build and Firebird 2.1.x

[Jorge Andrés Brugger]

Anyone is using ODBC driver with Firebird 2.1.x? There is some issue?

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 [phone] int. 103
Correo electrónico: jbrugger@...
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Sergio Maurelli]

Jorge:

We are using it, with Clarion Apps. So far, so good.

Sergio

[Spanish]
Nosotros lo usamos, con aplicaciones Clarion. Hasta ahora, todo bien.

Saludos

Sergio
[/Spanish]


Jorge Andrés Brugger escribió:

> Anyone is using ODBC driver with Firebird 2.1.x? There is some issue?
>
> Thanks!
>
> -- =
>
> Jorge Andr=E9s Brugger
> Inform=E1tica
> DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
> Comodoro Rivadavia, Chubut, Argentina
> Tel=E9fono [phone] int. 103
> Correo electr=F3nico: jbrugger@...
> 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 priz=
> es
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=3D100&url=3D/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Firebird-odbc-devel@...
> 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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Maycon Ferraça-2]

Hello!

Yes! I've been using it since the 2.1 pre-alpha version and I haven't
found any problem yet.

Maycon Ferraca

Jorge Andrés Brugger wrote:

> Anyone is using ODBC driver with Firebird 2.1.x? There is some issue?
>
> Thanks!
>
> -- =
>
> Jorge Andr=E9s Brugger
> Inform=E1tica
> DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
> Comodoro Rivadavia, Chubut, Argentina
> Tel=E9fono [phone] int. 103
> Correo electr=F3nico: jbrugger@...
> 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 priz=
> es
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=3D100&url=3D/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Firebird-odbc-devel@...
> 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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Nikolay Samofatov]

Jorge, Paul,

We ship and support ODBC driver based on 2.0 code base with Red Database
2.1 (whose engine is based on Firebird 2.1.X).
We encountered no significant issues so far. In actual projects, we use
Firebird 2.1 database as the back-end storage for MS Project 2003 via
ODBC, for example.

Another division at Red Soft uses ODBC driver as the connectivity layer
for large, mature and complex funds transfer system for banks and
municipal governments originally developed by BSS company.
The system can run on various DBMS including Sybase ASA and Access, and
thus its authors had developed quite a bit of understanding of ODBC thin
areas.

The system has ODBC driver testsuite with hundreds of functional tests,
and Vladimir used it regularly to detect problems. I can try to obtain
recent version of the testsuite (as 32-bit Windows binary only) and give
it to Paul.
Paul, would it be useful? Should I initiate this process?

Jorge Andrés Brugger wrote:
> Anyone is using ODBC driver with Firebird 2.1.x? There is some issue?
>
> Thanks!
>  
--
Nikolay Samofatov, MBA
Red Soft International
[phone]



-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Paul Reeves-2]

On Tuesday 29 July 2008, Nikolay Samofatov wrote:
>
> The system has ODBC driver testsuite with hundreds of functional tests,
> and Vladimir used it regularly to detect problems. I can try to obtain
> recent version of the testsuite (as 32-bit Windows binary only) and give
> it to Paul.
> Paul, would it be useful? Should I initiate this process?
>

It would be useful, but only if the source code was available.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Specialists in Firebird support

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Jorge Andrés Brugger]

Nikolay, thanks for the "push" on ODBC driver development.

What about http://tracker.firebirdsql.org/browse/ODBC-32 in Red-Soft
ODBC driver build? (I´m still using 2.0.142 because 2.0.144 has that bug
that is a showstopper for us).

Regards!

Nikolay Samofatov escribió:

> Jorge, Paul,
>
> We ship and support ODBC driver based on 2.0 code base with Red Database
> 2.1 (whose engine is based on Firebird 2.1.X).
> We encountered no significant issues so far. In actual projects, we use
> Firebird 2.1 database as the back-end storage for MS Project 2003 via
> ODBC, for example.
>
> Another division at Red Soft uses ODBC driver as the connectivity layer
> for large, mature and complex funds transfer system for banks and
> municipal governments originally developed by BSS company.
> The system can run on various DBMS including Sybase ASA and Access, and
> thus its authors had developed quite a bit of understanding of ODBC thin
> areas.
>
> The system has ODBC driver testsuite with hundreds of functional tests,
> and Vladimir used it regularly to detect problems. I can try to obtain
> recent version of the testsuite (as 32-bit Windows binary only) and give
> it to Paul.
> Paul, would it be useful? Should I initiate this process?
>
> Jorge Andrés Brugger wrote:
>  
>> Anyone is using ODBC driver with Firebird 2.1.x? There is some issue?
>>
>> 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 [phone] int. 103
Correo electrónico: jbrugger@...
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Nikolay Samofatov]

Jorge,

Jorge Andrés Brugger wrote:
> Nikolay, thanks for the "push" on ODBC driver development.
>
> What about http://tracker.firebirdsql.org/browse/ODBC-32 in Red-Soft
> ODBC driver build? (I´m still using 2.0.142 because 2.0.144 has that bug
> that is a showstopper for us).
>  
Red Soft build has this issue too, AFAIK. I have forwarded it to R&D
team, but the issue has medium-to-low priority for us today.

--
Nikolay Samofatov, MBA
Red Soft International
[phone]


-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[bill lam]

Nikolay Samofatov wrote:
> We ship and support ODBC driver based on 2.0 code base with Red Database
> 2.1 (whose engine is based on Firebird 2.1.X).
> We encountered no significant issues so far. In actual projects, we use
> Firebird 2.1 database as the back-end storage for MS Project 2003 via
> ODBC, for example.
>

Does your odbc driver work with in 64-bit mode under win xp64 or unicode mode
under linux?

regards,

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Roman Simakov]

bill lam wrote:

> Nikolay Samofatov wrote:
>  
>> We ship and support ODBC driver based on 2.0 code base with Red Database
>> 2.1 (whose engine is based on Firebird 2.1.X).
>> We encountered no significant issues so far. In actual projects, we use
>> Firebird 2.1 database as the back-end storage for MS Project 2003 via
>> ODBC, for example.
>>
>>    
>
> Does your odbc driver work with in 64-bit mode under win xp64 or unicode mode
> under linux?
>  

Bill, we have x64 build of ODBC driver, but it has known issues and we
didn't deploy it yet. Red Database 2.1.1 should includes fixed x64 ODBC
driver.
About Unicode mode under Linux I can say that we did not make any
special overpatching. And why It should not work in Unicode mode under
Linux?

--
Best Regards,
Roman Simakov
Red Soft Corp.

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[bill lam]

Roman Simakov wrote:
> About Unicode mode under Linux I can say that we did not make any
> special overpatching. And why It should not work in Unicode mode under
> Linux?

In the last communication with Vladimir, we discussed on the issue over the size
of SQLWCHAR and wchar_t,  he said he needed think about it.

When calling sqlconnectW, what is C type of the connection string? UTF-16 or
native wchar_t?  A more involved problem will the column binding.

regards,

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Roman Simakov]

bill lam wrote:

> Roman Simakov wrote:
>  
>> About Unicode mode under Linux I can say that we did not make any
>> special overpatching. And why It should not work in Unicode mode under
>> Linux?
>>    
>
> In the last communication with Vladimir, we discussed on the issue over the size
> of SQLWCHAR and wchar_t,  he said he needed think about it.
>
> When calling sqlconnectW, what is C type of the connection string? UTF-16 or
> native wchar_t?  A more involved problem will the column binding.
>  

In Microsoft Visual Studio 8\VC\PlatformSDK\Include\sqltypes.h SQLWCHAR
is declared as

#ifdef _WCHAR_T_DEFINED
typedef wchar_t SQLWCHAR;
#else
typedef unsigned short SQLWCHAR;
#endif

But in Windows wchat_t contains UTF-16 encoded chars. In Unix-like
systems it size is 32 bit.
Here is a description of some aspects of communication of application,
driver manager and driver.
http://www.datadirect.com/developer/odbc/unicode/index.ssp.

As I understand on Windows SQLWCHAR should be encoded as UTF-16. On Unix
it is controlled by SQL_ATTR_APP_UNICODE_TYPE and
SQL_ATTR_DRIVER_UNICODE_TYPE attribute values.
It's very important role Driver Manager plays. It defines what encoding
it can recieve and send from/to driver/application.

Summary. Roughly speaking, on Windows Unicode is UTF-16 or native
wchar_t. On Linux - UTF-8 or UTF-16 according to
SQL_ATTR_APP_UNICODE_TYPE and SQL_ATTR_DRIVER_UNICODE_TYPE attributes
and ODBC driver manager.

I could missing something :)

Roman Simakov
>  
> regards,
>  

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[bill lam]

Roman Simakov wrote:
> Summary. Roughly speaking, on Windows Unicode is UTF-16 or native
> wchar_t. On Linux - UTF-8 or UTF-16 according to
> SQL_ATTR_APP_UNICODE_TYPE and SQL_ATTR_DRIVER_UNICODE_TYPE attributes
> and ODBC driver manager.
>
> I could missing something :)

Thank you for information. iirc unixodbc does not have these two options. The
size of SQLWCHAR have to be chosen to be either 2 or 4 during compilation of
unixodbc. Are they datadirect specific extension? afaik software from datadirect
are neither open-source nor freeware.

I could missing something too :)

regards,

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Roman Simakov]

bill lam wrote:

> Roman Simakov wrote:
>  
>> Summary. Roughly speaking, on Windows Unicode is UTF-16 or native
>> wchar_t. On Linux - UTF-8 or UTF-16 according to
>> SQL_ATTR_APP_UNICODE_TYPE and SQL_ATTR_DRIVER_UNICODE_TYPE attributes
>> and ODBC driver manager.
>>
>> I could missing something :)
>>    
>
> Thank you for information. iirc unixodbc does not have these two options. The
> size of SQLWCHAR have to be chosen to be either 2 or 4 during compilation of
> unixodbc. Are they datadirect specific extension? afaik software from datadirect
> are neither open-source nor freeware.
>  

I don't now about any specific datadirect extentions.
It seems unixODBC uses UCS-2.
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/c0011522.htm

Roman Simakov


-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Minoru Yoshida-2]

Hi,

I'm testing it with office 2003 japanese edition by UTF8 connection.
I have no problem. I will tests it at new release version :-)

--
Regards,
Minoru

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Jorge Andres Brugger-3]

Nikolay Samofatov escribió:

Jorge,

Jorge Andrés Brugger wrote:
  

Nikolay, thanks for the "push" on ODBC driver development.

What about http://tracker.firebirdsql.org/browse/ODBC-32 in Red-Soft 
ODBC driver build? (I´m still using 2.0.142 because 2.0.144 has that bug 
that is a showstopper for us).
  
    

Red Soft build has this issue too, AFAIK. I have forwarded it to R&D 
team, but the issue has medium-to-low priority for us today.

  

It´s completely understandable, but "medium-to-low" it´s better than "none" ;)

I hope ODBC drive can be actively developed again.

Regards

-------------------------------------------------------------------------
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
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel