Questions tagged [odbc]

A standardized interface to access databases.

Filter by
Sorted by
Tagged with
0 votes
0 answers
97 views

Does ArcGIS Online support ODBC?

I'm trying to figure out if ArcGIS Online (as our database host) supports ODBC connections. My workflow is such that the data I maintain in ArcGIS Online needs to flow into Adobe Indesign for table ...
user avatar
1 vote
1 answer
62 views

QGIS ODBC connection to mssqlserver returns only filtered data

I am connecting to an MSSQL database table which does not have a geometry type field, but has coordinates in separate columns. The ODBC connection works, but when I bring the table in to QGIS, it is ...
user avatar
  • 647
1 vote
1 answer
345 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 ...
user avatar
  • 1,531
2 votes
1 answer
180 views

QGIS error when accessing data from Database via eVis and ODBC

Using the "eVis Database Connection" I can access an ODBC data source which contains records with Lat and Long fields. The connection is made OK, and the "Database File Selection" window opens where I ...
user avatar
  • 373
3 votes
1 answer
2k views

Error QODBC driver not loaded when trying to connect to an MSSQL database from QGIS 3.4.3 (Ubuntu)

I have installed QGIS Desktop (latest one: 3.4.3 Madeira) along with the unixODBC-dev for SQL Server 2017 (following instructions here). I used sqlcmd from msql-tools and successfully connected to the ...
user avatar
  • 41
1 vote
0 answers
178 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 ...
user avatar
  • 373
0 votes
1 answer
111 views

Insert a Valid GPB from WKT

My software produce WKT and I'm trying to import it into an ODBC connected Geopackage: SELECT load_extension('mod_spatialite'); SELECT IsValidGPB( AsGPB ( ST_GeomFromText('POLYGON(( ...
user avatar
  • 584
2 votes
2 answers
857 views

Add spatial functions to a geopackage template

I would like to dump data from my survey software to a geopackage file through an ODBC connection but I need a minimum of spatial functions to execute my requests: ST_IsEmpty(geom), ST_MinX(geom), ...
user avatar
  • 584
1 vote
0 answers
115 views

How to edit a layer from a personal geodatabase in QGIS [duplicate]

I want to open and edit layers from a personal geodatabase in QGIS. I have read this post and I follow the ODBC way to open a personal geodatabase in QGIS with success. However, I cant edit layers in ...
user avatar
  • 1,023
2 votes
0 answers
454 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 ...
user avatar
  • 863
6 votes
0 answers
4k views

Connecting QGIS to ODBC database (MS Access *.accdb) [closed]

Has anybody managed to successfully connect to open a MS Access *.accdb database from QGIS using ODBC? All the Q&A, tutorials, guides and videos I've found work with *.mdb files and ESRI ...
user avatar
  • 681
1 vote
1 answer
626 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 ...
user avatar
1 vote
1 answer
636 views

Connecting to SQL Server with ArcGIS Desktop?

I am trying to connect to views in a SQL Server DB in Arcatalog / Arcmap. I am using the "Database Connections\Add Database Connection" method in catalog. I can connect fine but cannot see / preview ...
user avatar
2 votes
2 answers
489 views

ODBC connection Filemaker ArcGIS

I have a large database in Filemaker. To get this joined with a feature class in ArcGIS I have to make an ODBC connection. I do this in the 32-bit ODBC in windows because ArcGIS is 32-bit. In ...
user avatar
  • 21
4 votes
1 answer
1k views

How to connect QGIS (linux) to SQL Server

I tried every thing I can think of, official Microsoft ODBC Driver for SQL Server, FreeTDS, etc.... I'm able to connect to the SQL Server DB from the terminal (isql,sqsh) I can use PostgreSQL's ...
user avatar
  • 101
4 votes
0 answers
259 views

Unable to establish a persistent ODBC connection to an access mdb database [duplicate]

I’m an MS Access diehard and I’m running a 64bit version of Win 10 on my PC. I’ve installed both the 32bit (2.14.7) and 64bit (2.16.3) versions of QGIS on it, and MS Office 2016. I would like to ...
user avatar
  • 179
1 vote
0 answers
113 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 ...
user avatar
  • 11
3 votes
1 answer
700 views

ArcPy: Connect to MySQL database

My project aims at updating automatically point feature classes in a ESRI local geodatabase using MySQL tables with X,Y coordinates. The updates should be launched with the Windows task-scheduler. I ...
user avatar
  • 1,151
1 vote
0 answers
559 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 ...
user avatar
1 vote
1 answer
231 views

Problem using ogr2ogr to convert postGIS table to personal geodatabase

I need to convert a PostGIS table to a personal geodatabase using ogr2ogr. I can convert tables to a shapefile without a problem but whenever I try to convert it to .mdb using the ODBC driver, I get ...
user avatar
  • 23
1 vote
0 answers
368 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 ...
user avatar
  • 139
1 vote
0 answers
396 views

Oracle add layer and Oracle Connection icons are missing [closed]

I have recently installed QGIS 2.8 and Oracle 11.2 Client on Linux Red Hat 7. Everything was fine, I am able to access Oracle database, as well as running QGIS. Unlike QGIS 2.8 from WIndows, Linux ...
user avatar
  • 139
1 vote
1 answer
1k views

Directly querying a raster

I've done tons of work within ArcGIS to analyze and process rasters. I'm pretty well knowledgeable on that subject. A question has come in from my coworker who is attempting to populate elevation data ...
user avatar
  • 427
3 votes
1 answer
6k views

What are the limitations of using MySQL with ArcGIS?

I recently connected a MySQL database to ArcGIS by adding an OLE DB Connection. I can view the tables just fine; however, my XY data will not show up on the map directly from the MySQL table, I have ...
user avatar
0 votes
1 answer
182 views

Secure ArcGIS connections to Access .accdb?

With ArcGIS is it possible to secure connections to an Access 2007+ format database tables? At Connecting to a 2007 Microsoft Access database (.accdb) in ArcGIS it says "if the database has a ...
user avatar
  • 27.5k
4 votes
1 answer
670 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 [...
user avatar
10 votes
3 answers
32k views

MSSQL Connection settings for QGIS on Windows

OK first lets get the blond elements out of the way- I'm not asking for how I connect to my actual database. What I'm asking for is an example or screen shot of the entries required when setting up a ...
user avatar
2 votes
0 answers
300 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 ...
user avatar
  • 367
2 votes
1 answer
2k views

Microsoft Access mdb "is not a valid or recognized data source" in QGIS

The answer to RyanDalton's question "Can QGIS read an ODBC connection?" explains how to establish a link in QGIS with an MS-Access table. Following his steps, I can establish an ODBC link (I ...
user avatar
  • 241
5 votes
1 answer
3k views

Loading Spatialite extension via SQLite3 ODBC Driver?

I am having trouble getting the Spatialite extension to load as part of the SQLite3 ODBC driver. What works [loading extension into SQLite Driver]: I have software that is connected using the ...
user avatar
  • 201
3 votes
1 answer
1k views

Access Shapefiles from PostgreSQL/Postgis in R

I successfully setup a connection to my PostgreSQL/PostGIS database on Ubuntu Server from my Laptop (Ubuntu 12.04). Therefore I installed RODBC in R to setup a connection and I made a correct entry ...
user avatar
  • 319
6 votes
2 answers
2k views

QGIS 64-bit ODBC set up link to 32-bit Access on win7

I am trying to set up a an ODBC link to Access 2007 32-bit but not having any success. My system is a win7 pro 64-bit and I have QGIS 64-bit installed. Here are the steps I have already tried. Set ...
user avatar
  • 61
2 votes
1 answer
552 views

QGIS 1.8 Vector layer from ODBC connection [duplicate]

I have successfully set up an ODBC link from a FileMaker DB to QGIS, and using Layer/Add Vector Layer I can get a layer with a fully populated attribute table listed in the Layers Panel. I now want ...
user avatar
  • 373
1 vote
1 answer
531 views

ODBC connection to ArcSDE table shows old version in ArcMap?

I use an ODBC connection to an ArcSDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL ArcSDE server and the connection info matches ...
user avatar
16 votes
5 answers
26k views

Reading ODBC connection using QGIS? [closed]

I have a co-worker who manages a large MS Access database that contains X & Y fields for various locations he tracks. We have previously exported the data to CSV and used the QGIS Delimited Text ...
user avatar
  • 22.4k