Windows 10 Program Access Violation

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Windows 10 Program Access Violation

Post by alwillis1357 » Sun 26 Jun 2016 20:32

I am trying to get my program working on a Windows 10 64-bit installation. I am using version 7.2.8 of SDAC. The program was compiled with Delphi 10.1 Berlin. The SQL Server 2014 version is 12.0.4459.

My program works on Windows 7 and 8.1. No data access problems for years using SDAC drivers.

I am able to connect to the SQL Server. However as soon as I try to access any table I get an Access violation at address xxxx... Read of address 00000000.

I wrote a small test program using TSQLConnection, TSQLDataset, TDatasetProvider, TClientDataset.

When I try to execute a simple select statement like 'SELECT * FROM TABLES' from the clientdataset commandtext the error occurs. The following identical DLLs are loaded in application directory, Windows\SYSWOW and Windows\System32: dbexpsda.dll, dbexpsda30.dll, dbexpsda40.dll.

Please help.

Regards,

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

Re: Windows 10 Program Access Violation

Post by ViktorV » Mon 27 Jun 2016 11:24

In the SDAC version 7.2.8 there was no support for RAD Studio 10.1 Berlin. Support for it was added in SDAC 7.3.11, that was released on 25.04.2016.
It seems like you also use dynamic libraries: dbexpsda.dll, dbexpsda30.dll, dbexpsda40.dll. These libraries point to usage of dbExpress driver for SQL Server. Support for RAD Studio 10.1 Berlin was added in the latest version of dbExpress driver for SQL Server (7.2.4).
Please specify the product you are using and its version.

alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Re: Windows 10 Program Access Violation

Post by alwillis1357 » Mon 27 Jun 2016 13:27

Viktor,

I am so sorry. I posted this to the wrong forum. I'm using dbExpress drivers. The version is 7.2.4.

I installed software to a client's Windows 10 workstation and it wouldn't work. I have since discovered that all of the client's drives, both SSD and conventional, were running with compression tuned on. I suspect this could be a problem.

alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Re: Windows 10 Program Access Violation

Post by alwillis1357 » Tue 28 Jun 2016 16:09

Update:

All hard drives have been decompressed and are functioning normally. I still get an access violation error.

Please advise.

Thanks,

Al

alwillis1357
Posts: 9
Joined: Tue 14 Oct 2008 14:17

Re: Windows 10 Program Access Violation

Post by alwillis1357 » Tue 28 Jun 2016 20:34

Problem fixed. I had dbexpress deployment problems.

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

Re: Windows 10 Program Access Violation

Post by ViktorV » Wed 29 Jun 2016 13:57

It is good to see that the problem has been solved.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply