mORMot Open Source

danny

Member

Registered: 2016-08-02

Posts: 13

Proper way to connect MSSQL 2016 in Lazarus (1.8.2)

Hello,
I would like to ask for example of connection to MSSQL 2016 via MORMOT in Lazarus 1.8.2 (windows).
I am so confused, so I prefer ask.

What code for connection and what drivers (dll) are need?

I use a code below for mssql 2012 and is OK, but not work for 2016...

FConnection := TOleDBMSSQL2012ConnectionProperties.Create('server','db','sa', ''); 

THX for some example code ...

Cheers.

Last edited by danny (2018-03-23 21:33:28)

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,544

Website

Re: Proper way to connect MSSQL 2016 in Lazarus (1.8.2)

In my case this code work properly with 2016 and 2012 sql (fpc 3.1.1 x64).  What do you mean by "not work"? Check you have this patch https://synopse.info/fossil/info/5fa480f1951c25a6

Last edited by mpv (2018-03-24 11:48:33)