Questions tagged [connection]

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

Filter by
Sorted by
Tagged with
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 ...
11
votes
2answers
3k 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 ...
8
votes
3answers
985 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 ...
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 ...
8
votes
1answer
103 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 ...
7
votes
1answer
10k views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
7
votes
1answer
651 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 ...
6
votes
1answer
3k views

How to Keep Database and Server Connections active

It seems like everyday I go to publish a service or connect to my SDE I get messages that I can't connect. It is particularly annoying when trying to publish a service to ArcServer. The connections ...
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).
6
votes
1answer
739 views

PyQGIS - Adding layer from PostGis database [duplicate]

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", ...
5
votes
1answer
5k 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 ...
5
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 ...
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 ...
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 ...
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 ...
4
votes
1answer
421 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.
4
votes
2answers
99 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 ...
4
votes
2answers
85 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 ...
4
votes
1answer
1k views

Editing 2007 MS Access *.accdb using OLE DB connection?

Can you edit a 2007 MS Access .accdb file format using the OLE DB connection? I have made the connection using the following: Connecting to a 2007 Microsoft Access database (.accdb) in ArcGIS I can ...
4
votes
2answers
1k views

Updating ArcMap links to ArcSDE Geodatabase feature classes?

I've seen questions about attemting to repair a .mxd file with broken links. What I would like to do is get ahead of this issue and "fix" it before it becomes a problem. I have my data in an ArcSDE ...
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 ...
4
votes
3answers
194 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 ...
4
votes
0answers
557 views

Connecting QGIS 2.x to Firebird Database via ODBC?

I tried to connect a Firebird Database in QGIS 2.2 and 2.4 via ODBC to a database and get following error message: Unable to initialize ODBC connection to DSN for SYSDBA/masterkey@Akdees [...
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 ...
3
votes
2answers
2k views

How to connect Microstation V8i to Postgresql?

I have been searching the web trying to find out if any one has connect Microstation to Postgresql, and to my surprise there has not been alot of chatter on ways to do this.. When looking at the ...
3
votes
1answer
3k views

QGIS 2.0 without MySQL connector

On a mac (Mountain Lion), after a major upgrade to GDAL (1.10) and related frameworks from KyngChaos page, QGIS 2.0 doesn't show any MySQL connector: Add Vector > Database > ... The driver doesn't ...
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 ...
3
votes
1answer
646 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 ...
3
votes
1answer
35 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 ...
3
votes
1answer
194 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 ...
3
votes
1answer
147 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", ...
3
votes
0answers
57 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 ...
3
votes
0answers
38 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 ...
3
votes
0answers
191 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'...
2
votes
2answers
533 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 ...
2
votes
1answer
66 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(...
2
votes
1answer
28 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
241 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 main ...
2
votes
1answer
3k views

How to Add Oracle Spatial Tables to QGIS?

I've been playing qith QGIS Chugiak (2.4.0). I've been attempting to try to add Oracle Spatial tables (point, line and polygon feature classes) to desktop. The same tables I use in ArcGIS. I've ...
2
votes
2answers
2k views

Upstream to a river and tributary of a river - What is the underlying difference

What is the difference between a stream/ river upstream to a river A and a tributary of River A? I know that all tributaries are upstream to its river (A) and feeds into river A, but can there be a ...
2
votes
1answer
2k views

How to connect to the ArcGIS Server through a firewall?

I know there were a lot of similar questions, but still can't find a correct description about that. What should be inbound and outbound rules on the server side? Which ports should I use? Will that ...
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 ...
2
votes
1answer
771 views

connection to postgresql; From ArcGIS for Desktop 10.1 OR ArcGIS for Server 10.1

As it is mentioned in ArcGIS Resources "PostgreSQL client libraries are required on the ArcGIS client application from which you will connect to the database". My questions are: by ArcGIS client ...
2
votes
1answer
960 views

Relating Tables in OLE DB from ArcGIS for Desktop?

I have a large registry of about 260,000 records in microsoft access with data on land quarter sections. This data was to much for ArcGIS 10.2 to handle directly, so I created a Microsoft Jet 4.0 OLE ...
2
votes
2answers
56 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 ...
2
votes
0answers
107 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 ...
2
votes
0answers
2k 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 ...
1
vote
2answers
105 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 ...
1
vote
1answer
256 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 ...