Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-14 Thread Marco van de Voort
Last night I googled some more. Conclusions: 1. the oledb.tlb isn't easy to find, but it does exist https://code.google.com/p/py-com-tools/source/browse/trunk/sdk-tlbs/?r=2 Maybe it is in the full platform SDK, but I didn't have that readily available. The result doesn't compile, it's only a si

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Graeme Geldenhuys
On 2014-08-13 11:36, Marco van de Voort wrote: > ... from our site: > > ftp://ftp.freepascal.org/fpc/contrib/windows/ Thanks again, that came in very useful. Regards, - Graeme - -- fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Graeme Geldenhuys
On 2014-08-13 09:54, Michael Van Canneyt wrote: > To my knowledge, there are pre-compiled freetds libraries available. Thanks, I got those from Marco's link he posted. > Relatively, although I would not say it is on par with e.g. Firebird, > Postgres. I'm only writing a small tool for monitori

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Marco van de Voort
In our previous episode, Sven Barth said: > > > > Well, and SEH should be on by default for 32-bit I guess? > > Definitely! :) > > > Anyway the typelibs seems to mostly work: > > Do the generated units also compile? Yes, the only problem is that they are not OLEDB as Delphi has the unit. Probab

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Sven Barth
Am 13.08.2014 15:32 schrieb "Marco van de Voort" : > > In our previous episode, Sven Barth said: > > > > it uses ADO as the 'native' layer. > > > > > > (afaik OLEDB, a layer deeper/older of which ADO is a superset, but > > conclusion is the same) > > > > Using our Typelibrary converter and a bit of

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Marcos Douglas
On Wed, Aug 13, 2014 at 3:34 AM, 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++

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Marco van de Voort
In our previous episode, Sven Barth said: > > > it uses ADO as the 'native' layer. > > > > (afaik OLEDB, a layer deeper/older of which ADO is a superset, but > conclusion is the same) > > Using our Typelibrary converter and a bit of time we could write a ADO > driver for SQL-DB, then the FreeTDS l

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Sven Barth
Am 13.08.2014 12:32 schrieb "Marco van de Voort" : > > In our previous episode, Michael Van Canneyt said: > > > 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? > > > >

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Marco van de Voort
In our previous episode, Michael Van Canneyt said: > > 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 comp

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Marco van de Voort
In our previous episode, Michael Van Canneyt said: > > 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

Re: [fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread 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'

[fpc-pascal] SqlDB and MS SQL Server support

2014-08-13 Thread Graeme Geldenhuys
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). Could somebody explai