Questions tagged [connection]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
106 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 ...
0
votes
1answer
173 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
0answers
34 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 ...
1
vote
1answer
21 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 ...
3
votes
0answers
35 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 ...
1
vote
0answers
86 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
719 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 ...
0
votes
0answers
13 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 ...
1
vote
1answer
96 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
19 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
46 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
47 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....
1
vote
2answers
331 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 ...
5
votes
1answer
8k views

Setting up ArcSDE for Oracle Spatial connection parameters?

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the ...
0
votes
1answer
174 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 ...
6
votes
5answers
10k 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).
0
votes
1answer
46 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 ...
0
votes
1answer
39 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 ...
4
votes
3answers
3k 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 ...
2
votes
1answer
485 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 ...
4
votes
1answer
4k views

Use arcpy to connect to database without connection file

It seems like arcpy can only work with connection files. This creates one of two problems: Deployment requires manual creation of connection files. We have to write a bunch of code to recreate the ...
4
votes
2answers
3k views

Can ArcPy test for availability of SDE Connection before trying to use it?

In a Python script that I use to publish ArcGIS 10.0 Geoprocessing Services I have some code: arcpy.AddMessage("If process hangs here, check for ArcSDE connections issue by trying to open " + mapFile ...
12
votes
5answers
10k views

Dealing with ArcSDE connection limit exceeded?

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
5
votes
2answers
2k 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 ...
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
913 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
1answer
210 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
610 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
637 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 ...
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 ...
0
votes
1answer
230 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
1k 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
634 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 ...
0
votes
2answers
27k 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. ...
3
votes
0answers
132 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'...
8
votes
2answers
8k views

ArcGIS Online won't connect from ArcMap or Catalog

I've had 10.3 installed now for about a month. At the beginning everything seemed to work fine but somewhere along the way my connection to ArcGIS Online went away and hasn't been back. The options ...
3
votes
1answer
2k 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
467 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
37 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....
-1
votes
2answers
1k views

WMS layer connected to SQL database

It is possible to connect a WMS layer to a SQL database or other type of database? Example: I have created an application with GeoServer and OpenLayers. Now I can see the data from attribute table. ...
3
votes
1answer
187 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 ...
5
votes
1answer
522 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", ...
0
votes
2answers
703 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 ...
2
votes
2answers
463 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
145 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 ) ...
2
votes
1answer
239 views

Joining\relating\connecting 4 feature class together?

How can I join\relate\connect communities\UMP\BuiltUP\Admin boundaries? Could you please consider the following scenario: I have a feature class with a name “community “ which I consider it the ...
1
vote
1answer
87 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 ...
0
votes
1answer
5k views

How to connect QGIS with Access database [duplicate]

I am trying to connect Access database with QGIS like I would in ArcView but I get this problem. Data source name not found and no default driver specified QODBC3: Unable to connect Hoping someone ...
4
votes
3answers
189 views

Connection between OpenLayers and GeoServer is faulty

I have connected my GeoServer to my OpenLayers website and it seems like something is wrong about the connection. I added a WMS layer in JavaScript like this: But when I load the page the result is ...
1
vote
1answer
238 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 ...