Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [odbc]

A standardized interface to access databases.

2
votes
0answers
211 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
50 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 ...
0
votes
1answer
55 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(( ...
1
vote
2answers
294 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
94 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 ...
2
votes
0answers
277 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 ...
4
votes
0answers
2k 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
0answers
173 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 ...
1
vote
1answer
403 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
332 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 ...
4
votes
1answer
806 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
236 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
99 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
486 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
294 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
207 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
0answers
270 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 ...
2
votes
0answers
273 views

Oracle add layer and Oracle Connection icons are missing

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
967 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 ...
3
votes
1answer
4k 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 ...
0
votes
1answer
156 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 ...
3
votes
0answers
464 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 [...
7
votes
3answers
21k 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 ...
2
votes
0answers
246 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
1k 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 ...
5
votes
1answer
3k views

How to load Spatialite extension via SQLite3 ODBC Driver?

I am having trouble getting the Spatialite extension to load as part of the SQLite3 ODBC driver...[aka the joys of making software somewhat spatial when it tries so hard not to be]. What works [...
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 ...
5
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
1answer
493 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 ...
1
vote
1answer
495 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 ...
14
votes
5answers
22k views

Can QGIS read an ODBC connection?

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 ...