Specifying a cache file location using CData ADO.NET Provider for SharePoint
Connection string
This CData ADO.NET Provider for SharePoint connection string can be used for connections to SharePoint.
URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
Cache Location=c:\cacheData.db;