Start learning connection to MSSQL lazarus / 16-Databases ---------------------------------------------------------------------- asdf · 2012-06-03 01:11 Kindly introduce how to learn step-by-step with sample codes. ---------------------------------------------------------------------- Leledumbo · 2012-06-03 03:58 SQLDB has TMSSQLConnection, ZEOS can also connect to it. Other than this connection thing, everything is the same for the any supported dbms. Look for SQLDB tutorial in wiki or read up ZEOS documentation (depending on which one you'd like to use). ---------------------------------------------------------------------- Fortuna1 · 2012-06-03 05:30 I recommend TMSSQLConnection, ZEOSlib  has problem with installations. ---------------------------------------------------------------------- tjpren · 2012-06-03 07:20 Hello asdf, I have recently also begun learning to program with a connection to mssql.  I've used Zeos for a desktop database app, and TMSSQLConnection for a web app using Freespider. Please find my desktop app for reference. Are you looking at a desktop app, or web app? Regards ---------------------------------------------------------------------- BigChimp · 2012-06-03 11:00 For SQLDB MSSQL: There is an MS SQL example in the Lazarus examples directory. For details on the connector and compiling*) the required FreeTDS, see readme in \packages\fcl-db\src\sqldb\mssql\readme.txt *) It's probably easier to just install FreeTDS using your Linux package manager or download a binary version if on Windows.. ---------------------------------------------------------------------- marcov · 2012-06-03 16:41 I never saw confirmed that Zeos supports MSSQL with FPC. It does with Delphi, but Delphi has an oledb header (that zeos uses), and FPC not. ---------------------------------------------------------------------- Christian · 2012-06-03 17:25 Zeos works fine with fpc and mssql ---------------------------------------------------------------------- ludob · 2012-06-03 17:57 QuoteZeos works fine with fpc and mssqlYes, but only with the MS dll's, not freetds, and therefore limited to windows.