Ah, that's an interesting clue!

Have you set the CharSet explicitly or do you leave it blank?

If you provide an explicit CharSet then that quick connection thing in
succession will not happen.

IBO goes ahead and gets what the database default charset is and then makes
a connection using that in a second connection where that CharSet can be
passed in.

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|Except
> > > > |0012EB44|004492D8|ion
> > > > |RaisingException | |
> > > > |00000040|04
> > > > |00000040||0012FC9C|00968303|ZT_ML_115.exe|00568303|IB_Component
> > > > |00000040|s
> > > > |TIB_Transaction|API_Start |20100[115] |
> > > > |00000040|04
> > > > |00000040||0012FD5C|0096651E|ZT_ML_115.exe|0056651E|IB_Component
> > > > |00000040|s
> > > > |TIB_Transaction|SysStart |19021[11] |
> > > > |00000040|04
> > > > |00000040||0012FD68|0096773E|ZT_ML_115.exe|0056773E|IB_Component
> > > > |00000040|s
> > > > |TIB_Transaction|SetStarted |19652[4] |
> > > > |00000040|04 |0012FD78|0092EC39|ZT_ML_115.exe|0052EC39|IB_Schema
> > > > | |GetOldParameterOrder |2163[14] |
> > > > |00000040|04
> > > > |00000040||0012FDFC|00960742|ZT_ML_115.exe|00560742|IB_Component
> > > > |00000040|s
> > > > |TIB_Connection |SysAfterConnect |16677[38] |
> > > > |00000040|04
> > > > |00000040||0012FE60|009601BA|ZT_ML_115.exe|005601BA|IB_Component
> > > > |00000040|s
> > > > |TIB_Connection |SysLogin |16491[23] |
> > > > |00000040|04
> > > > |00000040||0012FE78|009600A7|ZT_ML_115.exe|005600A7|IB_Component
> > > > |00000040|s
> > > > |TIB_Connection |SysConnect |16454[14] |
> > > > |00000040|04
> > > > |00000040||0012FE88|0095CCED|ZT_ML_115.exe|0055CCED|IB_Component
> > > > |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 |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 |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