Questions tagged [connection]

for questions related to the connection of some GIS software to a database

Filter by
Sorted by
Tagged with
2 votes
1 answer
112 views

ArcGIS Pro (Catalog Pane) will not make folder connection to external hard drive

I have an external hard drive that is storing spatial data and ESRI 10x projects. I would like to add this letter drive as a folder connect but ArcGIS Pro v2.9 seems unwilling or unable to do this. I ...
user avatar
  • 7,137
1 vote
0 answers
432 views

Authentication method 10 not supported (QGIS)

I have a problem when I am trying to connect the database that I have in pgadmin with my QGIS project. I am trying to create a New PostGIS connection like in the following picture: But I am always ...
user avatar
  • 103
1 vote
2 answers
47 views

Create one PostGIS connection in QGIS with multiple databases from one host?

I have a number of spatial databases each containing multiple schemas on one server, I want to use QGIS to examine layers, Is it possible to create one PostGIS connection in QGIS and add all databases ...
user avatar
1 vote
0 answers
48 views

PostGIS table visualization in QGIS without download permission

I'm used to work with PostGIS databases and accessing them from QGIS. I know how to create schemas or grant permissions, but I was wondering if it is feasible to set a user profile that could "...
user avatar
  • 2,273
1 vote
0 answers
101 views

Failure to connect QGIS to FIRMS WMS - Failed to download capabilities

I'm following this tutorial from (NASA) FIRMS that shows how to ingest FIRMS fire data into QGIS. I've followed the first steps but I get the following error: Failed to download capabilities server ...
user avatar
0 votes
0 answers
46 views

Unable to connect ArcPy with ArcMap to MS SQL Server accessed via ArcSDE

Why can I not connect my ArcPy to our enterprise database hosted on a Microsoft SQL Server? I'm running Python 2.7, ArcMap 10.6.1, MSSQL Server 12.0 (2014) I've created an SDE connection file in ...
user avatar
0 votes
1 answer
51 views

Remove gpkg delated QGIS

I accidentally deleted a gpkg file from QGIS browser… I thought it was to delete the connection and the file was deleted… does anyone know any way to recover it? Does QGIS save deleted files somewhere?...
user avatar
1 vote
0 answers
27 views

Unable to logon when connecting to Oracle database with QGIS 3.20

After I updated QGIS to 3.20 my old oracle connections doesn't work anymore. I get the message "Unable to logon". Under QGIS 3.16 everything works fine. This is what I have read in the ...
user avatar
  • 11
0 votes
0 answers
60 views

PostGIS database connection

I am basic QGIS user and I have database created and data loaded in it. However, when I try to connect to the database, I am getting the following error. Connection failed - consult message log for ...
user avatar
1 vote
1 answer
160 views

Unable to logon when connecting to Oracle database with QGIS

I started using QGIS recently and wanted to connect it with our database set on a standalone server. the database installed is (screenshot below). Windows ODBC and lister are well configured, the ...
user avatar
  • 63
1 vote
0 answers
56 views

Connect to Oracle SQL DB using JDBC connection

My IP address changes frequently and hence I use ssh tunnel via bastion host to connect to Oracle SQL DB. I used JDBC to connect to the Oracle SQL and it works successfully. However, I want to connect ...
user avatar
0 votes
2 answers
153 views

QGIS - How do I embed my layer's database connections into the project (rather than DB Manager)?

Situation: I have projects, lots of projects. They call dozens of layers from the corporate PostGIS. This is largely public data, and the data is referenced via a readonly user account. As it happens, ...
user avatar
  • 9
1 vote
0 answers
47 views

How to define PG connection to a distant server for grass gis v.in.ogr?

OS: debian stretch ; GRASS version: 7.2. I'm writing a standalone python script using grass_session. with Session(gisdb="/tmp", location="mylocation", ...
user avatar
0 votes
1 answer
193 views

QGIS: RiverGIS: Couldn't connect to river database

Trying to connect to the PostGIS DB for RiverGIS fails with Couldn't connect to river database: var@localhost Please, check you database connection settings! This happens despite the DB being ...
user avatar
0 votes
1 answer
71 views

MapServer FastCGI connection pool configuration

I posted this question in the MapServer User mailing list but hoping I can get more eyeballs on it here. I'll update both threads if I make any progress. The MapServer LAYER documentation says the ...
user avatar
  • 3,576
0 votes
1 answer
64 views

Access MDB connection file result does not have an object ID in ArcGIS 10.8

I have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to ...
user avatar
2 votes
0 answers
39 views

Connection pooling in OGR PostgreSQL driver

OGR (GDAL) provides a vector driver for "PostgreSQL" and data in the DB can be accessed with something like the following: driver = ogr.GetDriverByName("PostgreSQL") datasource = ...
user avatar
  • 3,576
1 vote
0 answers
404 views

Connecting nodes to existing network lines using QGIS

I have road network (polyline layer) and point layer: I am trying to connect nodes to the existing network lines. I able to connect nodes with lines using connect nodes to lines in Networks in QGIS ...
user avatar
  • 825
5 votes
2 answers
329 views

Connecting points with line using virtual layer in QGIS

I have 10 points in QGIS layer as shown in Image 1. I am trying to connect points with lines in required sequence as shown in Image 2. However, when I tried to connect all points with virtual layer, ...
user avatar
  • 825
4 votes
2 answers
251 views

Connecting points with line in a specific sequence

I have 6 points in one layer as shown in the first image. I am trying to: connect points with lines in a required sequence. Save data of line connections (From_point and To_point) in the seperate ...
user avatar
  • 825
8 votes
1 answer
152 views

Connecting points with lines and saving starting and ending points in new layer

I have 3 points in one layer as shown in the first image. I am trying to connect a building points with junction point by 2 lines. For demo, I have manually drawn a lines in image 2. Here, I am trying ...
user avatar
  • 825
1 vote
0 answers
30 views

Connect to single table within a MSSQL database or terminate connection to database once layer added to QGIS project?

I'm connecting to MSSQL server '123' that contains 100s of databases and I am connecting to just database 'ABC'. 'ABC' contains roughly ~700 tables. Once I add the 'xyzTable' as a layer to my QGIS ...
user avatar
  • 11
3 votes
1 answer
54 views

Saving Starting / Ending points of connecting line in attribute table

I have 3 layers ( 1 line and 2 points) as shown in image. The layer id,s are mixture of integers and text such as cable4389175, node1 , service_point5316. I connect the two point layers (node and ...
user avatar
  • 825
1 vote
0 answers
126 views

Create PostgreSQL ODBC Excel table

I want to allow a non-GIS user edit a CSV file which is hosted on QGIS Cloud on a PostGIS database. My method is to load the table from the QGIS Cloud database into Excel via ODBC. Here are my steps ...
user avatar
  • 2,089
2 votes
1 answer
295 views

Opening gdb in QGIS

I have been given an ESRI gdb file by a vendor. I can connect it in the usual fashion in QGIS but it only shows a couple of the layers that are contained and they show no entities in them. Has anyone ...
user avatar
4 votes
2 answers
607 views

Connection to ArcGIS Server via QGIS fails

I am trying to load this map that comes from an ESRI Server in QGIS. I tried two different ways: DATA SOURCE MANAGER / PROTOCOL HTTPS or FILE and then adding the URL. When I do this it fails and ...
user avatar
3 votes
0 answers
138 views

Connecting to Azure PostgreSQL using domain user account through QGIS

We are using QGIS over the top of an Azure PostgreSQL database. We have it working using SQL user / password combination but security policy dictates this should be a domain user authenticated ...
user avatar
0 votes
1 answer
332 views

Extending lines using ArcGIS Pro

I am using ArcGIS Pro 2.6.1. I have massive map of roads in multiple road files. I need to extend lines to their intersect point. Intersect tool does not seem to work to my satisfaction. Any other ...
user avatar
0 votes
0 answers
23 views

Connecting ArcMap to secure folder

I am accessing data from a National Data Services secure server. Within the server, all my project data is in one folder, and applications like ArcMap are in a separate folder. In ArcMap, "add ...
user avatar
  • 23
2 votes
1 answer
146 views

Access SpatiaLite connections with PyQGIS QgsProviderMetadata (QGIS 3.10.7 LTR)

I would like to list spatialite connections and access a specific connectionwith PyQGIS. For postgres provider it's pretty straightforward: >>> QgsProviderRegistry.instance().providerMetadata(...
user avatar
1 vote
2 answers
122 views

Creating linear connections among points

I would like to create in an automatic way a linear feature representing the connections among all points using ArcMap or Python. That is I would like that each point is connected to the others one ...
user avatar
2 votes
1 answer
58 views

Use QgsAbstractProviderConnection in PyQGIS (3.14)

I created a PostGIS connection named 'test_conn' and try to access it via from qgis.core import QgsAbstractProviderConnection con = QgsAbstractProviderConnection('test_conn') as described in ...
user avatar
3 votes
2 answers
84 views

Measuring distance between certain relations in QGIS

I need to measure the direct distance between busstops in meters, not taking roads/networks into account. I have the WGS 84 Coordinates + globalIDs for 28.000 pairs. I already imported the Busstops ...
user avatar
0 votes
1 answer
445 views

Connection failure to WMS/WMTS or WFS

Why can't I connect to any of the Web Map Services (WMS/WMTS/WFS) in QGIS? I don't think its a problem with the servers I'm using, but more about QGIS not being connected to the internet maybe. The ...
user avatar
  • 9
1 vote
1 answer
209 views

Loading layers into QGIS - Heavy work in the background - Too many clients already

I am 3rd year geoinformatics bachelor student currently developing a QGIS plugin that will allow me to import a larger number of layers from the data storage (Postgres) into the software. For the ...
user avatar
0 votes
0 answers
49 views

Connect a Python script to a database

I need to run a script tool from ArcCatalog. It needs to access a feature class in an ArcSDE database so I can link the script to the layer as a source layer. I have connected the folder the script's ...
user avatar
  • 103
1 vote
1 answer
318 views

Error Loading .xml file to WFS in QGIS

In this link xml-link, there is a .xml file from a website (WFS) which contains vector data regarding water bodies for a specific area. I saved it as .xml by just right-clicking -> "Save as" and I ...
user avatar
3 votes
0 answers
82 views

Reduce QGIS project needed PostgreSQL connections

I have a QGIS project, based on data from a PostgreSQL database. The project should be used by a lot people from my company. In a performance test I noticed, that every person, who opens the project ...
user avatar
0 votes
0 answers
25 views

Database Population in wrong Authentication Type

I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
user avatar
1 vote
1 answer
868 views

GeoServer Connection Pool uses most available connections and not releasing them

We are using GeoServer with a geoserver cache for some layers. Most of our layer updates frequently and therefore we do not want to setup a cache for them (they do have in memory cache though). ...
user avatar
1 vote
0 answers
26 views

Distance from points to points in the same polygon

I have 2 point layers and 1 polygon layer. I want to find distance nearest between this 2 point layer, but they must be in the same polygons. I used distance nearest hub, NNJoin, MMQgis but they just ...
user avatar
  • 111
1 vote
0 answers
63 views

Carto trying to set syncing with a PostGIS database connection

I'm trying to set up a syncing connection between Carto and a PostGIS Table. However, I'm not seeing updates in Carto, and the table does not show up in my list of syncs when I make a Get request. ...
user avatar
1 vote
0 answers
136 views

Data upload error in QGIS cloud

I want to publish my .shp file but I am facing one uxpected error. could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "db.qgiscloud.com" (136.243....
user avatar
  • 385
1 vote
0 answers
156 views

Connecting to PostgreSQL database from another machine using QGIS?

I have a database with name "Test" in PostgreSQL 11 in my machine, I can connect to this database from my machine using QGIS with host localhost, but when I tried to connect it from a different ...
user avatar
  • 19
0 votes
1 answer
850 views

Create different Server Database Connection file for ArcGIS Server

I would like to register database with ArcGIS Server. I know it is done through ArcGIS Server Manager under Site / Data Stores / Register: Database. I am also aware there can be different connection ...
user avatar
  • 9,216
0 votes
1 answer
68 views

Connection QGIS 3.4.5 / PostgreSQL 9.3 with role group [closed]

I created 2 connection roles with PostgreSQL. Then, to manage more easily the privileges, I created a group role includind these roles (inherit). I created a trigger which track data changes. I used ...
user avatar
  • 95
0 votes
1 answer
51 views

Arcpy SDE Connection Getting Invalid Path? [closed]

I literally copied and pasted the file path (r'C:\Users\myName\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\mydatabase.sde'), but after I run my script, I always get the error saying error 267, the ...
user avatar
3 votes
1 answer
896 views

From QGIS 3.4.5 and 3.6 asks password repeadly to connect to PostgreSQL 10 [closed]

Action: At first time when opening project on QGIS 3.4.5 and 3.6 versions needs credentials to connect to PostgreSQL DB. Problem: But after that when connection is success with correct credentials ...
user avatar
1 vote
0 answers
57 views

ArcPy not seeing ArcSDE datasets from IDLE or PyScripter? [duplicate]

I tested the code below from ArcCatalog 10.5's python console and IDLE+PyScripter. While in ArcCatalog everything works correctly(code is supposed to list available datasets and feature layers), in ...
user avatar
  • 247
3 votes
1 answer
2k views

Connect points in two layers using lines in QGIS 3.x

I'm using QGIS 3.2.1 and I have two Layers containing point objects, Is there any plugin for this version of qgis that I can use to select two points and then connect them using a line and save the ...
user avatar