nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Make a Query Layer for Sqlite?

KirkKuykendall1

Hi -

Why can't I use a .geodatabase file as a database connection?

Thanks, Kirk

Vind meer berichten getagd met

Accepted answers

Anonymous User

Hi Kirk,

The .geodatabase file type is a SQLite geodatabase used for runtime applications, such as Collector for ArcGIS. The Make Query Layer geoprocessing tool is looking for a .sde database connection file, such as the one generated from the Create Database Connection geoprocessing tool.

-Calvin

All comments

DwayneKuykendall

Kirk,

I found that to make ArcMap/ArcGIS Pro recognize a .geodatabase file as SQLite, make a copy and rename the extension to .sqlite. Also, you will need to remove/rename the the "GDB_Items" and "GDB_Version" tables.

Of course, this works for "read-only" workflows and probably not recommended for inserting/updating features within the views.

KirkKuykendall1

Thanks, I've submitted idea for .geodatabase support in Make Query Layer.

Anonymous User

Hi Kirk,

-Calvin

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.