0

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

driver error message.

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?

Improve this question
2
  • Maybe Firewall trouble? --> disable firewall temporarily on both client and server. Are they both in the same subnet?. Missing driver files? -->Did you distribute all the required firedac drivers and libs to the linux client? Using runtime libs or one monolithic app? Adding this info might help solving. Commented Jul 20, 2020 at 21:46
  • You should specify either a Driver or a DSN (data source name) in your connection string. See here for more details. Commented Jul 21, 2020 at 7:38

1 Answer 1

Reset to default
2

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.