Hot answers tagged

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 ...


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 ...


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 ...


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 ...


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 ...


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 ...



Only top voted, non community-wiki answers of a minimum length are eligible