Questions tagged [connection]
for questions related to the connection of some GIS software to a database
74
questions
2
votes
1answer
59 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
31 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
26 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
35 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
303 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
652 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
117 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
70 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
463 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
408 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
200 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
731 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
473 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 ...
2
votes
0answers
83 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
365 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
33 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
346 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
163 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
399 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
128 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
187 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
88 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 ...
3
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
552 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
530 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
585 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
1answer
213 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
800 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
631 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
21k 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
749 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
209 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
332 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
122 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
628 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 ...
7
votes
1answer
556 views
Visualizing road Intersections & connections in ArcGIS
I am working with polylines (roads) in ArcGIS and I was wondering if there is a possibility to somehow show intersections as well as connecting parts of all the different road-segments.
Also, would ...
0
votes
1answer
97 views
Drawing lines showing connections between geocoordiante points
I have an ArcMap document with 100 locations plotted using their latitude and longitude values. I want to show connections between the 100 points in the graph. Essentially 100*100 = 10,000 lines. Is ...
1
vote
0answers
351 views
Error Opening WMS Maplayer: URLError: <urlopen error [Errno 10060]
I receive the error:
URLError: <urlopen error [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection ...
5
votes
1answer
3k views
How do I remove username / password from an ArcGIS mxd?
When you create an mxd and use layers from a database connection where you are using "Database authentication" and clicked "Save username and password" and share the mxd with others, why are others ...
-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. ...
