1

I'm currently trying to connect FireDac to a local SQL Server database but I can't seem to find the MSSQL driver ID in FDConnection1. I'm using the Community Edition of Delphi.

enter image description here

Ken White
  • 123,280
  • 14
  • 225
  • 444
Ash
  • 59
  • 6
  • 1
    I would suggest to check if Community Edition can connect to SQL Server at all. Embarcadero often limits connectivity to RDBMS in the Community editions – Sergey Jan 14 '21 at 16:06
  • 1
    I don't think that is an option as noted in the [editions matrix](https://www.embarcadero.com/products/delphi/product-editions) – SMor Jan 14 '21 at 16:06
  • The editions matrix shows that Delphi Community connects only to a limited number of databases on the local machine. It doesn't even allow a remote connection to MySQL – Panagiotis Kanavos Jan 14 '21 at 16:14
  • You can connect to SQLServer using ADO components (named dbGO in Delphi) which are included in CE. – fpiette Jan 14 '21 at 18:04
  • You didn't gave any feedback. Is it now working? If it does, are you doing like I said and use ADO components? – fpiette Feb 13 '21 at 10:50
  • oh sorry, yes, you are right, sql Server databases ar not supported by FireDAC, so I used ADOConnection and all is working well, sorry I completely forgota about you – Ash Feb 13 '21 at 11:27

0 Answers0