[Lazarus] Simple MSSQL database connection fails from Lazarus 1.6/FPC 3.0.0...

[Michael Van Canneyt]

On Tue, 23 Feb 2016, Bo Berglund wrote:

> I just installed Lazarus release 1.6 from svn sources and it seemed
> OK. I have FPC 3.0.0 also installed from svn sources.
> All is installed on a Raspbian Jessie system on a Raspberry Pi2
> device.
>
>
> When I click the btnOpenDB to run the OpenConnection method an
> exception is generated:
>
> Debugger Exception Notification
> Project DBTest raised exception class 'EInOutError' with message:
> Can not load DB-Lib client library "libsybdb.so". Check your
> installation.
> Success
>
> At address 2FCBE4
>   [Break]   [Continue]
>
> I thought that since there was a SQLDb component TMSSQLConnection
> available it would be possible to connect to a database server running
> MSSQL, but apparently something is missing here.
> THe message talks about libsybdb.so, what is that and do I need some
> other stuff to go with Lazarus to do database work?

This is the FreeTDS library, an open source library that is needed to
connect to SQL Server. FPC's SQLDB TMSSQLConnection implementation uses 
this library.

You simply need to install it on your system (if it is available).
Install also the -dev version of the package.

Michael.