I have been having a very frustrating time trying to connect to a localDB database from Excel VBA.
I have created a database using Visual Studio 2012 Express and in the IDE the database seems fine. I can create data and query it without problem.
In Visual Studio the Connection Properties windows shows:
Name: D:\FISKDEV_EXCEL\FISKDBSOLN\FISKDBSOLN\FISKDB.MDF
Connection String: Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\FiskDev_Excel\FiskDBSoln\FiskDBSoln\FiskDB.mdf;Integrated Security=True
Provider: .NET Framework Data Provider for SQL Server
Primary File Path: D:\FiskDev_Excel\FiskDBSoln\FiskDBSoln\FiskDB.mdf
I then try to connect to the automatic inst ...
Go to the complete details ...