René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"find-refs fails to open database: \"Connection string keyword 'version' is not supported\"","articleBody":"## Summary\n\nThe `find-refs` command fails immediately when opening a database produced by `analyze`:\n\n```\n$ UnityDataTool find-refs out.db -n red -t Texture2D\nError opening database: Connection string keyword 'version' is not supported. For a possible alternative, see https://go.microsoft.com/fwlink/?linkid=2142181.\n```\n\nThis was reported on internal Slack but the cause wasn't clear at the time. It reproduces consistently with any analyze database.\n\n## Cause\n\nThe reference finder builds a SQLite connection string using a legacy keyword (`Version=...`) from the old `System.Data.SQLite` provider. The project uses `Microsoft.Data.Sqlite`, which does not recognize that keyword and throws on open. The `analyze`/`SQLiteWriter` path builds its connection string correctly via `SqliteConnectionStringBuilder`, so only the ReferenceFinder code path is affected.\n\n## Fix direction\n\nBuild the connection string with `SqliteConnectionStringBuilder` (matching `SQLiteWriter`) instead of hand-writing a `System.Data.SQLite`-style connection string. To be addressed in a follow-up PR.\n\n## Repro\n\n```\nUnityDataTool analyze -o out.db -p \"*.cf\" \u003cContentDirectory build\u003e\nUnityDataTool find-refs out.db -n red -t Texture2D\n```\n\n## Related\n\nRelated to #44 (refs table work).","author":{"url":"https://github.com/SkowronskiAndrew","@type":"Person","name":"SkowronskiAndrew"},"datePublished":"2026-06-11T20:35:21.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/72/UnityDataTools/issues/72"}