Visual Studio Express 2010 and using SQL

  Heefie 13:09 15 Apr 10

I am trying to write a small personal Application in Visual Studio 2010 Express which is basically in place, but I now need to set up my data.

I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so I am assuming I have to choose "Add Connection" first ...

This gives me 3 options :

Microsoft Access Database File
Microsoft SQL Server Compact 3.5
Microsoft SQL Server Database File

I am ignoring the first option as I want to use SQL not Access, but what is the difference between the two SQL options ?!?

Can somebody please let me know, in straightforward English ?!?

Thanks in advance ...

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now