10.2.2 EAccessError

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aggie85
Posts: 85
Joined: Wed 11 Nov 2015 17:03

10.2.2 EAccessError

Post by Aggie85 » Thu 28 Dec 2017 20:29

Howdy!

Since upgrading to the latest version of Rad Studio Tokyo (10.2.2 2004), I am getting EAccessErrors all over my application with TVirtualQuery. If I replace it with another SQL memory component (TxQuery, TkbmMemSQL, it works fine).

Below are two call stacks that show it is happening in the same place:


:00000001
:029700eb Virtualquery::TVirtualConnection::DoConnect + 0xB
:0287e457 ; SetConnected
:0287b414 Dbaccess::TCustomDAConnection::Connect + 0xC
:0288483a ; BeginConnection
:028857ef ; OpenCursor
:00fa71af ; SetActive
:0288575e ; SetActive
:006AE5EB TNotesGridChildForm::OnLoadDataExecute(this=:104084A0, pProgressDialog=:142F3CA0)
:00628ACF TFormBase::OnLoadDataExecute(this=:1466A9E0, pProgressDialog=:142F3CA0)
:004CDDB7 TCustomerEditDialog::OnLoadDataExecute(this=:1466A9E0, pProgressDialog=:142F3CA0)
:00A30229 TSSDatabaseModule::ExecuteTransaction(this=:0A1B52F0, pTransactionOnExecute={TCustomerEditDialog::OnLoadDataExecute,:1466A9E0}, nRetryCount=2, pProgressDialog=:142F3CA0)
:00628485 TFormBase::OnDoLoadDataExecute(this=:1466A9E0, pProgressDialog=:142F3CA0)
:00FD6341 TSSProgressThread::Execute(this=:14F5BBB0)
:00f45631 Madexcept::_17444 + 0x2D
:00c1bfa0 ; _17957
:00b505d2 System::_17302 + 0x2A
:00f45517 Madexcept::_17442 + 0xF
:00f4557f ; _17443
:77998654 KERNEL32.BaseThreadInitThunk + 0x24
:77ea4a47 ; ntdll.dll
:77ea4a17 ; ntdll.dll

:00000001
:029700eb Virtualquery::TVirtualConnection::DoConnect + 0xB
:0287e457 ; SetConnected
:0287b414 Dbaccess::TCustomDAConnection::Connect + 0xC
:0288483a ; BeginConnection
:02885d7f ; Execute
:02885cc1 Dbaccess::TCustomDADataSet::Execute + 0x15
:00858291 TReservationEditDialogDataModule::OnLoadReservationExecute(this=:151062A0, nReservationID=1000000, pProgressDialog=:16DB0580)
:00846165 TReservationEditDialog::OnLoadDataExecute(this=:14C26F20, pProgressDialog=:16DB0580)
:00A30229 TSSDatabaseModule::ExecuteTransaction(this=:0A1252F0, pTransactionOnExecute={TReservationEditDialog::OnLoadDataExecute,:14C26F20}, nRetryCount=2, pProgressDialog=:16DB0580)
:00628485 TFormBase::OnDoLoadDataExecute(this=:14C26F20, pProgressDialog=:16DB0580)
:00FD6341 TSSProgressThread::Execute(this=:1556D4A0)
:00f45631 Madexcept::_17444 + 0x2D
:00c1bfa0 ; _17957
:00b505d2 System::_17302 + 0x2A
:00f45517 Madexcept::_17442 + 0xF
:00f4557f ; _17443
:77998654 KERNEL32.BaseThreadInitThunk + 0x24
:77ea4a47 ; ntdll.dll
:77ea4a17 ; ntdll.dll

I sure hope it helps reproduce / fix the problem!

Happy New Year!

Aggie85

Aggie85
Posts: 85
Joined: Wed 11 Nov 2015 17:03

Re: 10.2.2 EAccessError

Post by Aggie85 » Thu 28 Dec 2017 22:01

Howdy All!

Follow up ... I rebuild my program to use packages instead of static link and it is working now....

While I hate to distribute so many BPLs, this may be the way to go.

Happy New Year!

Aggie85

MaximG
Devart Team
Posts: 1019
Joined: Mon 06 Jul 2015 11:34

Re: 10.2.2 EAccessError

Post by MaximG » Fri 23 Feb 2018 09:09

Thank you for the information. We continue the work on fixing the detected errors and hope to get a stable version soon, we will let you know immediately.

MaximG
Devart Team
Posts: 1019
Joined: Mon 06 Jul 2015 11:34

Re: 10.2.2 EAccessError

Post by MaximG » Fri 23 Feb 2018 09:10

Thank you for the information. We continue the work on fixing the detected errors and hope to get a stable version soon, we will let you know immediately.

Post Reply