VS 2010 Express (Ver 4.0.30319) has a workable method for connecting to an existing Access database which I have used successfully, but my attempts to create and connect to a new SQL Server database have been unsuccessful.
My code seems to add tables and fields to the database successfully, but when I try to add a TableAdapter to my VB form a message informs me that the database is empty.
I found the following post on a VS forum:
This is a limitation of the Express editions of Visual Studio. They offer very limited designer support for databases. For example, you can't connect to a standard SQL Server database using the Visual Studio designers using an Express edition, only a "user instance" database.
You can still work with MySQL databases via code using the .NET Framework.
David Sceppa Marked As Answer by Parth Joshi Sunday, July 04, 2010 10:10 AM
What is a "user instance" database?
Does this mean that it is not possible to create a new SQL Server database from VS 2010 Express?
If so, how can I create a new database? Must I resort to Access?