Questions tagged [connection]

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

Filter by
Sorted by
Tagged with
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).
-1
votes
0answers
12 views

MSSQL enterprise geodatabase in QGIS [on hold]

I want to connect enterprise geodatabase in SQL Server in QGIS, I tried but I couldn't find a solution. Is there any possibility to connect MSSQL enterprise geodatabase in QGIS?
0
votes
1answer
33 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
23 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
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 ...
2
votes
1answer
251 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 ...
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 ...
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
597 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
63 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 ...
0
votes
0answers
106 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 ...
1
vote
0answers
411 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
364 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
188 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
657 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
415 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
20k 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. ...
2
votes
0answers
73 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
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 ...
3
votes
1answer
991 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
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 ...
0
votes
1answer
30 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
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 ...
4
votes
1answer
317 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
610 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
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 ...
1
vote
0answers
122 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
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 ...
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 ...
0
votes
1answer
4k 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
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 ...
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
0answers
37 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 ...
1
vote
1answer
502 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
232 views

Connecting to another server with ArcSDE?

How to connect from my server in our office to another server in another office with internet and access to their geodatabase by use of ArcSDE?
2
votes
0answers
83 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 ...
1
vote
0answers
899 views

Why does QGIS not show my new geometry columns?

I am trying to connect a few PostGIS Tables to Quantum GIS. The problem is that the geometry columns QGIS is showing are not the ones from the PostGIS database. QGIS shows me some columns I used to ...
0
votes
0answers
456 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
1answer
554 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 ...
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 ...
2
votes
1answer
901 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 ...
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 ...
8
votes
3answers
779 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 ...
4
votes
1answer
979 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 ...