Re: Finishing nailing the coffin shut on ODBC? Lassi Kortela 13 Sep 2019 15:30 UTC
> Worse, it's a stab at defining a 4.0 version of ODBC, and there's not > a been change of any substance in the repo since May 2018. The part > you linked to? Not in 3 years. > > It's also useful to note that Microsoft has had at least 3 different > efforts in this niche. Contrary to my previous memory, I'm now pretty > sure the intense OLTP work I did with non-mainframe DB2 UDB was > through OLE DB and COM (https://en.wikipedia.org/wiki/OLE_DB), which > per Wikipedia they were more interested in in the mid-1990s than ODBC. > And were planning on dropping support of this year for SQL Server, > but changed their mind in 2017. > > Since the 1990s, at the same conceptual level, ADO.NET data providers > are their new hotness, a part of their CLR (Common Language Runtime, > i.e. what C# runs on top of). > > All that said, the fate of ODBC is out of their hands, with two > independent but reported to be compatible ODBC Driver Managers and at > least 3 companies providing ODBC drivers for costs that are modest > enough for companies. But that's unacceptable *to base* our database > API efforts on. Better to use JDBC to support "second class" > databases beyond PostgreSQL, SQLite, and should their be a 3rd? > > I'll bring up first and second class support for databases and what > should be in which in a future posting if no one runs with it now. Thanks for investigating all this Harold! Indeed, every aspect of the way they are stewarding the standard seems like a bad bet for us. So no hard feelings from me if ODBC is put to rest :)