Database Server Error on Windows 7

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
streatley
Posts: 25
Joined: Mon 09 Oct 2006 18:10
Location: Reading, England

Database Server Error on Windows 7

Post by streatley » Fri 19 Mar 2010 13:30

Database Server Error, Wrong MDAC Version, Download latest MDAC version

We have a Delphi application – written in BDS 2006 with a SQL Server backend. This application which has migrated through from Delphi 6 and will, later this year, move to Delphi 2010 uses your DBExpress SQL Server drivers. Although we have subscribed to various updates (up to 4.20) we still use v3.0. We encountered this same error when we first ran on Vista and as a result we moved to v3.10.8.0 and the problem was fixed. We’ve run with this same application and this v3.10.8.0 dll on Windows 7 without any problems. However today a Windows 7 pc’s is showing this MDAC error (there was no change to our exe or your dll so I can only assume a Windows update?).

This raises several questions – what version do we need to use with BDS 2006 and Windows 7? (Ideally as patch to v3.0 – as you did for Vista).

As we will be moving to D2010 what do we need to purchase to upgrade our current licence?

Hope you can help.

Kind regards
Anton Szklarek
Streatley Software Solutions Ltd

[email protected]

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 22 Mar 2010 10:45

To solve the problem try use the SQL Native Client provider. For this you should set the TCRSQLConnection.VendorLib property to 'sqlncli'.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 22 Mar 2010 13:52

I can not reproduce the problem.
Please, try to download the latest DbxSda build (4.55.21) and check if this problem still exists.

streatley
Posts: 25
Joined: Mon 09 Oct 2006 18:10
Location: Reading, England

Post by streatley » Mon 29 Mar 2010 19:20

Having carefully tracked back on recent changes I've made to the Windows 7 pc in question I was eventually able to establish that it was the 'Windows 7 Logo' test suite install (about 10 days ago) that caused the problem. So I did a 'Windows Restore' to before that install and then reapplied the Windows updates and all is now working OK.

So beware if you are installing the Windows 7 Logo test suite (32 bit simulation) it may destabilise any MDAC/WDAC applications!

Regards
Anton

Post Reply