Questions tagged [odbc]

A standardized interface to access databases.

Filter by
Sorted by
Tagged with
16
votes
5answers
24k 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 ...
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 ...
9
votes
3answers
28k 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
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 ...
4
votes
1answer
989 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 ...