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 ...
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 ...
8
votes
3answers
780 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
7k 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 ...
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
546 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 ...
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
8k views

How to correctly set up Oracle 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 ...
5
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
315 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
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
1answer
980 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
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 ...
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 ...
4
votes
1answer
320 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", ...
4
votes
3answers
185 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 ...
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
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 ...
3
votes
1answer
156 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
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 ...
3
votes
1answer
118 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
482 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 [...
2
votes
2answers
392 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
600 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
236 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 ...
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
661 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
768 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
257 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 ...
2
votes
1answer
904 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
0answers
74 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
0answers
84 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
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 ...
1
vote
1answer
203 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 ...
1
vote
2answers
2k views

Error while creating spatial database connection

I'm using ArcGIS 10.0, and I've already created my database using "ArcSDE for PostgreSQL Post installation" .. My database is successfully created in PostgreSQL and now that I'm trying to create a ...
1
vote
1answer
348 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 ...
1
vote
1answer
83 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 ...
1
vote
1answer
182 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
1answer
504 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 ...
1
vote
2answers
712 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='...
1
vote
1answer
626 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 ...
1
vote
1answer
391 views

ArcGIS Server Only Accessible From Local Machine

I have an ArcGIS server set up. It works, but only when I access the server (or server manager) via a web browser from the server machine itself. I am unable to access the server (using the same url) ...
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 ...
1
vote
0answers
418 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 ...