I'm trying to connect to a SQLite database using the URI syntax. However, it fails with a "unsupported path format" exception as soon as I include the absolute (Windows) path in the URI. If I leave the path out using only the file name but setting the process working directory accordingly, it works.
Connection string examples:
- Works with cwd set accordingly:
Code: Select all
Data Source="file:test.db?cache=private"
- Fails:
Code: Select all
Data Source="file:///D:/my/path/test.db?cache=private"
The ultimate goal here is to use an alternative sqlite3.dll which accepts some additional URI parameters, but the same problem occurs using the sqlite3.dll provided with dotConnect with the samples given above.
The same URIs work flawlessly in a sqlite shell, though, so it seems there is a bug in dotConnect?
Tested using dotConnect 5.12.1422 and 5.16.1759