What I am trying to do: Add a vector layer from an remote Oracle database.
Platform: Linux Red hat 7 Database: Oracle 11g Connectivity via unixODBC Oracle
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?