[Qgis-user] Not able to connect to Oracle via ODBC

[Blumentrath, Stefan]

I had a similar issue with unixODBC and MS SQL.
If I am not mistaken, the «host" parameter overrides the «Provider/DSN» parameter. It does so for MS SQL, at least.
For MS SQL it helped to leave the "host" parameter empty and only use Provider/DSN.

However, there does not seem to be a "Provider/DSN" parameter for neither "Add Oracle Spatial Layer" nor ODBC, ...

A Bug?

Cheers
Stefan

From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Tudorache, Marian
Sent: 25. juni 2015 23:04
To: qgis-user at lists.osgeo.org; ottawa_users at lists.osgeo.org
Subject: [Qgis-user] Not able to connect to Oracle via ODBC

Hello,

What I am trying to do: Add a vector layer from an remote Oracle database.

Description:
I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2.
Add vector Layer
Choose Database
Type ODBC
Click New
I filled the form as:
Type ODBC
Name: myODBCConnection
Host: ssfdata
Database: CAAR
Port: 1521
Username: USER
Password: PASS

When I clicked Test Connection I got:
Connection failed - Check settings and try again

Extended error information:
Unable to initialize ODBC connection to DSN for USER/PASS at CAAR,
[unixODBC][Driver Manager] Datasource name not found, and no default driver specified

I opened a terminal window and I typed:
Isql -v caarODBC
I was able to connect to my database
+------------------------+
| Connected            |
|                              |
| sql -statement     |
| help [tablename] |
| quit                       |
+------------------------+
SQL>

So the unixODBC driver works for the database but QGIS is not able to access via ODBC.

Is any special settings related qgis to make ODBC working?

Thanks,
marian

________________________________
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.

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150626/ecf28fed/attachment.html>