I have an application running under Windows connecting to a SQL Server. The application works perfectly fine under Windows. The same application should work likewise on Linux (Ubuntu 18.04) via Delphi's cross-platform development. Yet, I get the
.
This happened after installation of the driver via Microsoft's tutorial: https://learn.microsoft.com/de-de/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15
Does someone have any idea what's going wrong?
When I started developing my cross-platform FMX application that was supposed to work with SQL Server, I also used FireDAC in the beginning. But, when it came time to deploy my application on Linux, I ran into similar difficulties. I decided that configuring each client computer to install my application was too laborious and I switched to SDAC, which allows working directly with SQL Server not only on Windows but on Linux and macOS. Now I just need to copy my application, and it works everywhere without any additional settings. I advise you to try this option.