Registry information is damaged or missing. Make sure the provider is installed and registered correctly

[moezzz]

Hello

I have a license for the Unidac components that I have used for years to connect to SQL SERVER databases.
I recently switched to a SQL SERVER 2017 database in 64 Bits

The configuration is as follows:

• Windows 10 Professional 64 Bits

• SQL Server 2017 64 Bits

• Embaracedro DELPHI 10.3.1

• UNIDAC Professional Edition 7.4.12

I can easily connect with Microsoft SQL Server Management Studio 18 on my migrated SQL Server databases.
But the program hangs when I want to connect using my UNIDAC components with the following message that appears each time : Registry information is damaged or missing. Make sure the provider is installed and registered correctly.

What is the solution, please, to remedy this problem?

thank you in advance

[ertank]

Hello,

Just to clarify your problem further it might help to provide answers to below questions
- Do you have problem establishing a connection in Delphi IDE?
- Is your EXE file 64Bit?

Thanks & regards,
Ertan

[moezzz]

Hello
Yes i can't do a connection in Delphi IDE.
My EXE is in 32 Bits.
In the capture , you can see message triggred when i try to connect to the database.


Thank you.

[Stellar]

If you use the prAuto provider and you don't have the SQL Native Client installed on your machine,
SDAC will use the provider preinstalled with Windows that has limited functionality (prSQL - Microsoft OLE DB Provider for SQL Server). To solve the issue, you can use the provider prDirect or install SQL Native Client on your machine.

UniConnection1.SpecificOptions.Values['Provider'] := 'prDirect';