Cannot set Connection String to LocalDb using OLEDB
Cannot set Connection String to LocalDb using OLEDB Good morning guys, I feel quite silly to ask this question, but I have looked everywhere and possibly at all questions in this matter and could not find a solution that would work for me. Long story short. I am using a local database called TestDB.mdf in windows form application. The application is designed to do (as per current) two simple things. TestDB.mdf and... For the import data into the database (point 1) I am using two connection strings. One for excelConnectionString excelConnectionString string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + "C:UsersUser.ARDesktopexport.xls; " + "Extended Properties="Excel 8.0;HDR=YES;IMEX=1;""; and second for sqlConnectionString sqlConnectionString string sqlConnectionString = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=c:usersarkadiusz.rzepkasourcereposDatabase_applic...
