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 !
Transaction problem with AssignConnect and DLLs
Re: Transaction problem with AssignConnect and DLLs
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
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
Re: Transaction problem with AssignConnect and DLLs
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
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
Re: Transaction problem with AssignConnect and DLLs
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.
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.
Re: Transaction problem with AssignConnect and DLLs
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
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
Re: Transaction problem with AssignConnect and DLLs
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.
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.