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

Re: [Firebird-odbc-devel] What about the ODBC driver in 2023?

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

https://github.com/FirebirdSQL/firebird-odbc-driver/wiki

El lun, 13 feb 2023 a las 13:21, Jorge Andres Brugger (<
jor...@gm...>) escribió:

> Hello.
> There have been no new releases of the ODBC driver for a long time. There
> are commits two years old or older in the Github repository that were never
> included in a release. There are issues migrated from Jira (I think) and
> open since 2014.
> I would appreciate it if the development team could tell us the driver
> users about the plans for the project.
> Thank you
>
> --
> Jorge Andrés Brugger
>


-- 
Jorge Andrés Brugger

[Firebird-odbc-devel] What about the ODBC driver in 2023?

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

Hello.
There have been no new releases of the ODBC driver for a long time. There
are commits two years old or older in the Github repository that were never
included in a release. There are issues migrated from Jira (I think) and
open since 2014.
I would appreciate it if the development team could tell us the driver
users about the plans for the project.
Thank you

-- 
Jorge Andrés Brugger

[Firebird-odbc-devel] Memory exhausted

[René G. <Ren...@ma...>]

Hello,

I'm running into a similar error like the one described here: https://www.mail-archive.com/fir...@ya.../msg20295.html
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 206158430249 bytes) in /var/www/XXX/yyy.php on line 8

The Firebird database is on a windows server and seems to be on version 2.5.7. I set up a Linux-Server (Ubuntu 20.04) where the application which connects to the database is running. unixODBC is installed and I'm using the libfbclient.so.2.5.9 (as it should be compatible to server version 2.5.7). As described in the link I build the libOdbcFb.so on the machine but still get this error.

Any suggestions?

[Firebird-odbc-devel] Fatal Memory Error

[Ken H. <ksh...@gm...>]

It was suggested that I build the drivers from source and delete the 
SQL*.h headers.  I have done this.  I have done this.  I have 
reinstalled everything and tried multiple times.

I still see the same Fatal Memory error that terrabytes of information 
are being requested when that is not possible.

I have tried with Ubunut 18 and 20, using 
apache2/php/unixodbc/firebird3.0 and built the libOdbcFb.so files from 
the github repo, deleting the sql*.h headers, and I have to change to 
FBLIBDIR since Firebird is installed to 
/usr/lib/x86_64-linux-gnu/firebird/3.0/ directory instead of where the 
makefile is looking.

Can anyone suggest something else to make this work?

Re: [Firebird-odbc-devel] Fatal Memory Error

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

14.05.2021 11:33, Dimitry Sibiryakov wrote:
> Delete headers sql*.h from them to make sure that system ones are used.

   Clarification: it must be only sql.h and sqlext.h.

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] Fatal Memory Error

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

14.05.2021 00:04, Ken Hutchins wrote:
> Does anyone have any idea of how to make this work on Ubuntu Server 20

   Build the driver from sources. Delete headers sql*.h from them to make sure that system 
ones are used.

-- 
   WBR, SD.

[Firebird-odbc-devel] Fatal Memory Error

[Ken H. <ksh...@gm...>]

On Ubuntu Server 20 I am installing:

Firebird3.0-server, Firebird3.0-examples, and Firebird-dev
Unixodbc and unixodbc-dev
apache2
php7.4, libapache-mod-php, php-mysql, and php7.4-odbc
mysql-server


I am using the most update Firebird odbc driver I can find: May 18, 2017 
OdbcFb-LIB-2.0.5.156.amd64.gz   348 KB	Linux  AMD64 Library


I am setting the odbc.ini and odbcinst.ini in /etc with the proper paths 
and I am able use the isql of unixodbc to connect to my firebird 
database on a Windows 10 machine.  So isql -v FirebirdDSNtoUPS works 
just find and I can run queries.

However, when using odbc_connect in php, I am getting the following 
error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to 
allocate 206158430229 bytes).

The query in question is not written incorrectly and is only returning a 
few lines from a possible pool of a few thousand.  My entire database 
does not have 206158430229 bytes.  The same query works fine in the 
isql.  I have also installed Ubuntu Server 16 to the same machine and it 
does not have this issue.

Reading from other similar issues, apparently the SQLLEN being read as 
32 bit in the odbc driver causes this and in all cases I can find 
dealing with IBMconnect and a few other database drivers for varying 
databases, the driver is at fault as it was compiled against an old 
version of unixodbc that is no longer supported in Ubuntu Server 20.

I have tried do some build makes to force a 32 bit install of unixodbc 
but have been unsuccesful.

I have also recreated this on 3 machines and each machine with Ubuntu 
Server 20 has the same outcome with the above error.

Does anyone have any idea of how to make this work on Ubuntu Server 20 
as I do not want to use Ubuntu Server 16 since its EOL occurred a month 
or so ago.

[Firebird-odbc-devel] AUTOREPLY stevyn dembo

[<hs...@pp...>]

Sehr geehrte Damen und Herren, 

ich bin am heutigen Dienstag nicht im Büro zu erreichen.


Wenden Sie sich in dringenden Fällen gerne an of...@pl....

Grüße aus Börnsen, 
Helge Schild
-------------------------------------------------------------




I am out of office today.
If it is urgent please contact office@plugplant or ring. 
Kind regards,
Helge Schild
-------------------------------------------------------------
Hej 


Jag är inte på kontoret på tisdag och nås därför inte under denna tiden.


Är det av mer akut karaktär så kontakta vårt kontor på of...@pl... eller +49 40 720 044 410. Så får du kontakt med en kollega som kan bistå med hjälp under min frånvaro. 

[Firebird-odbc-devel] AUTOREPLY stevyn dembo

[<hs...@pp...>]

Sehr geehrte Damen und Herren, 
ich bin am heutigen Montag nicht im Büro zu erreichen.


Wenden Sie sich in dringenden Fällen gerne an of...@pl....

Grüße aus Börnsen, 
Helge Schild
--------------------------------------------------------------------


I am out of office today.
If it is urgent please contact office@plugplant or ring. 


Kind regards,
Helge Schild
--------------------------------------------------------------------


Hej 


Jag är inte på kontoret på måndag och nås därför inte under denna tiden.


Är det av mer akut karaktär så kontakta vårt kontor på of...@pl... eller +49 40 720 044 410. Så får du kontakt med en kollega som kan bistå med hjälp under min frånvaro. 

[Firebird-odbc-devel] stevyn dembo

[stevyn d. <sr...@ya...>]

firebird

https://bit.ly/3jgqR8l



stevyn





Tons of aspects of the game are monetized. Players can buy character costumes, flashy weapon and pickaxe skins, backpacks, dance moves, season passes for access to new levels, and more. None of these will help your child play better. They’re cosmetic, but there’s still a strong drive to not look like a noob with a default skin and lame dance moves.





Adding new thermal paste is just as easy. Squeeze out about a pea-sized worth right in the center of your CPU, and then reattach your cooler. It’ll be a tight squeeze between the cooler’s plate and your CPU, which will ensure that the paste gets evenly spread around your processor. No need to do that part yourself.
civcqjvx Machiavellianly barbellulate sencio


dbitchery treadle doling unimprecated

Re: [Firebird-odbc-devel] ODBC/JDBC

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

10.07.2020 18:04, Paul Reeves wrote:
> I think JDBC was used as the inspiration for an OO wrapper around isc api.
> There is no other link with JDBC as far as I am aware.

   So the driver is a simple ODBC driver with some JDBC-like pieces used internally, 
nothing more? And it was never supposed to be used from Java at all?

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] ODBC/JDBC

[Paul R. <pr...@ib...>]

On Fri, 10 Jul 2020 17:36:54 +0200
Dimitry Sibiryakov <sd...@ib...> wrote:

>    Hello, All.
> 
>    Our driver claims to be ODBC/JDBC driver but did anyone used or tested
> its JDBC part?
> 

I think JDBC was used as the inspiration for an OO wrapper around isc api.
There is no other link with JDBC as far as I am aware.

 
Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird
 

[Firebird-odbc-devel] ODBC/JDBC

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

   Hello, All.

   Our driver claims to be ODBC/JDBC driver but did anyone used or tested its JDBC part?

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] Source repository

[Paul R. <pr...@ib...>]

On Fri, 5 Jun 2020 16:49:33 +0200
Dimitry Sibiryakov <sd...@ib...> wrote:

>    Hello, All.
> 
>    What is the official driver's source repository? Github or still
> Sourceforge?
> 

Everything should now be on github. 

https://github.com/FirebirdSQL/firebird-odbc-driver/commits/master


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird
 

[Firebird-odbc-devel] Source repository

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

   Hello, All.

   What is the official driver's source repository? Github or still Sourceforge?

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] Using the odbc driver on windows without installing it from a Delphi application

[liviuslivius <liv...@po...>]

I do not know which Delphi version do you have, but the best is Firedac for you. It support multiple rdbms firebird, mssql, mysql, postgresql and moreRegards,Karol Bieniaszewski
null

Re: [Firebird-odbc-devel] Using the odbc driver on windows without installing it from a Delphi application

[Stefan G. <ste...@ya...>]

 Hi, thank you for your reply - much appreciated!
But that is not a good solution for me - my app supports other databases (for example ms sql) - with modified sql queries if needed - because I use the standard odbc connection.
Also the ibx delphi components are limited to just one statement - cannot easily support a script of statements - which is a problem in my case.
    On Friday, March 15, 2019, 7:02:03 PM GMT+2, Dimitry Sibiryakov <sd...@ib...> wrote:  
 
 15.03.2019 13:41, Stefan Genov via Firebird-odbc-devel wrote:
> Please help - is there a way to use the odbc driver on windows without installing it from 
> a Delphi application.

  The simplest way for Delphi is to use direct access components and get rid of ODBC at all.


-- 
  WBR, SD.


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

Re: [Firebird-odbc-devel] Using the odbc driver on windows without installing it from a Delphi application

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

15.03.2019 13:41, Stefan Genov via Firebird-odbc-devel wrote:
> Please help - is there a way to use the odbc driver on windows without installing it from 
> a Delphi application.

   The simplest way for Delphi is to use direct access components and get rid of ODBC at all.


-- 
   WBR, SD.

[Firebird-odbc-devel] Using the odbc driver on windows without installing it from a Delphi application

[Stefan G. <ste...@ya...>]

Hello all :)
I need to use firebird with a windows application which does not have admin rights for install or run.I cannot figure out how can I use odbc driver without installing it - I don't even know if it's possible.
I searched the net, found almost no information
In this article it is stated that it is easy - just specify the OdbcFb.dll in the connection string.https://stackoverflow.com/questions/54826254/connect-odbc-without-driver-installed
But the post also says that I have to link the OdbcFb.lib in my exe. I use Delphi (XE7) for that project and I think I cannot link a lib file.Maybe I could build a small c++ app just for executing the lib file somehow before starting my Delphi app? 
Other things I tried were writing a odbc.ini, odbcinst.ini files in my app folder and trying to describe the provider name and dll name there.
The error remains pretty much the same:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Please help - is there a way to use the odbc driver on windows without installing it from a Delphi application.
Thanks in advance,Stefan.

[Firebird-odbc-devel] Rch vom 24/01/2019

[Michael v. B. <m.b...@xe...>]

<html>
<body>
<p><font color="navy" face="Segoe UI">
Sehr geehrter Kunde,
</font></p>
<br>
<p><font color="navy" face="Segoe UI">

Zu Ihrer Vorkasse / Zahlung über EUR 95,94 gibt es keine Rechnung.<br>
Vielleicht wurde hier irrtümlich eine Vorkasse ausgestellt. <br>
<br>
Vorkasse vom 27.12.2018 wurde wohl doppelt überwiesen, 3.01.2019 und 9.01.2019.
</font></p>
<p><font color="navy" face="Segoe UI">

<br>
<br>
<a href="http://gik.by/Amazon/DE/Transaktion-details/01_19">Sie können die Rechnung über diesen Link herunterladen.</a>
<br>
<br>
<br>
Freundliche Grüße
<br>
</font></p>
<p><font color="black" face="Segoe UI"> 
Michael von Boetticher</font></p>
<p><font color="green" face="Segoe UI"><small>

Mob: 0185 3 915135<br>
Telefax: 0185 3 915580<br>
Mail:m.b...@xe...
</small></font></p>
<p><font color="grey" face="Segoe UI"><small>

<br>
</small></font></p>
</body>
</html> 

[Firebird-odbc-devel] OdbcJdbc won't compile under GCC v7.3.0

[Chris R. <cr...@ae...>]

I’m using a clean build of Linux Mint 19.1 which has GCC v7.3.0. When I try to compile OdbcJdbc (both the latest from github and https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/OdbcJdbc-src-2.0.5.156.tar.gz/download from the firebird website), it fails with an error:

make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include
g++ -I/usr/include -I/usr/lib/include -I/usr/include -fPIC -m64 -DNDEBUG
g++ -c ../../IscDbc/IscDatabaseMetaData.cpp -o
g++ Release_x86_64/obj/IscDatabaseMetaData.o
In file included from ../../IscDbc/IscDatabaseMetaData.cpp:47:0:
../../IscDbc/IscDatabaseMetaData.cpp: In member function 'virtual const char* IscDbcLibrary::IscDatabaseMetaData::getDriverVersion()':
../../IscDbc/../SetupAttributes.h:139:65: error: unable to find string literal operator 'operator""buildnum' with 'const char [7]', 'long unsigned int' arguments  #define BUILD_DRIVER_VERSION(major,minor,buildnum) major"."minor"."buildnum
                                                                 ^
../../IscDbc/../SetupAttributes.h:150:25: note: in expansion of macro 'BUILD_DRIVER_VERSION'
 #define DRIVER_VERSION  BUILD_DRIVER_VERSION( ZERO_MAJOR BUILD_STR2( MAJOR_VERSION ), ZERO_MINOR BUILD_STR2( MINOR_VERSION ), ZERO_BUILDNUM BUILD_STR2( BUILDNUM_VERSION ) )
                         ^~~~~~~~~~~~~~~~~~~~
../../IscDbc/IscDatabaseMetaData.cpp:350:9: note: in expansion of macro 'DRIVER_VERSION'
  return DRIVER_VERSION;
         ^~~~~~~~~~~~~~
makefile.linux:127: recipe for target 'Release_x86_64/obj/IscDatabaseMetaData.o' failed

Not sure what's changed with Gcc, but adding spaces around the BUILD_DRIVER_VERSION appears to fix the problem.

Patch is included.

CRule
The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.

[Firebird-odbc-devel] OdbcJdbc won't compile under GCC v7.3.0

[Chris R. <cr...@ae...>]

I’m using a clean build of Linux Mint 19.1 which has GCC v7.3.0. When I try to compile OdbcJdbc (both the latest from github and https://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.5-Release/OdbcJdbc-src-2.0.5.156.tar.gz/download from the firebird website), it fails with an error:

make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include
g++ -I/usr/include -I/usr/lib/include -I/usr/include -fPIC -m64 -DNDEBUG
g++ -c ../../IscDbc/IscDatabaseMetaData.cpp -o
g++ Release_x86_64/obj/IscDatabaseMetaData.o
In file included from ../../IscDbc/IscDatabaseMetaData.cpp:47:0:
../../IscDbc/IscDatabaseMetaData.cpp: In member function 'virtual const char* IscDbcLibrary::IscDatabaseMetaData::getDriverVersion()':
../../IscDbc/../SetupAttributes.h:139:65: error: unable to find string literal operator 'operator""buildnum' with 'const char [7]', 'long unsigned int' arguments  #define BUILD_DRIVER_VERSION(major,minor,buildnum) major"."minor"."buildnum
                                                                 ^
../../IscDbc/../SetupAttributes.h:150:25: note: in expansion of macro 'BUILD_DRIVER_VERSION'
 #define DRIVER_VERSION  BUILD_DRIVER_VERSION( ZERO_MAJOR BUILD_STR2( MAJOR_VERSION ), ZERO_MINOR BUILD_STR2( MINOR_VERSION ), ZERO_BUILDNUM BUILD_STR2( BUILDNUM_VERSION ) )
                         ^~~~~~~~~~~~~~~~~~~~
../../IscDbc/IscDatabaseMetaData.cpp:350:9: note: in expansion of macro 'DRIVER_VERSION'
  return DRIVER_VERSION;
         ^~~~~~~~~~~~~~
makefile.linux:127: recipe for target 'Release_x86_64/obj/IscDatabaseMetaData.o' failed

Not sure what's changed with Gcc, but adding spaces around the BUILD_DRIVER_VERSION appears to fix the problem.

Patch is included.

CRule
The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.

Re: [Firebird-odbc-devel] Access and DSN ODBC

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

El 09/08/2018 a las 11:37 a. m., Jorge Andrés Brugger escribió:
> El 09/08/2018 a las 11:02 a. m., Dimitry Sibiryakov escribió:
>> 09.08.2018 14:44, Jorge Andrés Brugger wrote:
>>> "xnet://Global\FIREBIRD"
>>
>>   It doesn't look like "remote (LAN) Firebird database". What version 
>> of fbclient.dll is used?
> 3.0.2 (64 bits)

Still facing this issue.

Any thoughts?

Thanks

-- 
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 / 406-3278
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.

Re: [Firebird-odbc-devel] Access and DSN ODBC

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

El 09/08/2018 a las 11:02 a. m., Dimitry Sibiryakov escribió:
> 09.08.2018 14:44, Jorge Andrés Brugger wrote:
>> "xnet://Global\FIREBIRD"
>
>   It doesn't look like "remote (LAN) Firebird database". What version 
> of fbclient.dll is used?
3.0.2 (64 bits)

-- 
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 / 406-3278
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

“Un experto es una persona que ha cometido todos los errores que se pueden cometer en un determinado campo.” (Niels Bohr)


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.

Re: [Firebird-odbc-devel] Access and DSN ODBC

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

09.08.2018 14:44, Jorge Andrés Brugger wrote:
> "xnet://Global\FIREBIRD"

   It doesn't look like "remote (LAN) Firebird database". What version of fbclient.dll is 
used?


-- 
   WBR, SD.