I am trying to learn database programing. It doesn't seem hard to create a database. However, it seems impossible to connect to it. In Vb Express 2008 I clicked on then Add Data Source. I chose the database and selected New Connection. I selected Microsoft SQL Server Database File and then clicked OK. In the Database file name I browsed to it and selected it and then pressed OK.
I then get then error message:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I have tried everything I can find on the internet but cannot get the data source.
Why has Microsoft tried so hard to keep you away from something you created. It doesn't make sense.
Any help would be appreciated.