Questions tagged [odbc]

A standardized interface to access databases.

Filter by
Sorted by
Tagged with
1
vote
1answer
32 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 ...
0
votes
0answers
25 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 ...
1
vote
1answer
152 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 ...
2
votes
1answer
145 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 ...
9
votes
3answers
29k 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
357 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 ...
1
vote
1answer
435 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 ...
5
votes
1answer
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 ...
16
votes
5answers
25k 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 ...
2
votes
2answers
645 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), ...
1
vote
0answers
143 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
109 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 ...
0
votes
1answer
94 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(( ...
2
votes
0answers
413 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 ...
6
votes
0answers
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 ...
1
vote
1answer
568 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 ...
2
votes
2answers
442 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 ...
1
vote
0answers
335 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 ...
4
votes
1answer
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 ...
4
votes
0answers
253 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 ...
1
vote
0answers
110 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 ...
3
votes
1answer
649 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 ...
1
vote
0answers
473 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
1answer
223 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 ...
1
vote
1answer
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 ...
0
votes
1answer
173 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 ...
1
vote
1answer
517 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 ...
3
votes
1answer
5k 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 ...
4
votes
0answers
569 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 [...
6
votes
2answers
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 ...
2
votes
0answers
285 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 ...
2
votes
1answer
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 ...
3
votes
1answer
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 ...
2
votes
1answer
529 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 ...