64 bit v 32 bit Application Connection Problem

[KenR]

Hi,

I have a 32 bit app that can connect to the SQL Server (running on the same PC) fine but the 64 bit version cannot connect (using the same settings). The error returned is OLE DB error occurred. Code 80070006h. Both versions of the SQL Server Native Client have been installed. It is a Windows 12 server.

Where should I start looking at how to resolve this? The app is compiled with Delphi 10.2.3 and UniDAC 7.2.5.

Thanks,

Ken

[Stellar]

Try to delete all the versions of SQL Server Native Client on your PC. Then, install SQL Server Native Client 2012 x64. Once it is done, please let us know.

[KenR]

Thanks. It turned out to be that the app was posting to the registry and therefore windows wanted it to be running as administrator. When the posting to the registry was removed everything went back to normal. Doesn't happen on all versions of Windows and also not exactly a helpfull error from MS SQL Server.

[Stellar]

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.