New answers tagged

1

I'm sure you've moved on since the question was asked but I wanted to pass along a doc on what might be happening here for users who land here. Error: Failed to connect to database. Bad login user. Success when creating a geodatabase using ArcSDE workgroup license. The gist of it is there was a bug at 10.1 (NIM083155) where the SDE Workgroup license ...


0

This answer is to fulfill your request for "Other methods"... I used this post to help me set up and install my own windows server to geocode US addresses. Basic instructions are to: Install PostgreSQL (open source database) Install PostGIS and TIGER extensions Use TIGER functions to download/install US TIGER data by state


5

A google on "ArcGIS READ_COMMITTED_SNAPSHOT ALLOW_SNAPSHOT_ISOLATION" returned a "What's new in ArcMap" 10.4 documentation reference. In the Geodata section it states (third bullet, emphasis mine): Beginning with ArcGIS 10.4, geodatabases in SQL Server require the SQL Server database options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION be ...


1

The syntax to use with different GDAL vector drivers varies as well as how and where the syntax is documented in the corresponding driver pages. The SQL Server driver manual page has section "Connecting to a database" with basic instruction To connect to a MSSQL datasource, use a connection string specifying the database name, with additional ...


-2

After weeks of trying to solve this same problem, this amazing set of code samples absolutely saved me: http://wiki.openstreetmap.org/wiki/Mercator#Spherical_Mercator


2

Use sde:sqlserver:mymachinename for your server instance arcpy.ArcSDESQLExecute(server='mymachinename', instance='sde:sqlserver:mymachinename', database='mydbname', user='myuser',password='mypass') This makes your Direct Connect work rather than using an SDE service instance. I recall this happening a couple of versions ago when we were moving from SDE ...


0

Here is how I did it using MVC and VB.NET This SchoolDistrictVertices function is in a partial class of a SchoolDistrict object which was generation using EntityFramework from a SQL database. It contains a geography field named DistrictLocation. Public Structure Coordinate Public Property Latitude As Double Public Property Longitude As Double End ...


0

Just saw this ability, but I think it's only for ArcSDE: https://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/install-st-raster-sqlserver.htm


0

If you don't need the old copy of the table anymore you could use: if arcpy.Exists(table): arcpy.Delete_management(table) to get rid of the old table, then use arcpy.TableToTable_conversion() (http://pro.arcgis.com/en/pro-app/tool-reference/conversion/table-to-table.htm) to convert your attributes to a dbase table in your SDE. Alternatively you'd have ...


1

For the record: Enterprise geodatabase libraries were available for both 32-bit and 64-bit servers at 10.0, and have shipped exclusively 64-bit since ArcGIS 10.1. There has never been a "32-bit bottleneck" in ArcSDE client applications (as of the time of the original post, the increased 64-bit instruction size actually slowed performance, though modern ...


3

ArcGIS doesn't like fieldnames with spaces, or any other non-alphanumeric character for that matter (other than the underscore _) The Esri FAQ What characters should not be used in ArcGIS for field names and table names? says Eliminate any characters that are not alphanumeric character or an underscore. Do not start field or table names with an ...



Top 50 recent answers are included