locked
Connection between SQL Server 2005 and VS 2005 RRS feed

  • Question

  • User1192199902 posted

     Hi All,

    Please tell me the steps to establish connection between SQL Server 2005 and Visual Studio 2005.

    The Server Explorer is not showing "Microsoft SQL Server" in Data Source List.  How can i connect?

     

     

    Thanks in Advance,

    Sateesh Nagalla,

    Senior Software Engineer,

    Medha Solutions Pvt. Ltd.

    9440600811

    Saturday, September 12, 2009 9:16 AM

Answers

  • User1192199902 posted

    Hi SS,

    Thanks for your support, the problem is solved.

    Actually there is no servers are showing automatically in Server Name drop down, i given server name manually. Then it is working.

    And MDAC_TYPE.EXE is not installing, showing a fatal error that "The setup does not support installing on this operating system".

    Thanks & Regards,

    Sateesh.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 16, 2009 11:02 PM

All replies

  • User-1112770754 posted

    What is showing?

    Are you seeing:

    1.   Server 

               Comuter Name

                      Event logs

                      Services 

                      Etc.

           If you are not seeing this you can right click on "server" and add your computer (server).

    2.    Data Connections

                    Comuter Name/SQL Server

            If you are not seeing this... then you can right click on Data Connections and add a new connection.

    Let me know if this help... if it does, please remember to mark as answer.

     

           

    Saturday, September 12, 2009 10:09 AM
  • User1192199902 posted

    Yes, i am able to see those options, but in the next step i am getting problem to connect with SQL Server database.

    i.e. there is no Data Provider for "Microsoft SQL Server" in Choose Data Source dialog. Here ".NET Framework Data Provider for SQL Server" is missing.

    How can i get that option? I think i installed SQL Server 2005 first, after i installed VS 2005.

    Saturday, September 12, 2009 2:30 PM
  • User-1112770754 posted

    First, I'd like to suggest that you download and install Microsoft Data Access Components (MDAC) 2.8 SP1.

    You can find it here:

    http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

    Hope that works... if it does not, I am not sure how you can resolve this.

    I have other ideas... but, its a lot of work and no gurantees.

    Good luck.

     

    Saturday, September 12, 2009 5:54 PM
  • User1192199902 posted

    Hi SS,

    Thanks for your support, the problem is solved.

    Actually there is no servers are showing automatically in Server Name drop down, i given server name manually. Then it is working.

    And MDAC_TYPE.EXE is not installing, showing a fatal error that "The setup does not support installing on this operating system".

    Thanks & Regards,

    Sateesh.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 16, 2009 11:02 PM