Questions tagged [odbc]
A standardized interface to access databases.
41
questions
0
votes
0
answers
13
views
Spatial MSSQL ODBC error when using QGIS in 'Add Ring' operation
I have a MSSQL spatial database using QGIS 3.28.4 as a front end.
I want to add a ring to a polygon and I get this message:
Could not commit changes to layer HHP Developments
Errors: ERROR: 1 ...
0
votes
0
answers
114
views
Connecting to MSSQL Server - QGIS 3.28 & Ubuntu 23.04
I've been using QGIS + Ubuntu for some time now, great combination.
Last week I've updated from Ubuntu 22.04 to Ubuntu 22.10 and subsequently to Ubuntu 23.04. During this upgrade the system has ...
1
vote
0
answers
63
views
How to configure PGeo driver with unixODBC and MDB Tools
I am trying to properly configure the PGeo driver with unixODBC and MDB Tools for my Ubuntu system in order to convert a .mdb file to a GeoPackage. The .mdb file is found here https://nosimagery.noaa....
- 97
1
vote
0
answers
50
views
How to provide a point geometry to a table that has its origin in an ODBC connection?
The problem approach is as following:
A QGIS project has a table that comes from an ODBC connection referring to an MSAccess database.
To this table, a Join is configured with another layer through ...
- 789
0
votes
0
answers
42
views
QGIS MS SQL Connection with MultiSubnetFailover
I'm trying to connect QGIS to a MS SQL database using a cname pointing to an availability group. I've got as far as setting the Provider/DSN to
driver={ODBC Driver 17 for SQL Server};...
- 1
0
votes
0
answers
112
views
QGIS connect via ODBC using SSO
I am trying to connect QGIS to Snowflake using ODBC. This seems possible, e.g. 396982 (and I don't have enough reputation to comment on that post, hence the new question), but perhaps not when using ...
- 1
0
votes
0
answers
173
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 ...
2
votes
1
answer
180
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 ...
- 667
1
vote
1
answer
477
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,571
2
votes
1
answer
205
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 ...
- 403
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 ...
- 41
1
vote
0
answers
212
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 ...
- 403
0
votes
1
answer
120
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(( ...
- 612
3
votes
2
answers
994
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), ...
- 612
1
vote
0
answers
117
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 ...
- 1,051
2
votes
0
answers
498
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 ...
- 863
5
votes
0
answers
5k
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 ...
- 768
1
vote
1
answer
726
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 ...
- 19
1
vote
1
answer
655
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 ...
- 429
2
votes
2
answers
513
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 ...
- 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 ...
- 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 ...
- 179
1
vote
0
answers
115
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 ...
- 11
3
votes
1
answer
744
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,161
1
vote
0
answers
675
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 ...
- 411
1
vote
1
answer
249
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 ...
- 23
1
vote
0
answers
392
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 ...
- 139
1
vote
0
answers
410
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 ...
- 139
1
vote
1
answer
2k
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 ...
- 437
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 ...
0
votes
1
answer
185
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 ...
- 28k
4
votes
1
answer
752
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
[...
10
votes
3
answers
34k
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 ...
- 303
2
votes
0
answers
306
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 ...
- 397
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 ...
- 241
5
votes
1
answer
4k
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 ...
- 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 ...
- 329
5
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 ...
- 59
2
votes
1
answer
577
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 ...
- 403
1
vote
1
answer
538
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 ...
- 11
16
votes
5
answers
27k
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 ...
- 22.9k