I'm trying to set up a spatially enabled SQLite database with ArcGIS 10.3. I've gone through the following steps:
Create a database using the sqlite3 utility:
Load the relevant extensions:
SELECT load_extension('c:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite\Windows32\stgeometry_sqlite.dll','SDE_SQL_funcs_init');
Create the tables to add the ST_Geometry tables to the database:
After following the above, I can browse to the database in ArcCatalog. I can copy feature classes from personal geodatabases into it using
Feature Class to Feature Class. However, whenever I attempt to buffer this feature class in the SQLite database, with the same database the output, I get the error "DBMS table not found".
If a run the same buffer operation from a personal geodatabase to the SQLite database, it succeeds. If I run the same operation from SQLite to a personal geodatabase, it fails.
The database name and feature class names are all lowercase, per the advice of this SE post.
It seems that something is wrong with the data in SQLite, but I have no idea what.