Re: [fpc-pascal] ibase package

2013-11-18 Thread Michael Van Canneyt 



On Mon, 18 Nov 2013, Antonio Fortuny wrote:


Hi Folks.

I'm a little bit annoyed by a boring specification in the fpc package. When 
in a program I use the TIBConnection (along witha transaction and a query), 
the compiled program looks for the local libfbclient when establishing the 
connection.
So far so good. When I install the program in another Linux box, running 
Firebird 2.1, the program complains that
Can not load default Firebird clients (libfbclient.so.2.5 or libgds.so 
or libfbembed.so.2.5). Looks normal as this Linux box uses Firebird 2.1

Is it possible to force what library should be used instead ? (as UIB does)
Having a look inside the code, in ibase60 (lines 2680 and fw) library names 
look fixed and looks like the Firebird version should be fixed before using 
it.


You can do 2 things:

1. use the TSQLDBLibraryLoader component from sqldblib (in trunk)

2. call
   function InitialiseIBase60(Const LibraryName : AnsiString) : integer;
with the correct library name.

Michael.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Antonio Fortuny 

  
  

Le 18/11/2013 12:19, Michael Van
  Canneyt a crit:


  
  
  On Mon, 18 Nov 2013, Antonio Fortuny wrote:
  
  
  Hi Folks.


I'm a little bit annoyed by a boring specification in the fpc
package. When in a program I use the TIBConnection (along witha
transaction and a query), the compiled program looks for the
local libfbclient when establishing the connection.

So far so good. When I install the program in another Linux box,
running Firebird 2.1, the program complains that

"Can not load default Firebird clients ("libfbclient.so.2.5" or
"libgds.so" or "libfbembed.so.2.5")". Looks normal as this Linux
box uses Firebird 2.1

Is it possible to force what library should be used instead ?
(as UIB does)

Having a look inside the code, in ibase60 (lines 2680 and fw)
library names look fixed and looks like the Firebird version
should be fixed before using it.

  
  
  You can do 2 things:
  
  
  1. use the TSQLDBLibraryLoader component from sqldblib (in trunk)
  
  
  2. call
  
   function InitialiseIBase60(Const LibraryName : AnsiString) :
  integer;
  

found it in ibase60dyn.pp -- ibase60.inc
before connecting to the DB:
  InitialiseIBase60('libfbclient.so');
compile on one system (OpenSuse x86_64), copy to the target system
(Ubuntu x86_64)
target systemp library /usr/lib/libfbclient.so.2 copied in current
directory as libfbclient.so
then run and:
An unhandled exception occurred at $004B544B :
EInOutError : Can not load Firebird client library "libfbclient.so".
Check your installation.

any comment ?

Antonio.

with the correct library name.
  
  
  Michael.
  
  ___
  
  fpc-pascal maillist - fpc-pascal@lists.freepascal.org
  
  http://lists.freepascal.org/mailman/listinfo/fpc-pascal
  


-- 
  

  
  
  
  
 Antonio
Fortuny
  Senior Software engineer
  
  220, avenue de la Libert
  L-4602 Niederkorn
  Tel.: +352 58 00 93 - 93
  www.sitasoftware.lu

  
  
  
  

  

  

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Antonio Fortuny 

  
  

Le 18/11/2013 13:08, Antonio Fortuny a
  crit:


  
  
  Le 18/11/2013 12:19, Michael Van
Canneyt a crit:
  
   

On Mon, 18 Nov 2013, Antonio Fortuny wrote: 

Hi Folks. 
  
  I'm a little bit annoyed by a boring specification in the fpc
  package. When in a program I use the TIBConnection (along
  witha transaction and a query), the compiled program looks for
  the local libfbclient when establishing the connection. 
  So far so good. When I install the program in another Linux
  box, running Firebird 2.1, the program complains that 
  "Can not load default Firebird clients ("libfbclient.so.2.5"
  or "libgds.so" or "libfbembed.so.2.5")". Looks normal as this
  Linux box uses Firebird 2.1 
  Is it possible to force what library should be used instead ?
  (as UIB does) 
  Having a look inside the code, in ibase60 (lines 2680 and fw)
  library names look fixed and looks like the Firebird version
  should be fixed before using it. 


You can do 2 things: 

1. use the TSQLDBLibraryLoader component from sqldblib (in
trunk) 

2. call 
 function InitialiseIBase60(Const LibraryName : AnsiString) :
integer; 
  
  found it in ibase60dyn.pp -- ibase60.inc
  before connecting to the DB:
InitialiseIBase60('libfbclient.so');

changing previous line to 
 InitialiseIBase60('./libfbclient.so');
works.

Thanks

Antonio.


  compile on one system (OpenSuse x86_64), copy to the target system
  (Ubuntu x86_64)
  target systemp library /usr/lib/libfbclient.so.2 copied in current
  directory as libfbclient.so
  then run and:
  An unhandled exception occurred at $004B544B :
  EInOutError : Can not load Firebird client library
  "libfbclient.so". Check your installation.
  
  any comment ?
  
  Antonio.
  
  with the correct library name. 

Michael. 
___ 
fpc-pascal maillist - fpc-pascal@lists.freepascal.org

http://lists.freepascal.org/mailman/listinfo/fpc-pascal

  
  
  -- 

  




   Antonio

  Fortuny
Senior Software engineer

220, avenue de la Libert
L-4602 Niederkorn
Tel.: +352 58 00 93 - 93
www.sitasoftware.lu
  




  

  
  
  
  
  ___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal


-- 
  

  
  
  
  
 Antonio
Fortuny
  Senior Software engineer
  
  220, avenue de la Libert
  L-4602 Niederkorn
  Tel.: +352 58 00 93 - 93
  www.sitasoftware.lu

  
  
  
  

  

  

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Michael Van Canneyt 



On Mon, 18 Nov 2013, Antonio Fortuny wrote:



Le 18/11/2013 12:19, Michael Van Canneyt a écrit :



On Mon, 18 Nov 2013, Antonio Fortuny wrote:


Hi Folks.

I'm a little bit annoyed by a boring specification in the fpc package. 
When in a program I use the TIBConnection (along witha transaction and a 
query), the compiled program looks for the local libfbclient when 
establishing the connection.
So far so good. When I install the program in another Linux box, running 
Firebird 2.1, the program complains that
Can not load default Firebird clients (libfbclient.so.2.5 or 
libgds.so or libfbembed.so.2.5). Looks normal as this Linux box uses 
Firebird 2.1
Is it possible to force what library should be used instead ? (as UIB 
does)
Having a look inside the code, in ibase60 (lines 2680 and fw) library 
names look fixed and looks like the Firebird version should be fixed 
before using it.


You can do 2 things:

1. use the TSQLDBLibraryLoader component from sqldblib (in trunk)

2. call
   function InitialiseIBase60(Const LibraryName : AnsiString) : integer;

found it in ibase60dyn.pp -- ibase60.inc
before connecting to the DB:
   InitialiseIBase60('libfbclient.so');
compile on one system (OpenSuse x86_64), copy to the target system (Ubuntu 
x86_64)
target systemp library /usr/lib/libfbclient.so.2 copied in current directory 
as libfbclient.so

then run and:
An unhandled exception occurred at $004B544B :
EInOutError : Can not load Firebird client library libfbclient.so. Check 
your installation.


any comment ?


The current directory on linux is never searched. 
If you want that you must add a complete path.


Michael.___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Antonio Fortuny 

  
  

Le 18/11/2013 13:12, Michael Van
  Canneyt a crit:


  
  
  On Mon, 18 Nov 2013, Antonio Fortuny wrote:
  
  
  

Le 18/11/2013 12:19, Michael Van Canneyt a crit :


  
  
  On Mon, 18 Nov 2013, Antonio Fortuny wrote:
  
  
  Hi Folks.


I'm a little bit annoyed by a boring specification in the
fpc package. When in a program I use the TIBConnection
(along witha transaction and a query), the compiled program
looks for the local libfbclient when establishing the
connection.

So far so good. When I install the program in another Linux
box, running Firebird 2.1, the program complains that

"Can not load default Firebird clients ("libfbclient.so.2.5"
or "libgds.so" or "libfbembed.so.2.5")". Looks normal as
this Linux box uses Firebird 2.1

Is it possible to force what library should be used instead
? (as UIB does)

Having a look inside the code, in ibase60 (lines 2680 and
fw) library names look fixed and looks like the Firebird
version should be fixed before using it.

  
  
  You can do 2 things:
  
  
  1. use the TSQLDBLibraryLoader component from sqldblib (in
  trunk)
  
  
  2. call
  
   function InitialiseIBase60(Const LibraryName : AnsiString)
  : integer;
  

found it in ibase60dyn.pp -- ibase60.inc

before connecting to the DB:

 InitialiseIBase60('libfbclient.so');

compile on one system (OpenSuse x86_64), copy to the target
system (Ubuntu x86_64)

target systemp library /usr/lib/libfbclient.so.2 copied in
current directory as libfbclient.so

then run and:

An unhandled exception occurred at $004B544B :

EInOutError : Can not load Firebird client library
"libfbclient.so". Check your installation.


any comment ?

  
  
  The current directory on linux is never searched. If you want that
  you must add a complete path.
  

Yep, I did find it myself  8-)
  
Thanks anyway Michael.


  
  Michael.
  
  
  
  ___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal


-- 
  

  
  
  
  
 Antonio
Fortuny
  Senior Software engineer
  
  220, avenue de la Libert
  L-4602 Niederkorn
  Tel.: +352 58 00 93 - 93
  www.sitasoftware.lu

  
  
  
  

  

  

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Tony Whyman 

  
  
Antonio,

Be careful on Ubuntu (as with all Debian) you only get
libfbclient.so installed when you also have the development package
(firebird-dev) installed. Better to load the libfbclient.so.2
library which gets installed with the libfclient2 package.

Regards

Tony Whyman
MWA Software

On 18/11/13 12:11, Antonio Fortuny
  wrote:


  
  
  Le 18/11/2013 13:08, Antonio Fortuny
a crit:
  
  


Le 18/11/2013 12:19, Michael Van
  Canneyt a crit:

 
  
  On Mon, 18 Nov 2013, Antonio Fortuny wrote: 
  
  Hi Folks. 

I'm a little bit annoyed by a boring specification in the
fpc package. When in a program I use the TIBConnection
(along witha transaction and a query), the compiled program
looks for the local libfbclient when establishing the
connection. 
So far so good. When I install the program in another Linux
box, running Firebird 2.1, the program complains that 
"Can not load default Firebird clients ("libfbclient.so.2.5"
or "libgds.so" or "libfbembed.so.2.5")". Looks normal as
this Linux box uses Firebird 2.1 
Is it possible to force what library should be used instead
? (as UIB does) 
Having a look inside the code, in ibase60 (lines 2680 and
fw) library names look fixed and looks like the Firebird
version should be fixed before using it. 
  
  
  You can do 2 things: 
  
  1. use the TSQLDBLibraryLoader component from sqldblib (in
  trunk) 
  
  2. call 
   function InitialiseIBase60(Const LibraryName : AnsiString)
  : integer; 

found it in ibase60dyn.pp -- ibase60.inc
before connecting to the DB:
  InitialiseIBase60('libfbclient.so');
  
  changing previous line to 
   InitialiseIBase60('./libfbclient.so');
  works.
  
  Thanks
  
  Antonio.
  
   compile on one system (OpenSuse x86_64), copy to
the target system (Ubuntu x86_64)
target systemp library /usr/lib/libfbclient.so.2 copied in
current directory as libfbclient.so
then run and:
An unhandled exception occurred at $004B544B :
EInOutError : Can not load Firebird client library
"libfbclient.so". Check your installation.

any comment ?

Antonio.

with the correct library name. 
  
  Michael. 
  ___ 
  fpc-pascal maillist - fpc-pascal@lists.freepascal.org
  
  http://lists.freepascal.org/mailman/listinfo/fpc-pascal
  


-- 
  

  
 

  
  
 Antonio


Fortuny
  Senior Software engineer
  
  220, avenue de la Libert
  L-4602 Niederkorn
  Tel.: +352 58 00 93 - 93
  www.sitasoftware.lu

  
  
 

  

  




___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
  
  
  -- 

  

   
  


   Antonio

  Fortuny
Senior Software engineer

220, avenue de la Libert
L-4602 Niederkorn
Tel.: +352 58 00 93 - 93
www.sitasoftware.lu
  


   
  

  

  
  
  
  
  ___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal


  

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] ibase package

2013-11-18 Thread Antonio Fortuny 

  
  

Le 18/11/2013 13:15, Tony Whyman a
  crit:


  
  Antonio,
  
  Be careful on Ubuntu (as with all Debian) you only get
  libfbclient.so installed when you also have the development
  package (firebird-dev) installed. Better to load the
  libfbclient.so.2 library which gets installed with the libfclient2
  package.

Right, I've noticed it. For the time being, I've only copied the
original Firebird library fblclient.so.2 to local fbclient.so.
Anyway, I'm happy because the program works independently of the
current FB library.
On the other hand, we are used to install and work with FB since
years and the library problem is well known. But because I'm also
concerned with Linux application development (mainly services and
libraries  ;-) )
installation team still forgets to install native client FB
librarie.
Thans for focusing my attention on this operational problem.

Antonio.

 
  Regards
  
  Tony Whyman
  MWA Software
  
  On 18/11/13 12:11, Antonio Fortuny
wrote:
  
  


Le 18/11/2013 13:08, Antonio
  Fortuny a crit:


  
  
  Le 18/11/2013 12:19, Michael Van
Canneyt a crit:
  
   

On Mon, 18 Nov 2013, Antonio Fortuny wrote: 

Hi Folks. 
  
  I'm a little bit annoyed by a boring specification in the
  fpc package. When in a program I use the TIBConnection
  (along witha transaction and a query), the compiled
  program looks for the local libfbclient when establishing
  the connection. 
  So far so good. When I install the program in another
  Linux box, running Firebird 2.1, the program complains
  that 
  "Can not load default Firebird clients
  ("libfbclient.so.2.5" or "libgds.so" or
  "libfbembed.so.2.5")". Looks normal as this Linux box uses
  Firebird 2.1 
  Is it possible to force what library should be used
  instead ? (as UIB does) 
  Having a look inside the code, in ibase60 (lines 2680 and
  fw) library names look fixed and looks like the Firebird
  version should be fixed before using it. 


You can do 2 things: 

1. use the TSQLDBLibraryLoader component from sqldblib (in
trunk) 

2. call 
 function InitialiseIBase60(Const LibraryName :
AnsiString) : integer; 
  
  found it in ibase60dyn.pp -- ibase60.inc
  before connecting to the DB:
InitialiseIBase60('libfbclient.so');

changing previous line to 
 InitialiseIBase60('./libfbclient.so');
works.

Thanks

Antonio.

 compile on one system (OpenSuse x86_64), copy to
  the target system (Ubuntu x86_64)
  target systemp library /usr/lib/libfbclient.so.2 copied in
  current directory as libfbclient.so
  then run and:
  An unhandled exception occurred at $004B544B :
  EInOutError : Can not load Firebird client library
  "libfbclient.so". Check your installation.
  
  any comment ?
  
  Antonio.
  
  with the correct library name. 

Michael. 
___ 
fpc-pascal maillist - fpc-pascal@lists.freepascal.org

http://lists.freepascal.org/mailman/listinfo/fpc-pascal

  
  
  -- 

  

   
  


  
Antonio Fortuny
Senior Software engineer

220, avenue de la Libert
L-4602 Niederkorn
Tel.: +352 58 00 93 - 93
www.sitasoftware.lu
  


   
  

  

  
  
  
  
  ___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal


-- 
  

  
  
  
  
 Antonio


Fortuny
  Senior Software engineer
  
  220, avenue de la Libert
  L-4602 Niederkorn
  Tel.: