[fpc-pascal] SqlDB and MS SQL Server support

[Michael Van Canneyt]

On Wed, 13 Aug 2014, Graeme Geldenhuys wrote:

> Hi,
>
> Looking at the FPC 2.6.4 fcl-db source folder it seems that SqlDB does
> have MS SQL Server support. What confuses me is that the readme.txt
> files mentions that I must download FreeTDS sources and compile it with
> MS Visual C++ (a compiler I don't have and have never used).

To my knowledge, there are pre-compiled freetds libraries available.

>
> Could somebody explain the situation with SqlDB and MS SQL Server support?
>
> * Must I have C++ compiler

No, not if you have a pre-compiled binary version of the freetds library.

> * Is the MS SQL Server support any good?

Relatively, although I would not say it is on par with e.g. Firebird, Postgres.

> * What version of MS SQL Server is supported?

Any version that FreeTDS supports (up to 2008, if memory serves me well)

>
> The program I am writing is going to run on the server which hosts SQL
> Server, so client libraries should all be there. Do I still need this
> FreeTDS library mentioned?

I think yes, I don't think that MS-SQL server still provides a native client library,
it uses ADO as the 'native' layer.

>
> Is FPC 2.7.1 support any better - I could use that if I must.
>
> While I'm at it, has anybody implemented MS SQL Server support in tiOPF?
> If so, do you mind sharing? Though it normally takes 30-60 minutes to
> add a new persistence layer, but that is 30-60 I could save. ;-)

Not to my knowledge.

Michael.