Open Office Query... has anyone?

Has anyone looked into utilizing the Open Office BASE and CALC programs or wrapping the access tools for BMax? I ask this because I have been studying SQLite / SQLiter and began wondering about common access types.

Microsoft is giving away SQL server and the dev toolset (from what I have heard) I downloaded SQLEXPR.EXE (54mb) from Uncle Billy this afternoon... This program needs .NET 2.0 to run but I think the tools don't.

What I am hoping is that someone who knows more aboutthese tools can hep me! Aside from SQLite what do we have in the way of tools for DBase access??? I plan on using BMax to develop a few applications and the ability to get data from a server would be a HUGE plus!

Ther are both MySQL and PostgreSQL modules for BlitzMAX.

As for MS SQL Server 2005 Express, I wouldn't bother. It's practically worthless for anything but just playing around with.

Be aware that if you're going to use SQLIte it's fairly broken in how it handles data BLOB fields. Basically, as soon as it encounters a zero byte in the BLOB data it will stop writing.

You can Google around for the gory details.

Rook,

You can also use MSDE if you want to go the MS route. It is based on SQL Server 2000 and does not require .net. It is great and you can design the db using standard SQL 2000 tools and then deploy to MSDE with no fuss.

No he can't. MSDE is (if possible) worse than MS SQL Server 2005 Express. Support expires ultimo this year, and it doesn't work on Windows Vista.

If you want to use a database for anything useful, don't use Microsofts costless products.

Which is why I asked about OO Base... Hmmm... someone smarter than me needs to build a wrapper... the tools are there on the Open Office site as I understand...

I might have to switch my grand project design to PureBasic to make this work easily...

Ay Yah!!!