ArcGIS not connecting to PostgreSQL db with all upper-case nameConnecting ArcGIS Desktop with PostGIS?Direct connecting to PostgreSQL from ArcGIS Desktop?ajax not working with postgresqlConnecting to ArcGIS Desktop PostgreSQL database (running locally)Using PostgreSQL with ArcGISConnecting PostgreSQL/PostGIS and MapGuide MaestroQuery layer in ArcGIS Desktop with PostgreSQL not querying data?Remove upper case in column names in a PostGIS spatial table to permit use in ArcMapConnecting Django to postgresqlConnecting ArcGIS Desktop to remote PostgreSQL database?
Can a non-invertible function be inverted by returning a set of all possible solutions?
Right indicator flash-frequency has increased and rear-right bulb is out
Have Steve Rogers (Captain America) and a young Erik Lehnsherr (Magneto) interacted during WWII?
Digital signature that is only verifiable by one specific person
First occurrence in the Sixers sequence
Does knowing the surface area of all faces uniquely determine a tetrahedron?
Would a 7805 5v regulator drain a 9v battery?
How do I run a script as sudo at boot time on Ubuntu 18.04 Server?
1960s sci-fi anthology with a Viking fighting a U.S. army MP on the cover
My student in one course asks for paid tutoring in another course. Appropriate?
Leaving job close to major deadlines
How can I ping multiple IP addresses at the same time?
Leveraging cash for buying car
Why are almost all the people in this orchestra recording wearing headphones with one ear on and one ear off?
How do I gain the trust of other PCs?
How to know whether to write accidentals as sharps or flats?
Is there a risk to write an invitation letter for a stranger to obtain a Czech (Schengen) visa?
Can I drive in EU states and Switzerland with German proof of a surrendered U.S. license?
High-end PC graphics circa 1990?
Will users know a CardView is clickable?
On George Box, Galit Shmueli and the scientific method?
At what temperature should the earth be cooked to prevent human infection?
Manager wants to hire me; HR does not. How to proceed?
I have found ports on my Samsung smart tv running a display service. What can I do with it?
ArcGIS not connecting to PostgreSQL db with all upper-case name
Connecting ArcGIS Desktop with PostGIS?Direct connecting to PostgreSQL from ArcGIS Desktop?ajax not working with postgresqlConnecting to ArcGIS Desktop PostgreSQL database (running locally)Using PostgreSQL with ArcGISConnecting PostgreSQL/PostGIS and MapGuide MaestroQuery layer in ArcGIS Desktop with PostgreSQL not querying data?Remove upper case in column names in a PostGIS spatial table to permit use in ArcMapConnecting Django to postgresqlConnecting ArcGIS Desktop to remote PostgreSQL database?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.
We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.
And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.
So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?
arcgis-desktop postgresql
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
|
show 1 more comment
We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.
We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.
And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.
So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?
arcgis-desktop postgresql
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
1
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23
|
show 1 more comment
We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.
We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.
And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.
So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?
arcgis-desktop postgresql
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.
We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.
And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.
So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?
arcgis-desktop postgresql
arcgis-desktop postgresql
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
edited Mar 25 at 8:06
PolyGeo♦
54.4k1784253
54.4k1784253
asked Mar 24 at 22:45
user25730user25730
262210
asked Mar 24 at 22:45
user25730user25730
262210
asked Mar 24 at 22:45
user25730user25730
262210
262210
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
1
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23
|
show 1 more comment
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
1
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
1
1
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23
|
show 1 more comment
1 Answer
1
active
oldest
votes
It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):
Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.
And the Server documentation says the same (ditto):
Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.
With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.
answered Mar 25 at 3:24
VinceVince
15.1k33050
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f316512%2farcgis-not-connecting-to-postgresql-db-with-all-upper-case-name%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):
Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.
And the Server documentation says the same (ditto):
Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.
With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.
answered Mar 25 at 3:24
VinceVince
15.1k33050
add a comment |
It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):
Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.
And the Server documentation says the same (ditto):
Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.
With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.
answered Mar 25 at 3:24
VinceVince
15.1k33050
add a comment |
It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):
Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.
And the Server documentation says the same (ditto):
Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.
With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.
answered Mar 25 at 3:24
VinceVince
15.1k33050
It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):
Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.
And the Server documentation says the same (ditto):
Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.
With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.
answered Mar 25 at 3:24
VinceVince
15.1k33050
answered Mar 25 at 3:24
VinceVince
15.1k33050
answered Mar 25 at 3:24
VinceVince
15.1k33050
answered Mar 25 at 3:24
VinceVince
15.1k33050
15.1k33050
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f316512%2farcgis-not-connecting-to-postgresql-db-with-all-upper-case-name%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
– Michael Stimson
Mar 24 at 23:29
I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
– user25730
Mar 24 at 23:34
That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
– Michael Stimson
Mar 24 at 23:43
1
There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
– Vince
Mar 25 at 0:19
Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
– Michael Stimson
Mar 25 at 2:23