locked
VS 2008 "Choose Data Source" wizard RRS feed

  • Question

  • 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.

    Some additional info:

    Microsoft Visual Studio 2008
    Version 9.0.30729.1 SP
    Microsoft .NET Framework
    Version 3.5 SP1

    Installed Edition: Professional

    Microsoft Silverlight Projects 2008   91605-270-8613881-60632
    Microsoft Silverlight Projects 2008
    Version 9.0.30730.126

    Microsoft Visual Basic 2008   91605-270-8613881-60632
    Microsoft Visual Basic 2008

    Microsoft Visual C# 2008   91605-270-8613881-60632
    Microsoft Visual C# 2008

    Microsoft Visual C++ 2008   91605-270-8613881-60632
    Microsoft Visual C++ 2008

    Microsoft Visual Studio 2008 Tools for Office   91605-270-8613881-60632
    Microsoft Visual Studio 2008 Tools for Office

    Microsoft Visual Web Developer 2008   91605-270-8613881-60632
    Microsoft Visual Web Developer 2008

    Crystal Reports    AAJ60-G0MSA4K-68000CF
    Crystal Reports Basic for Visual Studio 2008


    Enterprise Library Configuration Editor   4.0
    Microsoft patterns & practices Enterprise Library Configuration Editor

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899)   KB944899
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/944899.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282)   KB945282
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/945282.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040)   KB946040
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/946040.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308)   KB946308
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/946308.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344)   KB946344
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/946344.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581)   KB946581
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/946581.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171)   KB947171
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947171.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173)   KB947173
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947173.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180)   KB947180
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947180.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540)   KB947540
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947540.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789)   KB947789
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947789.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127)   KB948127
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/948127.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256)   KB953256
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/953256.

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092)   KB971092
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this hotfix will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/971092.

    Microsoft Recipe Framework Package   8.0
    This package provides services to the guidance packages.

    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140)   KB945140
    This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this service pack will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/945140.

    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888)   KB947888
    This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this service pack will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/947888.

    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484)   KB948484
    This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this service pack will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/948484.

    Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB972222)   KB972222
    This security update is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this security update will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/972222.

    Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675)   KB973675
    This security update is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this security update will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/973675.

    SQL Server Analysis Services  
    Microsoft SQL Server Analysis Services Designer
    Version 10.0.2531.0

    SQL Server Integration Services  
    Microsoft SQL Server Integration Services Designer
    Version 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

    SQL Server Reporting Services  
    Microsoft SQL Server Reporting Services Designers
    Version 10.0.2531.0

    tangible T4 Editor   9.0
    tangible T4 Text Template Editor - T4 Editor

    tangibleprojectsystem   1.0
    Provides a project system for use with standalone shell

    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453)   KB956453
    This update is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this update will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/956453.

    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143)   KB967143
    This update is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    If you later install a more recent service pack, this update will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/967143.

    ANTS Profiler 4 Add-in
    For more information about ANTS Profiler 4, see the website at
    http://www.red-gate.com
    Copyright (c) Red Gate Software Ltd 1999-2008

    Friday, June 11, 2010 8:07 AM

Answers

  • Hi RedRicht,

    Thank you for your post.

    Some clarification with you:
    What kind of project are you developing now?
    Could you please provide me more detail information of your project and the steps that you do so that I can try to reproduce the scenario that you came across?

    I have tried to create a new Winform application and add one ADO.NET Entity Data Model item in VS2008 IDE on my machine. I can find "Microsoft SQL Server Compact 3.5".

    Have you tried to repair or reinstall your Visual Studio 2008?

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by YiChun Chen Friday, June 18, 2010 3:11 AM
    • Edited by YiChun Chen Friday, June 18, 2010 3:11 AM typo
    Monday, June 14, 2010 11:22 AM

All replies

  • This post might help answer your question.  It sounds like it could be an issue with the db version but you should still be able to connect programatically.

    http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/5ac1c88b-ba4a-472b-a734-872febdceb0a/

    Friday, June 11, 2010 5:08 PM
  • Thanks for the reply, however the link did not help.

    Before all my issues  I could use the Local Data Cache item and ADO Entity Data Model item from visual studio. Usually when using these components you have to add datasources to get your tables etc. This has never been a problem as it used to list all available data source - Microsoft SQL Server Compact, ODBC, Database file etc etc.

    The problem came about when I installed some hotfix to sort out the issues I had with ADO Entity Framework and Sql Compact 3.5. The list of datasources only lists the two options I mention above.

    I have uploaded some screenshots of the problem (screentshot 1)  (screenshot 2)

    The server explorer works as expected (screenshot) .

    Thanks

    Saturday, June 12, 2010 10:03 AM
  • Hi RedRicht,

    Thank you for your post.

    Some clarification with you:
    What kind of project are you developing now?
    Could you please provide me more detail information of your project and the steps that you do so that I can try to reproduce the scenario that you came across?

    I have tried to create a new Winform application and add one ADO.NET Entity Data Model item in VS2008 IDE on my machine. I can find "Microsoft SQL Server Compact 3.5".

    Have you tried to repair or reinstall your Visual Studio 2008?

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by YiChun Chen Friday, June 18, 2010 3:11 AM
    • Edited by YiChun Chen Friday, June 18, 2010 3:11 AM typo
    Monday, June 14, 2010 11:22 AM