Page 1 of 2

StartTransaction trouble !!! with delphi 2010 and ibdac 10

Posted: Mon 22 Feb 2010 13:53
by dehorter
HI


I change computer :) and now i use windows 7 and delphi 2010.
previously, i was on windows xp and delphi 7 with the idbac versio 3.7.

my project worked perfectly :D


but today, i have some trouble with it :(, and i have some difficulties pour understand... :oops: :oops:


In one form containning a TIBCTransaction and TIBCStoreProc components, i received this message :
exception class EIBCError error reading data from connection
This occurs when i try to open a transaction :
TransactionFB.StartTransaction;
It occurs many time but not always !!!!!!!

If the StartTranasction is Ok the same pb occurs when i try to prepare the stored procedure

Code: Select all

QueryFB.PrepareSQL(True);
If this phase works well, the pb occurs anyway when i try to display the next "customer".


and i receive this message
exception class EIBCError error unknown ISC error 0

and sometimes the database connections are closed for ALL users !!!


Any suggestions

olivier

PS : i use now the IBDAC ver 3.10.0.11[/quote]

Posted: Tue 23 Feb 2010 07:56
by dehorter
Hi everybody

Today, i installed a previous version ( 3.10.0.7), and now my project works :wink:.

Maybe this info helps you

olivier

Posted: Tue 23 Feb 2010 14:26
by Dimon
Try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Posted: Tue 23 Feb 2010 17:09
by dehorter
Hi

I can try, but it seems very difficult because :
the error is not systematic
i use your component in many forms of the same project without any pb...


The fact that it is ok with the version 7 whereas with the 11 it doesn't can't help you ?

maybe i can track the bug onto your source ? at least on a first approach ?

olivier

Posted: Wed 24 Feb 2010 08:01
by dehorter
Maybe helps you

I just tested the 9 version, and it works, but the 10th not

So the pb occurs between vers. 9 and 10

olivier

Posted: Wed 24 Feb 2010 11:46
by Dimon
Unfortunately I still can not reproduce the problem.

Posted: Thu 25 Feb 2010 10:56
by dehorter
HI

I cannot create a specific projet showing this trouble also.... :?


Because this error is not systematic, and apparently occurs only a this "place" wheras i use yours components everywhere onto my project !



this morning i create new IBCStoredProc and IBCTransaction components ONLY use inot the procecure where the pb occured in replacement of the previous ones (to be sure to avoid conflict elewhere in the form with the previous).

Thus in the procedure only "new" transaction and stored proc componants are used; but the pb remains

do you have an idea how to help you to solve this pb without to be able to give you an exemple ?

I can send you all my project with the database but it is quite big ????

olivier


PS : I just reintall 9 version and try to compile my project, but i receive a message ' DAAlerter compiled with an other version" of course :D

I deleted this unit, and compilation works fine

helps you ?

Posted: Fri 26 Feb 2010 11:01
by Dimon
Please check that you are using correct client .dll library. Specify the exact version of InterBase server and client. You can see it in the Info sheet of TIBCConnection Editor.

Posted: Fri 26 Feb 2010 13:06
by dehorter
Hi

this is the info :
Server Version: WI-V2.1.0.17798 Firebird 2.1
Client Version: 6.3
ODS Version: 11.1
Client Library: gds32.dll
Database SQL Dialect: 3
regards

olivier

Posted: Fri 05 Mar 2010 15:04
by Dimon
New build of IBDAC version 3.10.0.12 is available for download now. Please check if this build solves the problem.

Posted: Fri 05 Mar 2010 16:02
by dehorter
Hi

unfortunatly not :cry:

I copy information from debug :
Début du Thread : ID du thread : 3512. Processus Bagueur.exe (812)
Exception 'first chance' à $75B79617. Classe d'exception EIBCError avec un message
'
Error reading data from the connection.'. // i continue ... and
Processus Bagueur.exe (812)
Sortie du Thread : ID du thread : 4188. Processus Bagueur.exe (812)
Sortie du Thread : ID du thread : 7376. Processus Bagueur.exe (812)
Début du Thread : ID du thread : 7704. Processus Bagueur.exe (812)
Sortie du Thread : ID du thread : 7704. Processus Bagueur.exe (812)
Sortie du Thread : ID du thread : 3512. Processus Bagueur.exe (812)
Début du Thread : ID du thread : 7408. Processus Bagueur.exe (812)
Exception 'first chance' à $75B79617. Classe d'exception EIBCError avec un message
'
unknown ISC error 0'.
Processus Bagueur.exe (812)

helps you ?

regards

olivier

Posted: Tue 09 Mar 2010 08:08
by Challenger
Please send us to support*devart*com your registration number. We will try to send you the modified build of IBDAC 3.10.0.9.

Posted: Mon 05 Apr 2010 07:57
by dehorter
Hi

do you have more informations about this trouble, and how i can help you ?

regards

olivier

Posted: Tue 06 Apr 2010 08:05
by Dimon
Please, try to compose a sample to demonstrate the problem and send it to dmitryg*devart*com.

Posted: Wed 07 Apr 2010 12:48
by dehorter
Hi


i will try. but as i explained before the trouble occurs onto one procedure whreas elsewhere the idbc componants works.

so i will try to delete useless part of my project, in order to present the only part where pb occurs.
i hope to do that in a couple of days

the pb appeared between sub-version 9 and 10 (so i will use the 10th to test)

regards

olivier