Windows 10 Program Access Violation

[alwillis1357]

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]

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]

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]

Update:

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

Please advise.

Thanks,

Al

[alwillis1357]

Problem fixed. I had dbexpress deployment problems.

[ViktorV]

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.