[Libreoffice-bugs] [Bug 122779] FILEOPEN (BASE) Connection to Oracle DB via ODBC ends in [ODBC][ORACLE] Optional Feature not implemented

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122779

--- Comment #20 from Julien Nabet <serval2412 at yahoo.fr> ---
On Win10 64 bits with master sources updated today, I could open an Oracle DB
with ODBC.

I installed "Oracle Instant Client Basic"
+ pack "ODBC Oracle Instant Client"

Here extra steps I did:
- unpack "Oracle Instant Client Basic" in C:\oracle\instantclient_19_6
- unpack "ODBC Oracle Instant Client" in C:\oracle\instantclient_19_6
- create subdirs: C:\oracle\instantclient_19_6\network and
C:\oracle\instantclient_19_6\network\admin
- created a file Tnsnames.ora in C:\oracle\instantclient_19_6\network and
C:\oracle\instantclient_19_6\network\admin
- filled Tnsnames.ora by taking example from
https://www.orafaq.com/wiki/Tnsnames.ora
- modified system env var path to add "C:\oracle\instantclient_19_6"
- created a new system env var TNS_ADMIN :
C:\oracle\instantclient_19_6\network\admin
- restart PC so sys var envs changes are taken into account
- create User datasource

Then I created a brand new odb file and use ODBC connection + require password,
selected the connection and tested it ok.

Finally, I could open a table but noticed this on console:
warn:legacy.osl:11208:1336:connectivity/source/drivers/odbc/OConnection.cxx:68:
Failure from SQLDisconnect

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200428/1ea7e1ee/attachment.htm>