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

[Daniel Morgan]

I second that Rafael!  The mono debugger *.mdb files should be renamed to
*.mdbg

PostgreSQL 8.0 is beautiful on Windows.  It is a native Windows application.
The Installer for it will not allow you to install it for a user with
Administrator privileges.  This is a good thing though.  I've been using an
alpha version of it fine for several months now.

Yeah, someone does need to come up with some C# bindings to using MDB Tools.

-----Original Message-----
From: mono-devel-list-admin at lists.ximian.com
[mailto:mono-devel-list-admin at lists.ximian.com] On Behalf Of Rafael Teixeira
Sent: Thursday, December 23, 2004 2:49 PM
To: Mono Development
Subject: Fwd: [Mono-devel-list] MS Access database and Mono under RH9


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.
_______________________________________________
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list