[Mono-list] Re: Tentative Gda query/request

Tim Coleman tim@timcoleman.com
Thu, 6 Feb 2003 22:13:21 -0500


On Fri, Feb 07, 2003 at 11:48:37AM +1000, Darren Tuer wrote:
> Tim,
> 
> I was wondering if you would be kind enough to spare some time to assist
> with a request.
> 
> I have been following the mono:: project for many months now, and have been
> tinkering with it for some time.  I've been quietly porting one of our key
> applications to use mono as a way of showcasing the possibilities that this
> opens up for us.
> 
> For some weeks now I have been endevouring to set up communication with an
> Oracle 8.1.7 database to no avail.  I have downloaded unixODBC, iODBC and
> trolled the net looking for ODBC drivers for Oracle that aren't tragically
> crippled like the current offerings from OpenLink and DataDirect.  I have
> had quite some level of success with setting up the Oracle client on the
> client machine, and can work with the database via SQLNet so I know that the
> Net8 stuff is all fine & dandy on the client machine ( a linux box running
> RedHat 8)
> 
> I have pretty well given up on using ODBC and are now looking at libgda as
> the means of communication ( probably the better of the two anyway ).
> However, after downloading all the libgda sources and RPM's from the GnomeDB
> ftp site, I note that there is no sign of an Oracle provider for gda.
> 
> In desperation I was trolling through the mono mailing lists and noted that
> there was an email stating that you had developed just such an oracle
> provider.  Normally I would just continue to search without emailing people
> who probably get far too much email to wade through anyway, but I've become
> rather desperate.
> 
> I was wondering if you could let me know where I could possibly obtain a
> copy ?
> 

I haven't actually worked on the provider since the summer, but it
should be there.  It is possible that you are working with an older
version.  I'm not sure if the version of libgda which contains the
Oracle provider is available in Red Hat 8.  You might also need to 
download a separate package to get the Oracle provider. I believe
this is the case on debian.

Check out http://www.gnome-db.org for more information. 

One thing you might find interesting is that Daniel Morgan
(danmorg@sc.rr.com) was working on a Mono Oracle provider.
I'm not sure how far along he got with it.  I would really
like to see that project succeed.  It uses the Oracle Call
Interface as a shared library, without using libgda at all.
We wish to implement the Microsoft .NET Framework 1.1 
System.Data.OracleClient namespace at some point.

If you have any other questions, please feel free to send me more
mail.

Thanks,

-- 
Tim Coleman <tim@timcoleman.com>                       [43.43 N 80.45 W]
BMath, Honours Combinatorics and Optimization, University of Waterloo
Software Developer, Global Services, Open Text Corporation
"Under capitalism, man exploits man.  Under communism, it's just the
 opposite." -- J.K. Galbraith