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 LayerChoose DatabaseType ODBCClick New
I filled the form as:
Type ODBCName: myODBCConnectionHost: ssfdataDatabase: CAARPort: 1521Username: USERPassword: 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 CAAR,[unixODBC][Driver Manager] Datasource name not found, and no default driver specified
I opened a terminal window and I typed:Isql –v caarODBCI 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?
أكثر...
Description:I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2.
Add vector LayerChoose DatabaseType ODBCClick New
I filled the form as:
Type ODBCName: myODBCConnectionHost: ssfdataDatabase: CAARPort: 1521Username: USERPassword: 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 CAAR,[unixODBC][Driver Manager] Datasource name not found, and no default driver specified
I opened a terminal window and I typed:Isql –v caarODBCI 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?
أكثر...