Maximum length of connectionstring for SQLite in .Net
Is there any limit for maximum length of connection string for SQLite in .Net , If my path to database file is very long.
I realized that if I provide connection string including "DataSource=" part more than 128 characters,
connection.Open() would return exception saying
unable to open database file
I am using following code
DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SQLite") DbConnection connection = dbProviderFactory.CreateConnection(); connection.ConnectionString = "DataSource=C:\<longNetworkDirectory(WithoutSpaces)Path\<databaseName>.db"; connection.Open();