<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 15 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{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="NO-BOK" link="blue" vlink="purple">
<div class="WordSection1">
<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"> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Tudorache, Marian<br>
<b>Sent:</b> 25. juni 2015 23:04<br>
<b>To:</b> qgis-user@lists.osgeo.org; ottawa_users@lists.osgeo.org<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"><span lang="EN-CA">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-CA">What I am trying to do:</span></b><span lang="EN-CA"> Add a vector layer from an remote Oracle database.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Description:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Add vector Layer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Choose Database<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Type ODBC<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Click New<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I filled the form as:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Type ODBC<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Name: myODBCConnection<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Host: ssfdata<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Database: CAAR<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Port: 1521<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Username: USER<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Password: PASS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">When I clicked Test Connection I got: <o:p>
</o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-CA" style="color:red">Connection failed – Check settings and try again<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span lang="EN-CA" style="color:red"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span lang="EN-CA" style="color:red">Extended error information:<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span lang="EN-CA" 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 lang="EN-CA" 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 lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I opened a terminal window and I typed:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Isql –v caarODBC<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I was able to connect to my database <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">+------------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">| Connected |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">| |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">| sql –statement |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">| help [tablename] |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">| quit |<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">+------------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">SQL><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">So the unixODBC driver works for the database but QGIS is not able to access via ODBC.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Is any special settings related qgis to make ODBC working?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Thanks,<br>
marian<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA" 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 lang="EN-CA" 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 lang="EN-CA" 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 lang="EN-CA" 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>