StartTransaction trouble !!! with delphi 2010 and ibdac 10

dehorter · Post by **dehorter** » Mon 22 Feb 2010 13:53

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

but today, i have some trouble with it

, and i have some difficulties pour understand...

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]

dehorter · Post by **dehorter** » Tue 23 Feb 2010 07:56

Hi everybody

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

.

Maybe this info helps you

olivier

Dimon · Post by **Dimon** » Tue 23 Feb 2010 14:26

Try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

dehorter · Post by **dehorter** » Tue 23 Feb 2010 17:09

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

dehorter · Post by **dehorter** » Wed 24 Feb 2010 08:01

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

Dimon · Post by **Dimon** » Wed 24 Feb 2010 11:46

Unfortunately I still can not reproduce the problem.

dehorter · Post by **dehorter** » Thu 25 Feb 2010 10:56

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

I deleted this unit, and compilation works fine

helps you ?

Dimon · Post by **Dimon** » Fri 26 Feb 2010 11:01

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.

dehorter · Post by **dehorter** » Fri 26 Feb 2010 13:06

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

Dimon · Post by **Dimon** » Fri 05 Mar 2010 15:04

New build of IBDAC version 3.10.0.12 is available for download now. Please check if this build solves the problem.

dehorter · Post by **dehorter** » Fri 05 Mar 2010 16:02

Hi

unfortunatly not

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

Challenger · Post by **Challenger** » Tue 09 Mar 2010 08:08

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.

dehorter · Post by **dehorter** » Mon 05 Apr 2010 07:57

Hi

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

regards

olivier

Dimon · Post by **Dimon** » Tue 06 Apr 2010 08:05

Please, try to compose a sample to demonstrate the problem and send it to dmitryg*devart*com.

dehorter · Post by **dehorter** » Wed 07 Apr 2010 12:48

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