Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail From: Anton Shepelev Newsgroups: comp.databases.ms-sqlserver Subject: Must an ODBC driver use SQLGetPrivateProfileString? Date: Thu, 14 Mar 2019 17:18:42 +0300 Organization: A noiseless patient Spider Lines: 30 Message-ID: <20190314171842.1f1207daddd4748939b9b6aa@g{oogle}mail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Injection-Info: reader02.eternal-september.org; posting-host="f236f4af9ac573e16261ab86277eb60a"; logging-data="19318"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19ekxc0vWDtZlcrS/4dlnWdAnUDILtLMbg=" Cancel-Lock: sha1:fQ2ptjYnVUB8E/vLWY54FWti6nE= X-Newsreader: Sylpheed 3.5.0 (GTK+ 2.24.23; i686-pc-mingw32) Xref: csiph.com comp.databases.ms-sqlserver:2014 Hello, all Must a conforming ODBC driver for ODBC 2.0 or higher use the SQLGetPrivateProfileString function, or can it still query the odbc.ini file directly? The doc- umentation is deplorably silent on this matter: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgetprivateprofilestring-function?view=sql-server-2017 I ask this because the HANA ODBC dirver for Linux read odbc.ini instead of calling SQLGetPrivateProfileString from the driver manager. This causing me some trouble, I reported it as a bug, but they refuse to acknowledge it. The posi- tion of HANA support is that reading odbc.ini di- rectly is perfectly correct and that calling SQLGet- PrivateProfileString implies a dependency upon a specific driver manager (unixODBC in our case), which is of course wrong, for *any* driver manager is required to provide SQLGetPrivateProfileString in a dynamic library. Wish I could refer then to an official document re- quiring that an ODBC driver obtain its DSN informa- tion strictly via SQLGetPrivateProfileString, but I have found no such document. -- () ascii ribbon campaign - against html e-mail /\ http://preview.tinyurl.com/qcy6mjc [archived]