<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Hi Stefan,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thank you for your answer.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Initially the issue was somewhere between Linux Red Hat 7 and QGIS because the same error was when I tried to connect to Oracle using isql.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The reason fro this issue was a known Red hat issue.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Let me explain:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Oracle ODBC driver is libsqora.so.11.1. This file exists in my system under /usr/lib/oracle/11.2/client64/lib/.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>I have run on a terminal ldd command like bellow.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>In one of the result line was: libodbcinst.so.1 => not found.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>So I have created a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>This fix made my Oracle client workable from isql and sqlplus.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>But QGIS still not able to add Oracle layer because the icon does not exists in QGIS Browser and ODBC still has the error:<o:p></o:p></span></p><p class=MsoNormal><b><span style='color:red'>Connection failed – Check settings and try again<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>Extended error information:<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>Unable to initialize ODBC connection to DSN for USER/PASS@CAAR,<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>[unixODBC][Driver Manager] Datasource name not found, and no default driver specified<o:p></o:p></span></b></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>So right now someone who knows the QGIS code should see why Oracle connectivity icon does not exist in QGIS 2.8.2 Linux Red Hat and why ODBC does not work when it tries to connect to Oracle. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Marian<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-CA'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-CA'> Blumentrath, Stefan [mailto:Stefan.Blumentrath@nina.no] <br><b>Sent:</b> June-26-15 3:20 AM<br><b>To:</b> Tudorache, Marian; qgis-user@lists.osgeo.org; ottawa_users@lists.osgeo.org<br><b>Subject:</b> RE: Not able to connect to Oracle via ODBC<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>I had a similar issue with unixODBC and MS SQL.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>If I am not mistaken, the «host” parameter overrides the «Provider/DSN» parameter. It does so for MS SQL, at least.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>For MS SQL it helped to leave the “host” parameter empty and only use Provider/DSN.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>However, there does not seem to be a “Provider/DSN” parameter for neither “Add Oracle Spatial Layer” nor ODBC, …<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>A Bug?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Cheers<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Stefan <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:NO-BOK'>From:</span></b><span lang=EN-US style='mso-fareast-language:NO-BOK'> <a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a> [<a href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Tudorache, Marian<br><b>Sent:</b> 25. juni 2015 23:04<br><b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>; <a href="mailto:ottawa_users@lists.osgeo.org">ottawa_users@lists.osgeo.org</a><br><b>Subject:</b> [Qgis-user] Not able to connect to Oracle via ODBC<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal>Hello,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>What I am trying to do:</b> Add a vector layer from an remote Oracle database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Description:<o:p></o:p></p><p class=MsoNormal>I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2.<o:p></o:p></p><p class=MsoNormal>Add vector Layer<o:p></o:p></p><p class=MsoNormal>Choose Database<o:p></o:p></p><p class=MsoNormal>Type ODBC<o:p></o:p></p><p class=MsoNormal>Click New<o:p></o:p></p><p class=MsoNormal>I filled the form as:<o:p></o:p></p><p class=MsoNormal>Type ODBC<o:p></o:p></p><p class=MsoNormal>Name: myODBCConnection<o:p></o:p></p><p class=MsoNormal>Host: ssfdata<o:p></o:p></p><p class=MsoNormal>Database: CAAR<o:p></o:p></p><p class=MsoNormal>Port: 1521<o:p></o:p></p><p class=MsoNormal>Username: USER<o:p></o:p></p><p class=MsoNormal>Password: PASS<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When I clicked Test Connection I got: <o:p></o:p></p><p class=MsoNormal><b><span style='color:red'>Connection failed – Check settings and try again<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>Extended error information:<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>Unable to initialize ODBC connection to DSN for USER/PASS@CAAR,<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='color:red'>[unixODBC][Driver Manager] Datasource name not found, and no default driver specified<o:p></o:p></span></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I opened a terminal window and I typed:<o:p></o:p></p><p class=MsoNormal>Isql –v caarODBC<o:p></o:p></p><p class=MsoNormal>I was able to connect to my database <o:p></o:p></p><p class=MsoNormal>+------------------------+<o:p></o:p></p><p class=MsoNormal>| Connected |<o:p></o:p></p><p class=MsoNormal>| |<o:p></o:p></p><p class=MsoNormal>| sql –statement |<o:p></o:p></p><p class=MsoNormal>| help [tablename] |<o:p></o:p></p><p class=MsoNormal>| quit |<o:p></o:p></p><p class=MsoNormal>+------------------------+<o:p></o:p></p><p class=MsoNormal>SQL><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So the unixODBC driver works for the database but QGIS is not able to access via ODBC.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Is any special settings related qgis to make ODBC working?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<br>marian<o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:NO-BOK'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:NO-BOK'><hr size=3 width="100%" align=center></span></div><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:gray;mso-fareast-language:NO-BOK'>This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication.<br><br>Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:NO-BOK'><o:p></o:p></span></p></div></body></html>