Good Day,

I'm using Visual Studio Professional 2008 SP 1. When I create a connection via the designer, the "Choose Data Source" dialog only lists the following data sources:

Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File

When I create a connection on the Server explorer the list is complete with :

Microsoft SQL Server Compact 3.5, Microsoft SQL Server Database File, Microsoft SQL Server Compact, ODBC etc.

Please help me out. I need to use SQL Server Compact.

I have posted the same problem on the following thread with some screenshots: http://social.msdn.microsoft.com/Forums/en/vssetup/thread/906845c3-69e9-431a-ad07-7da2de684d33