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@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.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
