Menu
▾
▴
firebird-odbc-devel
|
From: Carsten U. <Car...@mo...> - 2011-05-18 14:09:25
|
Hello, I want to open a table where the primary key is a varchar(50) Column with charset utf8. MS Access (2010) shows the Value #deleted for all columns. If I change the charset of the primary key column to ISO8859_1 it works. I use ODBC driver version 2.00.00.151 Thanks Carsten |
|
From: Henner K. <Hen...@gm...> - 2011-05-23 11:50:35
|
This is a problem using UTF-8. It's described here: http://www.easysoft.com/support/kb/kb00929.html. I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR and created a new MsVc90 project to generate an odbc driver named "Firebird driver for MS Access". This new driver works with MS Access 2003 and 2007 with Unicode databases. Regards, Henner > -----Ursprüngliche Nachricht----- > Von: Carsten Ulrich [mailto:Car...@mo...] > Gesendet: Mittwoch, 18. Mai 2011 15:50 > An: fir...@li... > Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 primary > key > > Hello, > I want to open a table where the primary key is a varchar(50) Column with > charset utf8. MS Access (2010) shows the Value #deleted for all columns. If I > change the charset of the primary key column to ISO8859_1 it works. > > I use ODBC driver version 2.00.00.151 > > Thanks > Carsten > > ---------------------------------------------------------------------------- -- > What Every C/C++ and Fortran developer Should Know! > Read this article and learn how Intel has extended the reach of its next- > generation tools to help Windows* and Linux* C/C++ and Fortran developers > boost performance applications - including clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Jorge A. B. <li...@da...> - 2015-02-10 01:54:20
|
Hi. I´m using 2.0.3.154 odbc driver and a similar issue. Was the patch merged into ODBC driver? Thanks! El 23/05/2011 08:50 a.m., Henner Kollmann escribió: > This is a problem using UTF-8. > > It's described here: > > http://www.easysoft.com/support/kb/kb00929.html. > > > I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR > and created a new MsVc90 project to generate an odbc driver named "Firebird > driver for MS Access". > > This new driver works with MS Access 2003 and 2007 with Unicode databases. > > Regards, > Henner > >> -----Ursprüngliche Nachricht----- >> Von: Carsten Ulrich [mailto:Car...@mo...] >> Gesendet: Mittwoch, 18. Mai 2011 15:50 >> An: fir...@li... >> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 > primary >> key >> >> Hello, >> I want to open a table where the primary key is a varchar(50) Column with >> charset utf8. MS Access (2010) shows the Value #deleted for all columns. > If I >> change the charset of the primary key column to ISO8859_1 it works. >> >> I use ODBC driver version 2.00.00.151 >> >> Thanks >> Carsten >> >> > ---------------------------------------------------------------------------- > -- >> What Every C/C++ and Fortran developer Should Know! >> Read this article and learn how Intel has extended the reach of its next- >> generation tools to help Windows* and Linux* C/C++ and Fortran developers >> boost performance applications - including clusters. >> http://p.sf.net/sfu/intel-dev2devmay >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > ------------------------------------------------------------------------------ > What Every C/C++ and Fortran developer Should Know! > Read this article and learn how Intel has extended the reach of its > next-generation tools to help Windows* and Linux* C/C++ and Fortran > developers boost performance applications - including clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > -- Jorge Andrés Brugger Departamento de 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 "No podemos resolver problemas pensando de la misma manera que cuando los creamos" (Albert Einstein) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. |
|
From: Alexander P. <ale...@gm...> - 2015-02-10 07:11:55
|
Hi, There is no universal patch for Firebird ODBC driver now. I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124. On 09.02.2015 18:57, Jorge Andrés Brugger wrote: > Hi. > > I´m using 2.0.3.154 odbc driver and a similar issue. > > Was the patch merged into ODBC driver? > > Thanks! > > El 23/05/2011 08:50 a.m., Henner Kollmann escribió: >> This is a problem using UTF-8. >> >> It's described here: >> >> http://www.easysoft.com/support/kb/kb00929.html. >> >> >> I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR >> and created a new MsVc90 project to generate an odbc driver named "Firebird >> driver for MS Access". >> >> This new driver works with MS Access 2003 and 2007 with Unicode databases. >> >> Regards, >> Henner >> >>> -----Ursprüngliche Nachricht----- >>> Von: Carsten Ulrich [mailto:Car...@mo...] >>> Gesendet: Mittwoch, 18. Mai 2011 15:50 >>> An: fir...@li... >>> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 >> primary >>> key >>> >>> Hello, >>> I want to open a table where the primary key is a varchar(50) Column with >>> charset utf8. MS Access (2010) shows the Value #deleted for all columns. >> If I >>> change the charset of the primary key column to ISO8859_1 it works. >>> >>> I use ODBC driver version 2.00.00.151 >>> >>> Thanks >>> Carsten >>> >>> >> ---------------------------------------------------------------------------- >> -- >>> What Every C/C++ and Fortran developer Should Know! >>> Read this article and learn how Intel has extended the reach of its next- >>> generation tools to help Windows* and Linux* C/C++ and Fortran developers >>> boost performance applications - including clusters. >>> http://p.sf.net/sfu/intel-dev2devmay >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> ------------------------------------------------------------------------------ >> What Every C/C++ and Fortran developer Should Know! >> Read this article and learn how Intel has extended the reach of its >> next-generation tools to help Windows* and Linux* C/C++ and Fortran >> developers boost performance applications - including clusters. >> http://p.sf.net/sfu/intel-dev2devmay >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> >> -- Alexander Potapchenko Team leader LASP Technologies, http://www.lasptech.ru |
|
From: Jorge A. B. <li...@da...> - 2015-02-10 12:04:10
|
Thanks Alexander. The patched driver works with Win7 and Access 2013. I know it´s a MS Access issue, but there is any chance to integrate the "fix" someway in Firebird ODBC driver? Regards! El 10/02/2015 04:11 a.m., Alexander Potapchenko escribió: > Hi, > > There is no universal patch for Firebird ODBC driver now. > I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124. > > On 09.02.2015 18:57, Jorge Andrés Brugger wrote: >> Hi. >> >> I´m using 2.0.3.154 odbc driver and a similar issue. >> >> Was the patch merged into ODBC driver? >> >> Thanks! >> >> El 23/05/2011 08:50 a.m., Henner Kollmann escribió: >>> This is a problem using UTF-8. >>> >>> It's described here: >>> >>> http://www.easysoft.com/support/kb/kb00929.html. >>> >>> >>> I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR >>> and created a new MsVc90 project to generate an odbc driver named "Firebird >>> driver for MS Access". >>> >>> This new driver works with MS Access 2003 and 2007 with Unicode databases. >>> >>> Regards, >>> Henner >>> >>>> -----Ursprüngliche Nachricht----- >>>> Von: Carsten Ulrich [mailto:Car...@mo...] >>>> Gesendet: Mittwoch, 18. Mai 2011 15:50 >>>> An: fir...@li... >>>> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 >>> primary >>>> key >>>> >>>> Hello, >>>> I want to open a table where the primary key is a varchar(50) Column with >>>> charset utf8. MS Access (2010) shows the Value #deleted for all columns. >>> If I >>>> change the charset of the primary key column to ISO8859_1 it works. >>>> >>>> I use ODBC driver version 2.00.00.151 >>>> >>>> Thanks >>>> Carsten >>>> >>>> >>> ---------------------------------------------------------------------------- >>> -- >>>> What Every C/C++ and Fortran developer Should Know! >>>> Read this article and learn how Intel has extended the reach of its next- >>>> generation tools to help Windows* and Linux* C/C++ and Fortran developers >>>> boost performance applications - including clusters. >>>> http://p.sf.net/sfu/intel-dev2devmay >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> ------------------------------------------------------------------------------ >>> What Every C/C++ and Fortran developer Should Know! >>> Read this article and learn how Intel has extended the reach of its >>> next-generation tools to help Windows* and Linux* C/C++ and Fortran >>> developers boost performance applications - including clusters. >>> http://p.sf.net/sfu/intel-dev2devmay >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> >>> > -- Jorge Andrés Brugger Departamento de 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 "El verdadero modo de no saber nada es aprenderlo todo a la vez." (George Sand) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. |
|
From: Alexander P. <ale...@gm...> - 2015-02-10 12:20:35
|
Jorge, It is a not priority improvement at this moment, but I can build special installers with this fix for a while. On 10.02.2015 15:03, Jorge Andrés Brugger wrote: > Thanks Alexander. > > The patched driver works with Win7 and Access 2013. > > I know it´s a MS Access issue, but there is any chance to integrate the > "fix" someway in Firebird ODBC driver? > > Regards! > > El 10/02/2015 04:11 a.m., Alexander Potapchenko escribió: >> Hi, >> >> There is no universal patch for Firebird ODBC driver now. >> I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124. >> >> On 09.02.2015 18:57, Jorge Andrés Brugger wrote: >>> Hi. >>> >>> I´m using 2.0.3.154 odbc driver and a similar issue. >>> >>> Was the patch merged into ODBC driver? >>> >>> Thanks! >>> >>> El 23/05/2011 08:50 a.m., Henner Kollmann escribió: >>>> This is a problem using UTF-8. >>>> >>>> It's described here: >>>> >>>> http://www.easysoft.com/support/kb/kb00929.html. >>>> >>>> >>>> I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR >>>> and created a new MsVc90 project to generate an odbc driver named "Firebird >>>> driver for MS Access". >>>> >>>> This new driver works with MS Access 2003 and 2007 with Unicode databases. >>>> >>>> Regards, >>>> Henner >>>> >>>>> -----Ursprüngliche Nachricht----- >>>>> Von: Carsten Ulrich [mailto:Car...@mo...] >>>>> Gesendet: Mittwoch, 18. Mai 2011 15:50 >>>>> An: fir...@li... >>>>> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 >>>> primary >>>>> key >>>>> >>>>> Hello, >>>>> I want to open a table where the primary key is a varchar(50) Column with >>>>> charset utf8. MS Access (2010) shows the Value #deleted for all columns. >>>> If I >>>>> change the charset of the primary key column to ISO8859_1 it works. >>>>> >>>>> I use ODBC driver version 2.00.00.151 >>>>> >>>>> Thanks >>>>> Carsten >>>>> >>>>> >>>> ---------------------------------------------------------------------------- >>>> -- >>>>> What Every C/C++ and Fortran developer Should Know! >>>>> Read this article and learn how Intel has extended the reach of its next- >>>>> generation tools to help Windows* and Linux* C/C++ and Fortran developers >>>>> boost performance applications - including clusters. >>>>> http://p.sf.net/sfu/intel-dev2devmay >>>>> _______________________________________________ >>>>> Firebird-odbc-devel mailing list >>>>> Fir...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> ------------------------------------------------------------------------------ >>>> What Every C/C++ and Fortran developer Should Know! >>>> Read this article and learn how Intel has extended the reach of its >>>> next-generation tools to help Windows* and Linux* C/C++ and Fortran >>>> developers boost performance applications - including clusters. >>>> http://p.sf.net/sfu/intel-dev2devmay >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> >>>> -- Alexander Potapchenko Team leader LASP Technologies, http://www.lasptech.ru |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X