Page 1 of 1

64 bit v 32 bit Application Connection Problem

Posted: Thu 22 Mar 2018 14:18
by 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

Re: 64 bit v 32 bit Application Connection Problem

Posted: Mon 26 Mar 2018 10:43
by 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.

Re: 64 bit v 32 bit Application Connection Problem

Posted: Mon 26 Mar 2018 10:49
by 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.

Re: 64 bit v 32 bit Application Connection Problem

Posted: Mon 26 Mar 2018 14:42
by Stellar
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.