But ODBC access thru ADO/OLEDB will not be available in the near
future. You will have to write code specifically for ODBC in order
to use it.

I believe that most developers are using a more generic way of
talking to databases with any new development. That way they can
switch to another database (Firebird perhaps?) without as much
headache.

And with ODBC not being supported in ADO/OLEDB, you will need
ADO/OLEDB driver for your legacy and new Web development.

The bottom line is that ADO/OLEDB is going to be here for awhile and
most development languages support the use of it, most do not
support the use of .NET.

I'm just looking out for what I think is best for Firebird and what
will give it the greatest chance to grow.


--- In firebird-support@yahoogroups.com, Paul Reeves <paul@f...>
wrote:

> On Thursday 19 May 2005 22:03, buppcpp wrote:
> > snip:
> > MSDASQL: The Microsoft OLE DB Provider for ODBC (MSDASQL)

provides

> > ADO clients access to databases through ODBC Drivers. This has

been

> > the default provider for ADO; however, for future releases of

MDAC

> > and the 64-bit Windows operating system, MSDASQL has been
> > deprecated. Therefore, to access the database from ADO, clients

must

> > use appropriate Native OLE DB Providers, such as SQLOLEDB, to

access

> > Microsoft SQL Server. MSDASQL will be not available on the 64-bit
> > Windows operating system; however, it will still be possible to

use

> > on the 64-bit Windows operating system through the 32-bit Windows
> > subsystem.
> >
> > There will be no support for ODBC and definitely no support for

64-

> > bit ODBC.
> >
>
> This seems to suggest to me that it is OLEDB/ADO that doesn't have

a

> future. The same document you cite states quite clearly that MS

will port

> ODBC to 64-bit, so ODBC quite obviously has a future. And, has

been

> pointed out, MS sees .NET as the future, and the Firebird project

already

> has a driver for it. Who, exactly, is intended to use OLEDB/ADO ?
>
> That said, if you want to provide development funding for a

Firebird

> specific OLEDB provider I would recommend contacting the Firebird
> Foundation. Their specific goal is to co-ordinating funding to

developers

> to undertake projects such as this. (Subject to approval, of

course.)

>
>
> Paul
> --
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird and InterBase