[firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread venussof...@gmail.com [firebird-support]
Hi all I found that on my 64 bit i5, 64 bit Win7 that there were both 32 and 64 bit installations of FireBird. So I uninstalled the 32 bit. Now I cannot load the database via ODBC, it raises the error: Connectivity error: [ODBC Firebird Driver]Unable to connect to data source: library

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Bhavbhuti, ASAIK, 32bit ODBC-driver can connect to 32bit Firebird only. Regards, Thomas Am 21.07.2014 08:21, schrieb venussof...@gmail.com [firebird-support]: Hi all I found that on my 64 bit i5, 64 bit Win7 that there were both 32 and 64 bit installations of FireBird. So I

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 06:29 p.m. 21/07/2014, Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support] wrote: Hi Bhavbhuti, ASAIK, 32bit ODBC-driver can connect to 32bit Firebird only. Not so. The ODBC driver is part of the client layering. He needs to place the 32-bit Firebird client library in the path

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 07:30 p.m. 21/07/2014, Venus Software Operations venussof...@gmail.com [firebird-suppo wrote: Yes, I already have a copy of the 32 bit fbclient.dll in my application folder. Why would the FB ODBC driver expect such an old name of dll? I can of course rename the fbclient.dll to gds32.dll,

Re: [firebird-support] gds32.dll failed to load ODBC32+FB64+App32

2014-07-21 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

AW: AW: [firebird-support] substring

2014-07-21 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello wrote: Hello Mark, Here the code of the sub-Procedure: create or alter procedure P_U_CN_TO_INT ( CN_IN varchar(30)) returns ( INT_OUT integer, STATUS smallint) AS declare variable I_ISNUMERIC smallint; BEGIN select true_param from p_u_isnumeric(:cn_in) into :i_isnumeric;

[firebird-support] concurrency in firebird

2014-07-21 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello everybody, I need to split an input string and import some data in tables, like this (simplified) '123423453456' In this case, the value 1 is 1234, value 2 = 2345. With a while loop the values were inserted, if I get an error (value is not a integer), then I will delete all records with

SV: [firebird-support] concurrency in firebird

2014-07-21 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hello everybody, I need to split an input string and import some data in tables, like this (simplified) ‘123423453456’ In this case, the value 1 is 1234, value 2 = 2345. With a while loop the values were inserted, if I get an error (value is not a integer), then I will delete all records with

SV: [firebird-support] Unable to get F_AGEINDAYS function to work

2014-07-21 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
I am trying to get the F_AGEINDAYS function to work without any success. select TOTSOLD_PRODUCT, TOTSOLD_QTYSOLD, F_AGEINDAYS(TOTSOLD_SOLDDATE, TOTSOLD_LISTDATE) as roi_days from TOTAL_SALES; If you're using Firebird 2.1 or more recent, DATEDIFF is an alternative. Better, if your fields are