Forum Discussion
Connecting to SQLite db stored in sharepoint
Hi,
I'm able to connect to an sqlite.db file stored on my PC, but I don't seem to be able to connect to the the same db if stored on a sharepoint folder. I tried to simply replace the C:\ path with the url. I tried to connect to sharepoint folder and select the file from there, but I still miss that kind of database= string. I have permissions to the site and use my windows credentials for authentication (connecting to any other file works). Am I missing any steps?
Thanks,
Pietro
You cannot. SharePoint libraries do not behave the same as local drives or network shares. Same with Access databases. Access cannot even open its own MDB/ACCDB files in SharePoint. They have to be sync'd locally. Excel, Word, and PowerPoint, and a few others, have been modified to open files directly on SharePoint.
Even Power BI cannot open PBIX files stored in SharePoint - you have to have them local. So your SQL Lite database must be on a local drive to work, and you'll need a gateway to connect to it from the service.
2 Replies
You cannot. SharePoint libraries do not behave the same as local drives or network shares. Same with Access databases. Access cannot even open its own MDB/ACCDB files in SharePoint. They have to be sync'd locally. Excel, Word, and PowerPoint, and a few others, have been modified to open files directly on SharePoint.
Even Power BI cannot open PBIX files stored in SharePoint - you have to have them local. So your SQL Lite database must be on a local drive to work, and you'll need a gateway to connect to it from the service.
File based Databases need to be writable. That includes SQLite and Access (which even comes with its own lock files).
You _might_ be able to get your data by explicitly open the SQLite database read only via an ODBC driver. Haven't tried this though.
Another alternative is to use the Folder connector (NOT the Sharepoint Folder connector) and use the UNC path to your sharepoint folder instead, like \\sharepoint.url\site\folder\db.sqlite .
