3

Why can't I connect to an SQLite database in AutoCAD unless it was built using AutoCAD's "Create Data Store"?

and vice versa Why can't QGIS or Arc Desktop connect to a SQLite database created using AutoCAD's "Create Data Store" feature?

When I use SQLite command line tools on the AutoCAD created database I get queries that return selections and answers but I also get several errors before the query runs.

Is there a way to make a SQLite database that can be used by multiple GIS/CAD products?

closed as unclear what you're asking by PolyGeo Jan 25 '17 at 10:01

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Could it be that AutoCAD doesn't create a SPATIALite db but just SQLite? – underdark Nov 8 '16 at 18:20
  • Apparently so, and I cannot even enable the spatialite extension on the database either. When I do enable it AutoCAD does not seem to know what the data is after that. Thanks for the reply. – Tyler Veinot Nov 8 '16 at 19:53
  • According to en.wikipedia.org/wiki/SpatiaLite, AutocadMap 2013 supports SpatiaLite. Do you have access to that? – underdark Nov 8 '16 at 19:57
  • Run ogrinfo for all the different SQLite databases you have and show us the metadata. AutoCAD may like to create a FDO style db. That should still be supported by GDAL and QGIS through FDO provider trac.osgeo.org/fdo/wiki/FDORfc16 as "regular" SQLite db gdal.org/drv_sqlite.html. – user30184 Nov 9 '16 at 8:24
  • I have AutoCAD Map3d 2017. The ogrinfo says the CAD.sqlite database, the one I made with AutoCAD to see if it will open in QGIS and Arc, shows 1: FeatureClass1 imported using sqlite. When I run it on the database Arc and QGIS can use but AutoCAD cannot I get a list of all the featureclasses, geometry type. The mobile database was built in QGIS using the "Offline Editing" function as a way to deploy data to the field. – Tyler Veinot Nov 9 '16 at 13:00