Devart Forums

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

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

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.

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';