All,
I have attempted to create a SQLite database from the Python console within ArcMap 10.3 and have been following the simple instructions discussed in CreateSQLiteDatabase—Help | ArcGIS for Desktop.
A poster in 2014 describes the same problem but it is clear they never got a solution: dir function does not show CreateSQLiteDatabase too
When I type "arcpy.gp." it never offers up CreateSQLiteDatabase(). I am using Windows 7, 64bit version. I have run a repair on ArcMap from the Programs and Features part of the Control panel thinking I may have had a corrupted installation but this has not resolved it. My version of ArcMap was an upgrade from 10.2 to 10.3.
Is there some other hidden (and undocumented) step I need to do to make this work? Help seems to suggest that it should all be there and working. Could it be some sort of conflict with python (not sure I am suggesting a red herring here)? If I look in the folder C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite there appears to be a 32 and 64 bit version. If I type in the python console window within ArcMap
import sys
print sys.version
I get 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)]
Also attempted the same thing on a colleagues computer who has 10.3 and when I type "arcpy.gp." it too never offers up CreateSQLiteDatabase().
Any advice would be appreciated!
Duncan