From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: libgnadeodbc
Date: Mon, 9 Apr 2018 13:55:52 +0200
Organization: Aioe.org NNTP Server
Message-ID: <pafkc7$1pru$1@gioia.aioe.org>
References: <ohra9f$hd2$1@gioia.aioe.org> <ohrbkc$ji9$1@gioia.aioe.org>
 <dd0144d2-f249-425c-9706-3e8f7a86c202@googlegroups.com>
 <pa81tu$19gp$1@gioia.aioe.org>
 <f66e045b-b56f-437c-9dd5-6082924c3f37@googlegroups.com>
 <pafdn3$1doo$1@gioia.aioe.org> <paffag$1gif$1@gioia.aioe.org>
NNTP-Posting-Host: MyFhHs417jM9AgzRpXn7yg.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.7.0
X-Notice: Filtered by postfilter v. 0.8.3
Content-Language: en-US
Xref: reader02.eternal-september.org comp.lang.ada:51410
Date: 2018-04-09T13:55:52+02:00
List-Id: <comp.lang.ada>

On 09/04/2018 12:29, J-P. Rosen wrote:
> Le 09/04/2018 à 12:02, Dmitry A. Kazakov a écrit :
>> Why there should be any? There are hundreds of RDBMS. It is silly to
>> have bindings for each possible RDBMS client and have a mess of the
>> application if that must work with RDBMS from different vendors.
>>
>> This is why there is ODBC, to have a universal access to any RDBMS. Any
>> decent RDBMS provides ODBC drivers. E.g. MySQL connector comes with ODBC
>> drivers.
> ODBC just provides a protable way to submit queries.

+ binding parameters (SQL has huge problems with literal values)
+ walking the result set

> In my experience,
> the major factor of (lack of) portability if you change your DBMS is in
> the variations in the SQL language, not in the interface.
> 
> So, you are bound to a given DBMS in any way.

Yes, but that is the language problem of SQL.

With ODBC one can at least query the capabilities of the DBMS. Surely 
that is not what the Ada programmer expects: tell the semantics and 
leave the language to implement it, but better than nothing.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de