<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - FILEOPEN (BASE) Connection to Oracle DB via ODBC ends in [ODBC][ORACLE] Optional Feature not implemented"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122779#c20">Comment # 20</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - FILEOPEN (BASE) Connection to Oracle DB via ODBC ends in [ODBC][ORACLE] Optional Feature not implemented"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122779">bug 122779</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>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
<a href="https://www.orafaq.com/wiki/Tnsnames.ora">https://www.orafaq.com/wiki/Tnsnames.ora</a>
- 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>