Switch app from SQL Server 2008 DB to LocalDb
Posted on 2014-01-15
I have a vb.net windows form application that currently attaches to a SQL Server 2008 database.
I have installed LocalDb and created a copy of the structure and data from the original db.
The app uses the app.config file to get the settings for connecting to the db.
How can I change the app so that it connects to the LocalDb database?
I have tried adding the connection string to the app.config but the app doesn't seem to be recognizing the instance or server. I have use (localdb)\v11.0 and also tried using the named pipes as the server name, but again the application doesn't seem to be recognizing the instance or server.
Any help with samples would be appreciated. Thanks in advance.