Visual Studio Express 2010 and using SQL

  Heefie 13:09 15 Apr 2010

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.

Elsewhere on IDG sites

Samsung Galaxy S9 review

Wacom Cintiq Pro 24 and 32 review – hands-on

When is the next Apple event?

Gmail : comment annuler l’envoi d’un e-mail ?