Transaction problem with AssignConnect and DLLs

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
DanielNTM
Posts: 10
Joined: Fri 14 Jul 2017 06:53
Location: Switzerland

Transaction problem with AssignConnect and DLLs

Post by DanielNTM » Fri 14 Jul 2017 07:19

With version 7.0.2 I have a problem with AssignConnect and the DLLs.
I use Delphi7 with Window7 and Firebird 2.5
It's possible to reproduce the transaction error with your demo in Miscellaneous \ DLL.
Open the main program, connect to a DB then open the Query and the DLL, open the Query and then close Query and DLL, resulting = transaction error

With version 7.0.1 it works perfectly !

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Transaction problem with AssignConnect and DLLs

Post by ViktorV » Mon 17 Jul 2017 12:13

Unfortunately, we could not reproduce the difference in behavior between UniDAC 7.0.1 and 7.0.2. Would you please provide the detailed steps for reproducing the error on our demo as applied to the names of buttons. For example:
1. Click the Connect button.
2. Click the Load DDL button etc.
In addition, please specify the particular version of Firebird and the full text of the error you receive

DanielNTM
Posts: 10
Joined: Fri 14 Jul 2017 06:53
Location: Switzerland

Re: Transaction problem with AssignConnect and DLLs

Post by DanielNTM » Tue 18 Jul 2017 07:31

When I compile our software with v 7.0.2 I have the following message at the end of the dynamic DLL:

Dynamic SQL Error
SQL error code -901
invalid transaction handle (expecting explicit transaction start)

After FreeLibrary

If I change to version 7.0.1, no problems

With UNIEXE.EXE and the UNIDLL DLL of your example, I run:

Connect Button and Open Button

after

LoadDLL button then ShowForm button

From the DLL window, I close the DB then I close the window then I do FreeDLL

Until then there are no problems.

Then I close the Query from the exe window and then I open it
Message: Can not perform operation on inactive transaction !!

I use Delphi 7, with Berlin it's the same problem!
I use Firebird 2.5.7

If you need more information feel free to ask me

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Transaction problem with AssignConnect and DLLs

Post by ViktorV » Tue 18 Jul 2017 10:30

Thank you for the information. We have reproduced the problem associated with the "Can not perform operation on inactive transaction" error and it will be fixed in the next build.
Unfortunately, we could not reproduce the problem associated with the "Invalid transaction handle (expecting explicit transaction start)" error. In order to investigate the issue, please compose a small sample demonstrating the issue and send it to us using the contact form https://www.devart.com/company/contactform.html, including scripts for creating database objects.

DanielNTM
Posts: 10
Joined: Fri 14 Jul 2017 06:53
Location: Switzerland

Re: Transaction problem with AssignConnect and DLLs

Post by DanielNTM » Fri 21 Jul 2017 07:38

I can not send you an example. I go on holiday for 3 weeks.

You have reproduced a problem. Can you correct this problem already?

I really need a version that works, because I use Virtual Query that does not work in v 7.0.1
and I have to switch from 7.0.1 to 7.0.2 to develop !!

Thank you very much

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Transaction problem with AssignConnect and DLLs

Post by ViktorV » Thu 27 Jul 2017 08:54

As we already mentioned, we reproduced and corrected the error "Can not perform operation on inactive transaction" and this fix will be included in the next UniDAC build.
We can not reproduce the problem of "Invalid transaction handle (expecting explicit transaction start)", so we ask you to send us an example demonstrating it.

Post Reply