Menu
▾
▴
firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(23) |
Sep
(6) |
Oct
(2) |
Nov
(2) |
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
(14) |
Mar
(16) |
Apr
(14) |
May
(25) |
Jun
(38) |
Jul
(22) |
Aug
(39) |
Sep
(3) |
Oct
(13) |
Nov
(47) |
Dec
(3) |
| 2003 |
Jan
(38) |
Feb
(39) |
Mar
(24) |
Apr
(57) |
May
(30) |
Jun
|
Jul
(39) |
Aug
(90) |
Sep
(41) |
Oct
(141) |
Nov
(158) |
Dec
(137) |
| 2004 |
Jan
(86) |
Feb
(169) |
Mar
(100) |
Apr
(83) |
May
(94) |
Jun
(77) |
Jul
(85) |
Aug
(54) |
Sep
(45) |
Oct
(36) |
Nov
(42) |
Dec
(70) |
| 2005 |
Jan
(46) |
Feb
(44) |
Mar
(50) |
Apr
(73) |
May
(90) |
Jun
(87) |
Jul
(41) |
Aug
(47) |
Sep
(28) |
Oct
(23) |
Nov
(44) |
Dec
(81) |
| 2006 |
Jan
(21) |
Feb
(9) |
Mar
(82) |
Apr
(14) |
May
(109) |
Jun
(175) |
Jul
(188) |
Aug
(44) |
Sep
(5) |
Oct
(47) |
Nov
(15) |
Dec
(34) |
| 2007 |
Jan
(75) |
Feb
(24) |
Mar
(30) |
Apr
(4) |
May
(28) |
Jun
(9) |
Jul
(13) |
Aug
(13) |
Sep
(29) |
Oct
(15) |
Nov
(19) |
Dec
(12) |
| 2008 |
Jan
(7) |
Feb
(19) |
Mar
(1) |
Apr
(7) |
May
(13) |
Jun
(19) |
Jul
(17) |
Aug
(29) |
Sep
(15) |
Oct
(37) |
Nov
(18) |
Dec
(29) |
| 2009 |
Jan
(23) |
Feb
(12) |
Mar
(8) |
Apr
(16) |
May
(11) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(9) |
Nov
(17) |
Dec
(31) |
| 2010 |
Jan
(15) |
Feb
(5) |
Mar
(4) |
Apr
(8) |
May
(1) |
Jun
(5) |
Jul
(17) |
Aug
(2) |
Sep
(12) |
Oct
(33) |
Nov
(14) |
Dec
(24) |
| 2011 |
Jan
(11) |
Feb
(2) |
Mar
(34) |
Apr
(11) |
May
(12) |
Jun
(3) |
Jul
(6) |
Aug
(11) |
Sep
(10) |
Oct
(1) |
Nov
(8) |
Dec
|
| 2012 |
Jan
(16) |
Feb
(2) |
Mar
|
Apr
(2) |
May
(6) |
Jun
(2) |
Jul
(7) |
Aug
|
Sep
|
Oct
(7) |
Nov
(22) |
Dec
(2) |
| 2013 |
Jan
(1) |
Feb
(24) |
Mar
(15) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
(6) |
Nov
(10) |
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
|
Dec
(5) |
| 2015 |
Jan
(1) |
Feb
(4) |
Mar
(3) |
Apr
(3) |
May
|
Jun
(3) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
(9) |
Mar
(4) |
Apr
|
May
(6) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(7) |
Nov
(13) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(12) |
Oct
(4) |
Nov
|
Dec
|
| 2018 |
Jan
(6) |
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
|
Jul
(9) |
Aug
(4) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(1) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(3) |
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2025 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Kliger Dorit-B. <dan...@eu...> - 2016-02-22 00:51:47
|
Hello! New message, please read <http://rail-logistic.com/woman.php?tt> Kliger Dorit-BDK002 |
|
From: Heine F. <hei...@gm...> - 2016-02-21 17:01:31
|
Hi, I was experimenting with the firebird odbc driver. There is an option under transactions for "read (default write)?" What is this for and how does it work? I don't want to have transactions for reads but for inserts, updates and deletes. Is it ok to do this? I am using Access 2010 along with the odbc driver on windows 7 prof. Thanks Heine |
|
From: Nagy S. <nag...@ya...> - 2016-02-09 20:01:08
|
Ok i found it, i also installed unixODBC-devel package and the make was successful.
Thank you very much guys!
On Tuesday, February 9, 2016 9:59 PM, Nagy Szilveszter <nag...@ya...> wrote:
Ok i found it, i also installed unixODBC-devel package and the make was successful.
Thank you very much guys!
On Tuesday, February 9, 2016 9:40 PM, Nagy Szilveszter <nag...@ya...> wrote:
Thank you, i am one step closer now.
The firebird-superserver package was installed before, but now i also installed firebird-devel package and it created /usr/include/ibase.h file.
Now i have another error: sqltypes.h is missing.
What package should i install to have it?
Here is the output of make:
[root@pali2 Gcc.lin]# make -f makefile.linux../makefile.environ:6: ARCH is x86_64../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64../makefile.environ:50: FBINCDIR is /usr/include../makefile.environ:56: FBLIBDIR is /usr/lib64mkdir: cannot create directory ‘Release_x86_64’: File existsmake: [createdirs] Error 1 (ignored)mkdir: cannot create directory ‘Release_x86_64/obj’: File existsmake: [createdirs] Error 1 (ignored)g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/include -I/include -I/usr/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/IscArray.cpp -o Release_x86_64/obj/IscArray.oIn file included from ../../IscDbc/IscStatement.h:30:0, from ../../IscDbc/IscArray.cpp:34:../../IscDbc/Sqlda.h:29:22: fatal error: sqltypes.h: No such file or directory #include <sqltypes.h> ^compilation terminated.make: *** [Release_x86_64/obj/IscArray.o] Error 1[root@pali2 Gcc.lin]#
On Tuesday, February 9, 2016 12:10 PM, Dimitry Sibiryakov <sd...@ib...> wrote:
09.02.2016 1:17, Nagy Szilveszter wrote:
> First i installed firebird-superserver,
> ../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
Error is obviously telling that you either didn't install Firebird or CentOS package
doesn't put headers into /usr/include.
--
WBR, SD.
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
From: Dimitry S. <sd...@ib...> - 2016-02-09 19:54:18
|
09.02.2016 20:40, Nagy Szilveszter wrote: > Now i have another error: sqltypes.h is missing. > > What package should i install to have it? http://xmodulo.com/how-to-find-what-package-file-belongs-to-on-centos-fedora.html -- WBR, SD. |
|
From: Nagy S. <nag...@ya...> - 2016-02-09 19:40:40
|
Thank you, i am one step closer now.
The firebird-superserver package was installed before, but now i also installed firebird-devel package and it created /usr/include/ibase.h file.
Now i have another error: sqltypes.h is missing.
What package should i install to have it?
Here is the output of make:
[root@pali2 Gcc.lin]# make -f makefile.linux../makefile.environ:6: ARCH is x86_64../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64../makefile.environ:50: FBINCDIR is /usr/include../makefile.environ:56: FBLIBDIR is /usr/lib64mkdir: cannot create directory ‘Release_x86_64’: File existsmake: [createdirs] Error 1 (ignored)mkdir: cannot create directory ‘Release_x86_64/obj’: File existsmake: [createdirs] Error 1 (ignored)g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/include -I/include -I/usr/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/IscArray.cpp -o Release_x86_64/obj/IscArray.oIn file included from ../../IscDbc/IscStatement.h:30:0, from ../../IscDbc/IscArray.cpp:34:../../IscDbc/Sqlda.h:29:22: fatal error: sqltypes.h: No such file or directory #include <sqltypes.h> ^compilation terminated.make: *** [Release_x86_64/obj/IscArray.o] Error 1[root@pali2 Gcc.lin]#
On Tuesday, February 9, 2016 12:10 PM, Dimitry Sibiryakov <sd...@ib...> wrote:
09.02.2016 1:17, Nagy Szilveszter wrote:
> First i installed firebird-superserver,
> ../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
Error is obviously telling that you either didn't install Firebird or CentOS package
doesn't put headers into /usr/include.
--
WBR, SD.
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
From: Dimitry S. <sd...@ib...> - 2016-02-09 10:08:03
|
09.02.2016 1:17, Nagy Szilveszter wrote: > First i installed firebird-superserver, > ../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory Error is obviously telling that you either didn't install Firebird or CentOS package doesn't put headers into /usr/include. -- WBR, SD. |
|
From: Paul B. <pb...@ib...> - 2016-02-09 09:01:33
|
Try these instructions. http://www.ibphoenix.com/resources/documents/search/doc_389 Regrads Paul Beach |
|
From: Nagy S. <nag...@ya...> - 2016-02-09 00:17:48
|
Hello all! Please somebody help me with installing ODBC driver on CcentOS linux. I need it to make Sphinx work. I followed Marius Popa's instructions, from FB main site: http://www.firebirdnews.org/howto-install-firebird-odbc-driver-for-unixodbc-from-source/ First i installed firebird-superserver, gcc-c++ and unixodbc packets...no problem here. But when compiling the ODBC driver i get this error: [root@pali2 Gcc.lin]# make -f makefile.linux../makefile.environ:6: ARCH is x86_64../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64../makefile.environ:50: FBINCDIR is /usr/lib64/firebird/include../makefile.environ:56: FBLIBDIR is /usr/lib64/firebird/libmkdir: cannot create directory ‘Release_x86_64’: File existsmake: [createdirs] Error 1 (ignored)mkdir: cannot create directory ‘Release_x86_64/obj’: File existsmake: [createdirs] Error 1 (ignored)g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/lib64/firebird/include -I/include -I/usr/lib64/firebird/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/Attachment.cpp -o Release_x86_64/obj/Attachment.oIn file included from ../../IscDbc/Attachment.cpp:35:0:../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory #include <ibase.h> ^compilation terminated.make: *** [Release_x86_64/obj/Attachment.o] Error 1 Then i tried another way: I downloaded the ready-to-run version ODBC driver, from FB main site: | November 26, 2014 | OdbcFb-LIB-2.0.3.154.i686.gz | 1.0 MB | Linux x86 Library | I unzipped and copied it to /usr/lib/firebird/libOdbcFb.so I also made 2 another copies because the provided odbc config referred to libOdbcJdbc.so and libOdbcJdbcS.so files, and i had none of them. I guess the compiler should create them. (Note: First i tried with symlinks, but not working i created real copies. But also not working.) Here are odbc configs: [root@pali2 Gcc.lin]# cat /etc/odbcinst.ini [Firebird]Description = Firebird ODBC DriverDriver = /usr/lib/firebird/libOdbcFb.soSetup = /usr/lib/firebird/libOdbcJdbcS.soThreading = 1FileUsage = 1CPTimeout =CPReuse = [root@pali2 Gcc.lin]# cat /etc/odbc.ini[sample]Description = FirebirdDriver = FirebirdDbname = localhost:/data/sample.fdbUser = SYSDBAPassword = masterkeyRole =CharacterSet = UTF8ReadOnly = NoNoWait = No When trying to connect i get this error: [root@pali2 Gcc.lin]# isql -v sample[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/firebird/libOdbcJdbc.so' : file not found[ISQL]ERROR: Could not SQLConnect The /usr/lib/firebird/libOdbcJdbc.so file DOES EXIST.On a forum i read that someone had the same issue and installing libstdc++ solved the problem.But i had it installed before: [root@pali2 Gcc.lin]# rpm -qa | grep libstdc++libstdc++-4.8.5-4.el7.x86_64libstdc++-devel-4.8.5-4.el7.x86_64 Here is my system's architecture: [root@pali2 Gcc.lin]# uname -aLinux pali2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux Please help me! Thank you,Szilveszter |
|
From: Olaf K. <ola...@sa...> - 2016-01-20 07:02:46
|
Hello @ll, I have update from 2.0.0 to 2.5.5 and after then, the linked Tables and Queries in Microsoft Access are very slow, only the first time I get the Data quickly. Both ODBC Driver are 32 Bit and used on several Windows operating systems. With the old Version I get the data quick every time I open the query and Formular. Is there a little Bug in the actual Version implanted? ;) Best regards. Olaf |
|
From: Fekete R. <dan...@eu...> - 2015-12-14 13:45:01
|
Hello! New message, please read <http://olvikt.mysite.dp.ua/order.php?e4> Fekete Rbert |
|
From: Ferry N. <fe...@gm...> - 2015-08-19 03:15:27
|
Hi there, Can you please tell me if it is possible to use Firebird's ODBC Driver for connecting from Windows remotely to Firebird instance on Mac, and if so what would the settings be ? I intend to create some data extracts that run on a Windows machine where the ODBC Driver is installed (Windows Server 2012 R2 64 bit) to consolidate data from a few Firebird 2.1 databases on a few Mac machines. I've tried connection string in the following format without success (error message: Open database '<connection string>' failed). I've tried with and without the port number. <IP Address>/3050:/Users/<Actual File Path>/<Database File>.fdb I've tested the same connection string as above from a FlameRobin application on the same Windows server and it is able to remote connect successfully to the Firebird on Mac, browse tables, etc. Thanks, Ferry |
|
From: Liz W. <li...@li...> - 2015-08-12 22:04:20
|
Hello, We are using the Firebird ODBC driver on Linux, storing DSN parameters in the odbc.ini file. We are currently storing the database password in clear text in the odbc.ini file, and are facing a requirement to encrypt this password. Does the Firebird ODBC driver support use of encrypted passwords on Linux? If so, how would we go about encrypting the password? Thank you, Liz Watson |
|
From: Jaromír K. <kar...@gm...> - 2015-07-10 19:35:23
|
Hello,
I'm faced with a following problem:
I have a table MyTable with a BLOB SUB_TYPE 1 column MyBlob.
Insert or update statement with value works well: INSERT INTO MyTable
(MyBlob) VALUES ('') /* results to an empty string in MyBlob field */
Passing an empty string as parameter causes the problem: INSERT INTO
MyTable (MyBlob) VALUES (?pcMyString) /* MyBlob field is null when
pcMyString==''*/
If pcMyString is not empty the previous SQL statement works well and
MyBlob field contains string from pcMyString parameter.
Similar SQL statement with char or varchar field is ok for both passing
value and passing parameter. The problem is with BLOB field only.
Something seems to be wrong with parameter binding. Is there a way how
to get rid of this annoying thing?
My environment is Win7 64bit, Firebird_ODBC_2.0.3.154_Win32 (yes,
32-bit because of 32-bit application), Visual Foxpro 7.0 SP1. I've
already discussed the problem in the Czech Visual Foxpro developers
forum. Other members have proved the problem.
Thank you for your help.
MirekK
|
|
From: ching lu <lsc...@gm...> - 2015-06-11 13:34:15
|
Can someone helps? Thx. On Wed, Jun 10, 2015 at 9:30 AM, ching lu <lsc...@gm...> wrote: > please find the screenshots: > https://drive.google.com/folderview?id=0B8V-YFTM0I7Ffm5CVkE3SElZMGQ1R2F1MkFFRU1VckJOYVJqaEJHWm1ibXFzeUhoczRvMkU&usp=sharing > > On Tue, Jun 9, 2015 at 8:21 PM, ching lu <lsc...@gm...> wrote: >> The testing environment is Win7 SP1 64 bit, Office 2010 64 bit, >> Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64 >> >> I need to work with unicode table names and unicode column names. >> >> The embedded database (charset=UTF8) is created with flamerobin x64, >> the table names and column names worked ok >> >> When i test with Excel (odbc client charset and server:are both UTF8) >> >> 1. The names are garbage characters when trying to with "Microsoft query" >> 2. The query works ok except for blob text column, it is garbage characters >> >> Please help me |
|
From: ching lu <lsc...@gm...> - 2015-06-10 01:30:19
|
please find the screenshots: https://drive.google.com/folderview?id=0B8V-YFTM0I7Ffm5CVkE3SElZMGQ1R2F1MkFFRU1VckJOYVJqaEJHWm1ibXFzeUhoczRvMkU&usp=sharing On Tue, Jun 9, 2015 at 8:21 PM, ching lu <lsc...@gm...> wrote: > The testing environment is Win7 SP1 64 bit, Office 2010 64 bit, > Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64 > > I need to work with unicode table names and unicode column names. > > The embedded database (charset=UTF8) is created with flamerobin x64, > the table names and column names worked ok > > When i test with Excel (odbc client charset and server:are both UTF8) > > 1. The names are garbage characters when trying to with "Microsoft query" > 2. The query works ok except for blob text column, it is garbage characters > > Please help me |
|
From: ching lu <lsc...@gm...> - 2015-06-09 12:21:32
|
The testing environment is Win7 SP1 64 bit, Office 2010 64 bit, Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64 I need to work with unicode table names and unicode column names. The embedded database (charset=UTF8) is created with flamerobin x64, the table names and column names worked ok When i test with Excel (odbc client charset and server:are both UTF8) 1. The names are garbage characters when trying to with "Microsoft query" 2. The query works ok except for blob text column, it is garbage characters Please help me |
|
From: Olaf K. <ola...@sa...> - 2015-04-01 12:21:36
|
it is an approach that I try to dissolve the problem somehow Von: Jorge Andrés Brugger [mailto:li...@da...] Gesendet: Mittwoch, 1. April 2015 13:51 An: fir...@li... Betreff: Re: [Firebird-odbc-devel] Firebird and MS Access Olaf: First of all, please go to http://www.comicsanscriminal.com/ ;) Then, why do you think your issue is related with ODBC driver? Regards El 01/04/2015 06:31 a.m., Olaf Kluge escribió: Hello @ll, I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver. First the constellation: Table a Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is the number of the supplier, so 1 = supplier a from Germany, 2 is supplier b And there is a table 2 Foreign key Year and Number to Table 1, ID primary key and unique. There can be some more than 1 positions for every order, 1 to n relation. I have already tried some things, so I have create the number not with (select max(nr)+1) but now with a generator. The Problem: If the last order has the same supplier-id like the new created, MS Access shows me in some cases the Orderpositions in the subform (table 2) from the order before (with the same supplier-id).. And this at the point of refresh. So there is a new position createt, I have now three (if the order before have had 2), If I delete the order positions, I delete all positions, already the 2 from the order before. Is there a workaround to solve this issue? In Access there is a main form with a subform, connectet from year and number to year and number. Thanks a lot Best regards. Olaf ---------------------------------------------------------------------------- -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... <mailto: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... <mailto:jbr...@da...> Website: www.dasu.com.ar <http://www.dasu.com.ar> "No te pongas en el lado malo de un argumento simplemente porque tu oponente se ha puesto en el lado correcto" (Baltasar Gracián) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. |
|
From: Jorge A. B. <li...@da...> - 2015-04-01 12:09:52
|
Olaf: First of all, please go to http://www.comicsanscriminal.com/ ;) Then, why do you think your issue is related with ODBC driver? Regards El 01/04/2015 06:31 a.m., Olaf Kluge escribió: > > Hello @ll, > > I have already a big Problem with this combination, msaccess (all > versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually > odbc driver. > > First the constellation: > > Table a > > Primary Key year and number, so 2015 1, 2015 2, unique with main data > for orders, one field is the number of the supplier, so 1 = supplier a > from Germany, 2 is supplier b... > > And there is a table 2 > > Foreign key Year and Number to Table 1, ID primary key and unique. > There can be some more than 1 positions for every order, 1 to n relation. > > I have already tried some things, so I have create the number not with > (select max(nr)+1) but now with a generator. > > The Problem: If the last order has the same supplier-id like the new > created, MS Access shows me in some cases the Orderpositions in the > subform (table 2) from the order before (with the same supplier-id).. > And this at the point of refresh. So there is a new position createt, > I have now three (if the order before have had 2), If I delete the > order positions, I delete all positions, already the 2 from the order > before. > > Is there a workaround to solve this issue? In Access there is a main > form with a subform, connectet from year and number to year and number. > > Thanks a lot > > Best regards. > > Olaf > > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > > > _______________________________________________ > 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 te pongas en el lado malo de un argumento simplemente porque tu oponente se ha puesto en el lado correcto" (Baltasar Gracián) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. |
|
From: Olaf K. <ola...@sa...> - 2015-04-01 09:44:15
|
Hello @ll, I have already a big Problem with this combination, msaccess (all versions) and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver. First the constellation: Table a Primary Key year and number, so 2015 1, 2015 2, unique with main data for orders, one field is the number of the supplier, so 1 = supplier a from Germany, 2 is supplier b. And there is a table 2 Foreign key Year and Number to Table 1, ID primary key and unique. There can be some more than 1 positions for every order, 1 to n relation. I have already tried some things, so I have create the number not with (select max(nr)+1) but now with a generator. The Problem: If the last order has the same supplier-id like the new created, MS Access shows me in some cases the Orderpositions in the subform (table 2) from the order before (with the same supplier-id).. And this at the point of refresh. So there is a new position createt, I have now three (if the order before have had 2), If I delete the order positions, I delete all positions, already the 2 from the order before. Is there a workaround to solve this issue? In Access there is a main form with a subform, connectet from year and number to year and number. Thanks a lot Best regards. Olaf |
|
From: Liz W. <li...@li...> - 2015-03-13 13:49:04
|
Hello, We are looking for advice on building the Firebird ODBC driver for 64 bit RHEL6 Linux. I've seen several older postings that refer to some of the issues we are seeing, but I have not seen a write up that nails the solution. We started off by downloading the latest code for the ODBC driver. cvs -d:pserver:ano...@fi...:/cvsroot/firebird login cvs -z3 -d:pserver:ano...@fi...:/cvsroot/firebird co OdbcJdbc Then built it: cd OdbcJdbc/Builds/Gcc.lin make -f makefile.linux This produces an ODBC driver that works most of the time. It aborts with a SIGSEGV when executing a SQL statement that uses parameters that have been set up with SQLBindParameter(). I'm pretty sure this has something to do with a type that ought to be 32 bit or 64 bit or vice versa not being defined correctly. We've tried building with BUILD_REAL_64_BIT_MODE, and that has not helped. We did have success using the prebuilt ODBC driver in our test environment, by creating a link for libodbcinst.so.1. While we cannot use this solution in production, it has confirmed our theory that we are not building the driver correctly. Thank you for any suggestions you may be able to offer. Best regards, Liz Watson |
|
From: cwilkins <cwi...@p3...> - 2015-03-06 19:09:39
|
I'm using version 2.0.3.154 of the Firebird Driver On 32-Bit systems, we have a connection string formatted as 'IP Address:D:\Fishbowl Directory\database\data\Database.FDB". This connection string works perfectly. On 64-Bit systems: * if I use the 64-Bit Driver and the 64-Bit ODBC (C:\windows\system32\odbcad32.exe) - the connection works great. * If I use the 32-Bit Driver and the 32-Bit ODBC (C:\windows\syswow64\odbcad32.exe) - I get an error that "Open database 'connection string' failed" I MUST use a 32-Bit connection on the 64-Bit computers because I'm using an integration between Fishbowl and UPS WorldShip. UPS WorldShip will only recognize 32-bit ODBC connections. Any help to resolve this would be greatly appreciated. Thanks, Chuck |
|
From: Keith L. W. <klw...@ne...> - 2015-03-06 03:40:28
|
I wanted to build the Firebird ODBC driver for 64-bit Fedora 20 Linux (the precompiled binary didn't work for me due to a requirement for a library missing on my system: libodbcinst.so.1), but in the 2.0.3 release, the source code file is listed as "OdbcJdbc-src-2.0.3.154.tar.gz" whereas in 2.0.2 and 2.0.1 the source code files were listed as "OdbcFb-Source-2.0.x.15x.gz." I could find no mention of such a change in the release notes. Why the change? Thanks in advance, Keith Laten Williams |
|
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 |
|
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 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 |
71 messages has been excluded from this view by a project administrator.
