Ok, I have been working with Magnus in Sweden and we have 100% solved this
issue.

The fix will be in Build 8.

If anyone would like the simple patch to apply to your current sources, here
it is:

In TIB_Transaction.API_Start find this code that looks like this:

While ( ErrCode <> isc_conn_lost ) and
( ABS(GetTickCount-2000) > Abs(ticks) ) do
ErrCode := isc_start_multiple( ... )


What needs to happen is to simply remove the while loop and leave just the
call to the API.

For some reason, the way this loop was coded, it completely skipped making
the API call.

This is old code to deal with IB 4.x or IB 5.x instability to auto-recover
from something quirky. I am just going to strip that out.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Felipe Aron
Sent: Monday, August 26, 2013 11:39 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re: IBO 5.2.0.7 and strange error on connect to the
server

Sure, no problem! I see the source.


2013/8/26 IBO Support List <supportlist@...>

> **
>
>
> I have just posted some additional information gathering to the tip of
> my development repository.
>
> Could you do the following please?
>
> Update to the latest in my SVN repository.
> Turn on mgClientTrace in MonitorGroups for your TIB_Monitor.
> Regenerate this SQL trace again with the new information.
>
> Thanks!
>
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf Of DanyM
> Sent: Monday, August 26, 2013 2:23 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: IBO 5.2.0.7 and strange error on connect to the
> server
>
> In another post in this thread you asked for a Monitor dump. This is
> what i get on that machine:
>
> /*---
> CONNECT DATABASE '192.168.100.15:D:\Data\firstlane\shia.fdb'
> user_name = 'SYSDBA'
> password = '********' (redacted)
> DB_HANDLE = 1
>
> SECONDS = 0,016
> ----*/
> /*---
> START TRANSACTION
> DB HANDLE COUNT 1
> DB HANDLE 1 = 1
> TPB VERSION 3
> read
> TR_HANDLE = 2
>
> SECONDS = 0,031
> ----*/
> /*---
> DATABASE INFO
> DB_HANDLE = 1
> ----*/
> /*---
> EXECUTE IMMEDIATE 2
> DB_HANDLE = 1
> TR_HANDLE = 2
> Dialect = 3
>
> SELECT D.RDB$CHARACTER_SET_NAME FROM RDB$DATABASE D
>
> PARAMS = [ ]
> FIELDS = [ Version 1 SQLd 1 SQLn 1 BasePtr: 0017F474 [CHARSET] =
> 'WIN1252 ' (128 bytes) < TEXT SubType: 0 Len: 128 Scale: 0 Ind/SQL
> Data Offsets:
> 0/-142 > ]
> ----*/
> /*---
> COMMIT
> TR_HANDLE = 2
>
> SECONDS = 0,015
> ----*/
> /*---
> DISCONNECT DATABASE
> DB_HANDLE = 1
> ----*/
> /*---
> CONNECT DATABASE '192.168.100.15:D:\Data\firstlane\shia.fdb'
> user_name = 'SYSDBA'
> password = '********' (redacted)
> lc_ctype = 'WIN1252'
> DB_HANDLE = 3
> ----*/
> /*---
> DATABASE INFO
> DB_HANDLE = 3
>
> SECONDS = 0,016
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0 MSG_LEN = 19 ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0 MSG_LEN = 19 ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0 MSG_LEN = 19 ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
>
> This indicates that our affected machines are having problems issuing
> two connection in rapid sequence. Odd...
>
> HTH,
>
> /D
>
> --- In IBObjects@yahoogroups.com, "DanyM" <danymarmur@...> wrote:
> >
> >
> >
> > Ops! Mee too!
> >
> > Same scenario: A client windows small business server 2008. Affects
> > the
> IB_FTS Util and my FTS indexing service on that machine. Tried to
> fiddle with the connection parameters to no avail
> (localhost/127.0.0.1/DNS Name) alias or path. No go.
> >
> > The Util is 32-bit and the service is 64-bit. Same diagnose.
> >
> > I can not restart the server from here, but i'll ask the on-site
> > people
> to
> do it when possible.
> >
> > Oh, and i too accessed the clients using Terminal Sever.
> >
> > Regards,
> >
> > /Dany
> >
> >
> >
> > --- In IBObjects@yahoogroups.com, Markus Ostenried <macnoz@> wrote:
> > >
> > > Just had the same problem in an Amazon Windows Server 2012 instance.
> > > Restarting the instance fixed it for now.
> > >
> > >
> > > On Fri, Aug 2, 2013 at 1:10 AM, garethm <gareth@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi,
> > > >
> > > > I have also had sporadic issues with this problem in our
> > > > internal
> testing.
> > > >
> > > > Here are our observations:
> > > > - We are currently using IBO-5.2.0 Build 6.
> > > > - It can happen when connecting to a Firebird server using TCP
> > > > and when using Firebird in embedded mode.
> > > > - Once this happens, the only way to get applications that use
> > > > IBObjects to connect to databases again appears to be to restart
> > > > the
> computer.
> > > > Neither restarting the application nor reinstalling the
> > > > application make any difference.
> > > > - Once this happens, our applications cannot connect to local or
> > > > remote databases and both network and embedded Firebird
> > > > connection attempts throw the same "ISC ERROR CODE: 335544648
> > > > unknown ISC error
> code 0" exceptions.
> > > > - FlameRobin running on the computer experiencing the issues can
> > > > connect to both local and remote databases without issue.
> > > > - Our application running on other computers can connect to the
> > > > Firebird server running on an affected machine without issue.
> > > > - In one case, this happened after the user logged in to their
> > > > computer via remote desktop, and we aren't sure about the other
> cases.
> > > >
> > > > Any advice on resolving this issue would be appreciated.
> > > >
> > > > Regards,
> > > > Gareth Marshall
> > > >
> > > >
> > > > --- In IBObjects@yahoogroups.com, Marcin Bury <marcin.bury@> wrote:
> > > > >
> > > > > Hello
> > > > >
> > > > > I have recently upgraded IBO library to 5.2.0.7 (the latest
> version).
> > > > > Everything works great except one customer environment. There
> > > > > is MS Terminal Server where application compiled with latest
> > > > > IBO returns following exception after connecting to the
> > > > > Firebird server
> > > > [2.5.1.26266] :
> > > > >
> > > > > ISC ERROR CODE:335544648
> > > > >
> > > > > ISC ERROR MESSAGE:
> > > > > unknown ISC error 0
> > > > >
> > > > > I did some searching and found that this error code represents
> > > > > following
> > > > > error:
> > > > >
> > > > > 335544648 conn_lost Connection lost to pipe server
> > > > >
> > > > > I haven't noticed any similar behavior elsewhere.
> > > > >
> > > > > Below is attached call stack from EurekaLog.
> > > > > Maybe someone will be able to suggest something how to find
> > > > > the cause of the exception...
> > > > >
> > > > > Thanks
> > > > > Marcin
> > > > >
> > > > >
> > > > > |
> > > > > |----------------------------------------------------------|
> > > > > |7FFFFFFE|04
> > > > > |7FFFFFFE||00000000|0090D224|ZT_ML_115.exe|0050D224|IB_Session
> > > > > |TIB_SessionBase|HandleException |1599[106] |
> > > > > |00000040|04 |0012EB20|00719A46|ZT_ML_115.exe|00319A46|EInject
> > > > > | |GetExceptionStackInfoHook |364[9] |
> > > > > |00000040|03
> > > > > |0012EB44|004492D8|ZT_ML_115.exe|000492D8|System.SysUtils|Exce
> > > > > |0012EB44|004492D8|pt
> > > > > |0012EB44|004492D8|ion
> > > > > |RaisingException | |
> > > > > |00000040|04
> > > > > |00000040||0012FC9C|00968303|ZT_ML_115.exe|00568303|IB_Compone
> > > > > |00000040||0012FC9C|00968303|nt
> > > > > |00000040|s
> > > > > |TIB_Transaction|API_Start |20100[115] |
> > > > > |00000040|04
> > > > > |00000040||0012FD5C|0096651E|ZT_ML_115.exe|0056651E|IB_Compone
> > > > > |00000040||0012FD5C|0096651E|nt
> > > > > |00000040|s
> > > > > |TIB_Transaction|SysStart |19021[11] |
> > > > > |00000040|04
> > > > > |00000040||0012FD68|0096773E|ZT_ML_115.exe|0056773E|IB_Compone
> > > > > |00000040||0012FD68|0096773E|nt
> > > > > |00000040|s
> > > > > |TIB_Transaction|SetStarted |19652[4] |
> > > > > |00000040|04
> > > > > |00000040||0012FD78|0092EC39|ZT_ML_115.exe|0052EC39|IB_Schema
> > > > > | |GetOldParameterOrder |2163[14] |
> > > > > |00000040|04
> > > > > |00000040||0012FDFC|00960742|ZT_ML_115.exe|00560742|IB_Compone
> > > > > |00000040||0012FDFC|00960742|nt
> > > > > |00000040|s
> > > > > |TIB_Connection |SysAfterConnect |16677[38] |
> > > > > |00000040|04
> > > > > |00000040||0012FE60|009601BA|ZT_ML_115.exe|005601BA|IB_Compone
> > > > > |00000040||0012FE60|009601BA|nt
> > > > > |00000040|s
> > > > > |TIB_Connection |SysLogin |16491[23] |
> > > > > |00000040|04
> > > > > |00000040||0012FE78|009600A7|ZT_ML_115.exe|005600A7|IB_Compone
> > > > > |00000040||0012FE78|009600A7|nt
> > > > > |00000040|s
> > > > > |TIB_Connection |SysConnect |16454[14] |
> > > > > |00000040|04
> > > > > |00000040||0012FE88|0095CCED|ZT_ML_115.exe|0055CCED|IB_Compone
> > > > > |00000040||0012FE88|0095CCED|nt
> > > > > |00000040|s
> > > > > |TIB_Connection |Connect |15426[7] |
> > > > > |00000040|04 |0012FEA0|00F4102C|ZT_ML_115.exe|00B4102C|DM
> > > > > |T_DM |Set_DB_Connection |453[8] |
> > > > > |00000040|04 |0012FEC8|00F3F7A3|ZT_ML_115.exe|00B3F7A3|DM
> > > > > |T_DM |DataModuleCreate |142[14] |
> > > > > |00000040|03
> > > > > |0012FEF4|004E946F|ZT_ML_115.exe|000E946F|System.Classes
> > > > > |0012FEF4|004E946F||TDataModule
> > > > > |DoCreate | |
> > > > > |00000040|03
> > > > > |0012FF18|004E931C|ZT_ML_115.exe|000E931C|System.Classes
> > > > > |0012FF18|004E931C||TDataModule
> > > > > |AfterConstruction | |
> > > > > |00000040|03
> > > > > |0012FF40|004E92FA|ZT_ML_115.exe|000E92FA|System.Classes
> > > > > |0012FF40|004E92FA||TDataModule
> > > > > |Create | |
> > > > > |00000040|03
> > > > > |00000040||0012FF74|007095E6|ZT_ML_115.exe|003095E6|Vcl.Forms
> > > > > |TApplication |CreateForm | |
> > > > > |00000040|04 |0012FFAC|014C8281|ZT_ML_115.exe|010C8281|ZT_ML
> > > > > | |Initialization |92[5] |
> > > > > |00000040|03 |0012FFC4|7C82F23B|kernel32.dll
> > > > > |00000040||0002F23B|kernel32
> > > > > | |(possible ProcessIdToSessionId+521)| |
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
> ------------------------------------
>
> __________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase without the need for BDE, ODBC or any other layer.
> __________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers, keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>

--
Analista-Programador
#FollowMe: @felipearon <http://twitter.com/felipearon> (
http://felipearon.net)


[Non-text portions of this message have been removed]



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links