[fpc-pascal] Re: Reading MDB (MS-Access) data under Linux

2010-11-01 Thread Bo Berglund
On Mon, 1 Nov 2010 13:00:23 +0100 (CET), Michael Van Canneyt mich...@freepascal.org wrote: On Mon, 1 Nov 2010, Graeme Geldenhuys wrote: Hi, I need to write a data conversion app. Has anybody read MDB data under Linux yet, using SqlDB? I saw there was a ODBC database component, and

Re: [fpc-pascal] Re: Reading MDB (MS-Access) data under Linux

2010-11-01 Thread Andreas Schneider
On Mon, 01 Nov 2010 13:34:00 +0100, Bo Berglund bo.bergl...@gmail.com wrote: Just tacking on the other MS database MSSQLServer: Is it possible to also work with MS SQLServer databases via ODBC on FPC from Linux? Obviously the SQLServer must be running on Windows so this is about network

Re: [fpc-pascal] Re: Reading MDB (MS-Access) data under Linux

2010-11-01 Thread Graeme Geldenhuys
Op 2010-11-01 14:34, Bo Berglund het geskryf: Just tacking on the other MS database MSSQLServer: Is it possible to also work with MS SQLServer databases via ODBC on I would imagine the only obstacle in that would be to find a ODBC MS-SQL Server driver for Linux. EasySoft has one listed, but I

Re: [fpc-pascal] Re: Reading MDB (MS-Access) data under Linux

2010-11-01 Thread Artur Stuczynski
I only know of a unixodbc driver called FreeTDS. I successfully connected to a MSSQL Server 2008 from my FPC application on Linux, using unixodbc, freetds and sqldb :) I can confirm this setup (FreeTDS+unixodbc) only I accessed SQL Server from Linux via Zeos instead of sqldb. Artur