none
"Choose Data Source" -- am I missing a data source?

    Question

  • Hi,

    I'm using Visual Studio Express 2008 and SQL Server Express 2008. When I'm creating a connection, the "Choose Data Source" dialog only lists the following data sources:

    Microsoft SQL Server Compact 3.5
    Microsoft SQL Server Database File

    ... should there be a "Microsoft SQL Server" or "Microsoft SQL Server Express" option?

    D.
    Monday, November 23, 2009 3:16 PM

Answers

  • Hi DodgerLD,

    Thank you for your post.

    Some clarification with you:
    Which Visual Studio 2008 Express product are you running now?

    I have Visual Basic Express IDE on my machine. When I tried to add Database Connection, I could notice:


    In Visual Basic Express, we can only add local database file as data source, like Microsoft Access Database File, Microsoft SQL Server Compact 3.5, and Microsoft SQL Server Database File. For detail, you can see this table:

    Feature

    Express Products

    Visual Studio Standard Edition

    Visual Studio Professional Edition

    Visual Studio Tools For Office

    Visual Studio Team System

    Database design tools (create/modify tables procedures)

    Local

    Local and remote

    Local and remote

    Local and remote

    Local and remote

    Data Access Designers

    VB,VC#,VC++: local

    Visual Web Developer: local and remote

    Local and remote

    Local and remote

    Local and remote

    Local and remote


    For additional information, please see http://msdn.microsoft.com/en-au/vstudio/products/cc149003.aspx#divDataRelatedTools.

    However, we can still do the data access programmatically.
    For more detailed information about how to create the connection string, please see http://www.connectionstrings.com/.
    For some code snippet about using ADO.NET in C#, you can refer to the example CSUseADONET in this open source project, All-In-One Code Framework.

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

    Best regards,
    Yichun Chen

    (This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)
    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.
    • Proposed as answer by Mr. Kashif Khan Friday, November 27, 2009 1:04 PM
    • Marked as answer by YiChun Chen Monday, November 30, 2009 5:22 AM
    Wednesday, November 25, 2009 6:34 AM

All replies

  • Hi,

    I'm using Visual Studio Express 2008 and SQL Server Express 2008. When I'm creating a connection, the "Choose Data Source" dialog only lists the following data sources:

    Microsoft SQL Server Compact 3.5
    Microsoft SQL Server Database File

    ... should there be a "Microsoft SQL Server" or "Microsoft SQL Server Express" option?

    D.
    This problem is resolved in visual studio service pack1. Once i had the same problem which was resolved after installing VS 2008 service pack 1. Otherwise download VS2008 express edition with service pack 1 included in it from the following link: 


    It is because VS2008 was released before SQL server 2008 and there was no connectivity from VS2008 so that was resolved in service pack 1.



    If this post has resolved your problem/issue please mark our post as answered. We would like to help users more if they appreciate our efforts by my marking our posts as answered. This is an auto generated signature.
    • Proposed as answer by Mr. Kashif Khan Wednesday, November 25, 2009 3:02 AM
    Wednesday, November 25, 2009 3:02 AM
  • Hi DodgerLD,

    Thank you for your post.

    Some clarification with you:
    Which Visual Studio 2008 Express product are you running now?

    I have Visual Basic Express IDE on my machine. When I tried to add Database Connection, I could notice:


    In Visual Basic Express, we can only add local database file as data source, like Microsoft Access Database File, Microsoft SQL Server Compact 3.5, and Microsoft SQL Server Database File. For detail, you can see this table:

    Feature

    Express Products

    Visual Studio Standard Edition

    Visual Studio Professional Edition

    Visual Studio Tools For Office

    Visual Studio Team System

    Database design tools (create/modify tables procedures)

    Local

    Local and remote

    Local and remote

    Local and remote

    Local and remote

    Data Access Designers

    VB,VC#,VC++: local

    Visual Web Developer: local and remote

    Local and remote

    Local and remote

    Local and remote

    Local and remote


    For additional information, please see http://msdn.microsoft.com/en-au/vstudio/products/cc149003.aspx#divDataRelatedTools.

    However, we can still do the data access programmatically.
    For more detailed information about how to create the connection string, please see http://www.connectionstrings.com/.
    For some code snippet about using ADO.NET in C#, you can refer to the example CSUseADONET in this open source project, All-In-One Code Framework.

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

    Best regards,
    Yichun Chen

    (This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)
    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.
    • Proposed as answer by Mr. Kashif Khan Friday, November 27, 2009 1:04 PM
    • Marked as answer by YiChun Chen Monday, November 30, 2009 5:22 AM
    Wednesday, November 25, 2009 6:34 AM
  • This problem is resolved in visual studio service pack1. Once i had the same problem which was resolved after installing VS 2008 service pack 1. Otherwise download VS2008 express edition with service pack 1 included in it from the following link: 


    It is because VS2008 was released before SQL server 2008 and there was no connectivity from VS2008 so that was resolved in service pack 1.



    If this post has resolved your problem/issue please mark our post as answered. We would like to help users more if they appreciate our efforts by my marking our posts as answered. This is an auto generated signature.
    As far as I know, I already have SP1 installed.
    Friday, November 27, 2009 11:23 AM
  • Hi YiChun Chen,

    I'm using Visual C# 2008 Express.

    So it's not even possible to connect to a *local* SQL Server Express instance?

    Doing it programmatically won't help because I need to use the Entity Data Model Wizard, etc.

    I don't really see the point to this limitation.

    Thanks for your help,

    D.
    Friday, November 27, 2009 11:44 AM
  • Hi YiChun Chen,

    I'm using Visual C# 2008 Express.

    So it's not even possible to connect to a *local* SQL Server Express instance?

    Doing it programmatically won't help because I need to use the Entity Data Model Wizard, etc.

    I don't really see the point to this limitation.

    Thanks for your help,

    D.
    try repairing your visual studio 2008 express and was there any error during installation or any warning that u ignored?
    If this post has resolved your problem/issue please mark our post as answered. We would like to help users more if they appreciate our efforts by my marking our posts as answered. This is an auto generated signature.
    Friday, November 27, 2009 1:07 PM
  • try repairing your visual studio 2008 express and was there any error during installation or any warning that u ignored?
    What for? YiChun Chen has already said that this feature is not available in the Express editions of Visual Studio.

    Are you saying that you can see this option?
    Sunday, November 29, 2009 8:05 PM
  • Hi DodgerLD,

    It's my pleasure!

    Frankly speaking, for Visual Studio Express Edition, it is for the hobbyist, enthusiast, and student. There would be some limitation for the usage.
    If you want to develop some commercial application, I would suggest you to upgrade to Visual Studio 2008 Standard Edition or above since these editions applies more helpful features for software development.

    FYI:
    If you have any concern on Entity Framework development, you might try ADO.NET Entity Framework and LINQ to Entities forum.

    Hope this helps! Have a great week.

    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.
    Monday, November 30, 2009 5:22 AM