Questions tagged [odbc]

A standardized interface to access databases.

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
553 views

Connecting QGIS 2.x to Firebird Database via ODBC?

I tried to connect a Firebird Database in QGIS 2.2 and 2.4 via ODBC to a database and get following error message: Unable to initialize ODBC connection to DSN for SYSDBA/masterkey@Akdees [...
2
votes
0answers
399 views

Insert a MultiPolygon in a PostGIS table with MapInfo?

I'm using MapInfo 16 to edit a PostGIS table through ODBC driver. The geometry column type of my table is MultiPolygon. The value in spatialtype colmun of a record in mapinfo.mapinfo_mapcatalog table ...
2
votes
0answers
282 views

ODBC connection issue on 64bit architecture

I'm migrating an addin to a 64bit machine using Arcmap 9.3.1. Upon execution, it returns the following error - "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch ...
1
vote
1answer
101 views

List all tables with ogr_fdw ODBC connection

I have been using ogr_fdw to connect PostgreSQL/PostGIS databases to FireBird databases via ODBC connection on Windows machines. The connections have been working great, and are immensely useful for ...
1
vote
0answers
134 views

Read >1 geometry fields into QGIS via ODBC from non-spatial database

I have a non-spatial database in FileMaker Pro that has two geometry fields per record (line and point). The database has a geometry_columns table and using the method outlined by @MerseyViking at ...
1
vote
0answers
108 views

issues in table reading from MS Access using ODBC

I want to add two tables from my MS Access db. So I follow the procedure to add ODBC (add vector layer, database, etc.) and it works. I choose the tables that I want to add and hit ok. Qgis adds both ...
1
vote
0answers
453 views

Is there any way to connect features (entities) of dxf to database in python?

I'm using gdal, ezdxf, sqlite python packages and sqlite ODBC driver. They work fine, and in AutoCAD I can easily manually connect to my dbase.sqlite (read only) using _DBCONFIGURE and _DBCONNECT ...
1
vote
0answers
329 views

Add Vector Layer - Database OODBC does not work

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 ...
1
vote
1answer
364 views

Exporting geodatabase attribute tables to MySQL database using ArcMap?

I've already created a mysql db connection using ODBC and tested it. Now I want to export the attribute tables data from ArcMap to mysql which is on my localhost. On export there are many options like ...