[fpc-pascal] SqlDB and MS SQL Server support
Michael Van Canneyt
michael at freepascal.org
Wed Aug 13 10:54:38 CEST 2014
On Wed, 13 Aug 2014, Graeme Geldenhuys wrote:
> 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.
More information about the fpc-pascal