[firebird-support] Re: Firebird 2.5 connection issue

2014-07-18 Thread Virgo Pärna virgo.pa...@mail.ee [firebird-support]
On 17 Jul 2014 22:02:59 -0700, agus_dela...@yahoo.com.mx [firebird-support] firebird-support@yahoogroups.com wrote: FbConnection conn = new FbConnection(@Server=172.X.XX.XX;User=SYSDBA;Password=masterkey;Database=D:\ng\DATA\CUSTOMER.FDB); But I get the following error: I/O error during

Re: [firebird-support] Firebird 2.5 connection issue

2014-07-18 Thread Σπύρος Μπιμπίλας bibi...@gmail.com [firebird-support]

[firebird-support] substring

2014-07-18 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello, If I use the following code to extract a part of a string, it works fine: s_datum = substring(:dat from 13 for 4); s_datum = char(4) Now I would give the same a stored procedure, the first input parameter is XXX varchar(30), it returns me the integer-value and the status

Re: [firebird-support] Firebird 2.5 connection issue

2014-07-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-7-2014 13:53, Σπύρος Μπιμπίλας bibi...@gmail.com [firebird-support] wrote: FbConnection conn = new FbConnection(@Server=172.X.XX.XX;User=SYSDBA;Password=masterkey;Database=D:\ng\DATA\CUSTOMER.FDB); But I get the following error: I/O error during CreateFile (open) operation for file

Re: [firebird-support] substring

2014-07-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-7-2014 14:00, 'checkmail' check_m...@satron.de [firebird-support] wrote: If I use the following code to extract a part of a string, it works fine: s_datum = substring(:dat from 13 for 4); s_datum = char(4) Now I would give the same a stored procedure, the first input parameter is XXX

Re: [firebird-support] Firebird 2.5 connection issue

2014-07-18 Thread Tim Ward t...@telensa.com [firebird-support]
On 18/07/2014 13:31, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: That would give an entirely different error. The database file either doesn't exist, or the user account running the Firebird service does not have access to this folder. Yes, I've noticed that on Linux - you

Re: [firebird-support] Firebird 2.5 connection issue

2014-07-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-7-2014 14:34, Tim Ward t...@telensa.com [firebird-support] wrote: On 18/07/2014 13:31, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: That would give an entirely different error. The database file either doesn't exist, or the user account running the Firebird service

Re: [firebird-support] Firebird 2.5 connection issue

2014-07-18 Thread 'E. D. Epperson Jr' dixonepper...@gmail.com [firebird-support]
Mark, If he were to use the alias.conf file on his client, would that solve the issue and wouldn't be the best way to do this? -- Dixon Epperson

AW: [firebird-support] substring

2014-07-18 Thread 'checkmail' check_m...@satron.de [firebird-support]
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; if(i_isnumeric

[firebird-support] Re: Firebird 2.5 conf for high load multiple and quick connections

2014-07-18 Thread rud...@gmail.com [firebird-support]
Missed the prime number comment on the setting, thank you.

Re: [firebird-support] substring

2014-07-18 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
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; if(i_isnumeric