Data Sources Wizzard missing SQL Server

[LeonR]

Does anybody know why my vb.net express is missing the SQL server express from the list?? (just compact and SQL file). This is rather annoying!

Obviously I can connect manually, but I wanted to experiment with the data entity models etc!

Thanks,
Leon

 

[JohnH]

Sql file is for Sql Server Express, you specify the database file rather than the server-database. The database file is attached by request to the Sql Server Express (AttachDbFilename is specified by connection string).
Those are the only two options for VB Express data wizards.
Entity Data Model is available from data sources > database > EDM > for example generate from database > then create or use existing connection to database file for Compact or Sql Express.

 

[LeonR]

Thanks again John, much appreciated!