Fwd: [Mono-devel-list] MS Access database and Mono under RH9

[Rafael Teixeira]

Forgot to copy the list.

Also it is unfortunate that we choose to use ".mdb" as the extension
for our debug-information files. Any windows developers experimenting
Mono (and worse: the windows shell/explorer) will think they are MS
Access database files.

I recomend that we change the conflicting extension to ".mdbg" 

Fun,

---------- Forwarded message ----------
From: Rafael Teixeira <monoman at gmail.com>
Date: Thu, 23 Dec 2004 17:39:44 -0200
Subject: Re: [Mono-devel-list] MS Access database and Mono under RH9
To: "Pekus Cons. e Desenvolvimento" <pekus at pekus.com.br>


Hi Baccarin,

The problem is: there is not a good driver/provider for access in the
linux world. You'll need to use our "OLEDB" provider (that uses gda,
if I remember correctly) or the odbc (the linux kind of odbc)
provider, and the MDB Tools (http://mdbtools.sourceforge.net/).

The big problem is MDB Tools just give read access. You can't use it
to update tables in the MS Access .MDB file, so the best thing you can
do with it is to use its tool to extract the schema and data to a real
relational database server (I recommend PostgreSQL).

The cause for all that trouble, as with many other things MS, is that
the MS Access file formats (plural, because they are different from
version to version) are undocumented.

As I said go to something more portable/consistent than MDB files: If
you don't like PostgreSQL (it is still a bit awkward to install/run in
Windows) you may try Firebird, that in Windows can be embedded (as a
native dll) in your application.

Hope it helps a bit,

On Thu, 23 Dec 2004 15:09:56 -0200, Pekus Cons. e Desenvolvimento
<pekus at pekus.com.br> wrote:
>
> Hi,
>
> I would like to do some tests with MS Access databases using mono apps on
> RH9, including asp.net. Is it possible? Does anyone could give me some
> orientation? Do I need to install additional packages to do it?
>
> Regards,
>
> Baccarin.
>
> P.S.: I'm sorry if this is the wrong place to ask about it, please point me
> the correct place.
>


--
Rafael "Monoman" Teixeira
---------------------------------------
I'm trying to become a "Rosh Gadol" before my own eyes.
See http://www.joelonsoftware.com/items/2004/12/06.html for enlightment.


-- 
Rafael "Monoman" Teixeira
---------------------------------------
I'm trying to become a "Rosh Gadol" before my own eyes. 
See http://www.joelonsoftware.com/items/2004/12/06.html for enlightment.