Questions tagged [connection]
for questions related to the connection of some GIS software to a database
79
questions
1
vote
1answer
34 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).
...
1
vote
0answers
18 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 ...
1
vote
0answers
39 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.
...
1
vote
0answers
30 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....
2
votes
1answer
76 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 ...
0
votes
1answer
101 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 ...
0
votes
1answer
30 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 ...
0
votes
1answer
41 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 ...
2
votes
1answer
391 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 ...
1
vote
0answers
53 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 ...
2
votes
1answer
769 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 ...
0
votes
0answers
140 views
Connecting to several WFS using python/OWSLIB/OGR2OGR
I'm trying to download a lot of datasets from different WFS URLs using ogr2ogr (and to an extent, owslib) in Python. My problem arises when I try to connect to a second WFS.
In my test code, I have ...
0
votes
1answer
110 views
Accessing ArcSDE feature class with ArcPy?
I have a script that runs perfectly with shapefiles and GDB feature classes but I need to change it to run on feature classes stored on an SDE. However I cannot figure out how to reference them ...
1
vote
0answers
523 views
Can't connect with my PostgreSQL database with ArcGIS
I have created a database in PostgreSQL, spatially enabled it, and now I need to connect it with ArcGIS (we use only ArcGIS products here on my university), everything on localhost, I've tried ...
0
votes
1answer
513 views
What to do about QSqlDatabase: QOCI driver not loaded [closed]
QGIS - 3.0.1
I am trying to connect to the Oracle database. I am not an expert in QGIS, pyqgis at all. I took help of following code to connect to Oracle database. Connecting directly to an Oracle ...
0
votes
1answer
211 views
What is the max amount of connections a GeoPackage can handle in GeoServer?
I'm currently working on a GeoServer deployment and for simplicity, I want to to transition to using GeoPackages rather than Shapefiles (longer column names, less work integrating the data, etc.).
As ...
2
votes
1answer
860 views
General Function Failure: failed to connect to database
I am trying to access the file geodatabase and I get a message of General Function Failure: failed to connect to database. I can access other file geodatasabses, the problem is only with this one. I ...
0
votes
1answer
550 views
Getting user password from ArcSDE using Workspace Properties - python
Looking at this page for getting Workspace Properties I am wondering if there is a simple way to get a Users password from an existing SDE connection on the users machine?
Using the code sample from ...
3
votes
0answers
96 views
Loading Postgres layer with Session parameter (SET) using Pyqgis
With postgreSQL 9.5 and +, there is a policy feature that handle row-level access which is great.
My special case is to use this feature to control access to a multi-user postgres DB.
Here is what i'...
3
votes
1answer
1k views
Database Connection error: Invalid database name
I just created a new database in my Postres called GlenMary and I can't get ArcMap to connect through my already established database connection in ArcMap. I am trying to add some new data to the ...
1
vote
1answer
424 views
Connecting ArcGIS Desktop to remote PostgreSQL database?
I have setup PostgreSQL 9.5 on my local machine. I am trying to create a database connection from a coworkers laptop on the office network (let's say the network IP is 192.168.1.X). My database server ...
0
votes
1answer
34 views
Geoserver H2 datastore trying to connect to old private IP and failing/timing-out
Restarted my ubuntu EC2 instance, which changed its' private IP
Tried to preview a geo-server image-mosaic layer which was using the H2 datastore
Kept on getting this exception -
org.h2.jdbc....
4
votes
1answer
404 views
PyQGIS - Adding layer from PostGis database
I want to add new layer from PostGIS database but this code isn't working... Can someone help me?
uri = QgsDataSourceURI()
uri.setConnection("IP address", "5432", "ruian", "user", "pass", ...
3
votes
1answer
177 views
How Can I View All Databases on a PostGIS server in QGIS
When I add a new PostGIS database connection to QGIS the dialog asks for the database name.
At times I want to add a database and can't remember the exact name or I want to add a database from a ...
2
votes
2answers
427 views
The average distance between the roads
I have two vector layers.
Roads Line layer
Roads Point layer
I want somehow to get the average value of the distance between each roads and get average value for my region. Each road has its own ...
1
vote
0answers
140 views
Get username info from active connection in Mapbasic [closed]
I'm trying to retrieve information on username from active connection (SQL Server Express) in MapInfo 11.5 32bit. First I tried using Server_ConnectInfo( ConnectionNo, SRV_CONNECT_INFO_SQL_USER_ID ) ...
1
vote
1answer
86 views
Digimap OpenStream timeout
I am having trouble with an WMS layer that calls the Ordnance Survey/Digimap OpenStream data, but however I call the layer it times out without ever displaying a map.
I have registered with Digimap ...
10
votes
2answers
2k views
Connecting QGIS to a Remote PostgreSQL database using an SSH key?
I have created a username,password & ssh key with root privileges on a remote server (Vagrant) and I am attempting to connect via the usual methods but my password authentication fails. I can ...
1
vote
1answer
208 views
Connect to remote database with arcpy
I'm trying to access a database located on a remote server.
I used ArcMap "Create Database Connection" tool on my computer to create a SDE file and I want to use a script to add some data to a table ...
1
vote
0answers
38 views
Auto-fill attribution of similar feature classes via connectivity rules (Geometric Network)
I am working with water utility data. I am trying to figure a way to make feature types connected to the Mains (primary distribution water pipes) automatically fill certain attributes when they are ...
2
votes
0answers
98 views
MS SQL Layer - Losing LineStrings (Polyline) from SQL Server to QGIS
I have a table called [gfts].[Shapes] which contains a primary key shape_id and a geography data type GEOM. When I query the table in SQL Server I get the following Spatial Results:
However, when I ...
5
votes
2answers
1k views
MS SQL Layer - Invalid Layer Error when Attempting to Load a Table
I have a table called [stg].[Stops] in SQL Server that I would like to load in QGIS for data analysis. This is the first time I use the MSSQL Server connection option in QGIS. Unfortunately, even ...
0
votes
1answer
596 views
Using an ArcSDE Connection through Python
I would like to run a script on a ArcSDE feature class. The script runs perfectly when I hard code a shapefile, but is unable to connect to an ArcSDE database. The purpose of the script is to assign ...
1
vote
1answer
573 views
Accessing Microsoft Azure File Storage from ArcMap?
I need to store some raster files on Microsoft Azure account. They are rather large with each file being around 15MB. It seems the best place on Azure is in File Storage as blobs (unless there is a ...
0
votes
1answer
648 views
Why can't I connect to my PostGIS database? [closed]
It's the second time that I install PostgreSQL with the PostGIS extension and it runs as long as I don't restart the PC. After I have restarted the PC QGIS and PgAdmin4 can't connect to the database. ...
1
vote
0answers
52 views
Why are only some tables shown in QGIS when I connect to database? [closed]
For a project I started to work with pgAdmin and QGIS, so I'm quite new in these things and I have a problem with the connection of the database to the QGIS.
I can connect myself to the database and ...
1
vote
2answers
299 views
Connecting QGIS to Esri Enterprise Geodatabase of type Oracle Spatial
I have an Esri Enterprise Geodatabase (ArcSDE 10.2.2; Oracle 10G).
I am trying to connect it with QGIS 2.16.
So I clicked "Add vector layer" button with "Database"
Type : Oracle Spatial (I've tried ...
1
vote
1answer
236 views
How can I connect a Microsoft Access Database and a FGDB, such that information put into the former is automatically transferred to the latter?
I am working on a project for the National Park Service. The goal of the project is to connect a Microsoft Access Database to a File Geodatabase, where any information put into the .accdb tables will ...
8
votes
3answers
852 views
Accessing WMS layers of UK coal mines?
I am trying to access the WMS layers from the UK Coal Authority website. I can connect to their servers and see the raster files available but when I download them, I can only view the rasters from ...
0
votes
2answers
671 views
Use multiple connections/databases in a query layer?
I have access to two databases, each with a separate connection. The first connection is an .sde connection to a SDE 10.3.1 Oracle database, and the second connection is a .odc OLE DB connection to a ...
0
votes
2answers
24k views
When buton clicked, open new window - pyqgis
I'm making a plugin which has two windows. What I want to know is how to refer pushButton in one window to method which opens new window.
I have dialog *.ui files for both windows and their *.py. ...
1
vote
2answers
811 views
No ArcGIS Server License found
I have attached geodatabase "Riverside" to databases list in MS SQL SERVER 2012 Enterprise edition :
After that I created two logins using :
USE [master]
GO
CREATE LOGIN [sde] WITH PASSWORD='...
0
votes
0answers
221 views
Connect two points with fixed longitudinal slope over DEM - QGIS
Is it possible to connect two points with fixed longitudinal slope over DEM terrain or connect points with maximum longitudinal slope? Make road line between two point, for example 7% or make it with ...
4
votes
3answers
2k views
Unable to establish connection to www.arcgis.com from ArcGIS Pro?
After installing ArcGIS Pro 1.1 on two machines, I am now unable to run the program.
The error received is:
Unable to establish a connection to www.arcgis.com.
After installing the first ...
6
votes
5answers
9k views
Unable to connect ArcGIS Server - Error: Proxy server got bad address from remote server
This is my problem. anybody know how to solve this?
We were unable to connect to ...
Error: Proxy server got bad address from remote server (verify ther server is running).
4
votes
1answer
339 views
PostGIS with VPN
Is it possible to use the postgis database with a VPN tunnel? The database tells me there is no connection possible.
I'm using VPN Tracker 365.
2
votes
0answers
1k views
Creating new PostGIS connection in QGIS?
I am trying to create a new PostGIS connection and I am doing as it follows:
The password I inserted is postgres, I don't know what should be inserted there. And when testing the connection, I get ...
3
votes
1answer
129 views
mass update connetion properties in msd
I would like to update the connection property in all .msd in a folder, that already have a certain connection property.
The manual process is to
right click on the .msd,
select "select all",
...
1
vote
1answer
631 views
Cannot Publish from ArcMap to ArcGIS Online?
I am attempting to publish an MXD as a map service to ArcGIS Online from ArcMap Desktop 10.3.
I have a home licence and have a Organization account on ArcGIS Online with 60 credits left. I have ...
3
votes
1answer
4k views
Connecting to Oracle database with ArcGIS for Desktop?
I installed ArcGIS 10.2.2 ,oracle 11g R2 personal edition and it's client.I try to connect to the database using database connection in ArcMap but the error
Failed to connect to the specified ...
