Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: plz help..sql server and visual studio(i'ts urgent)  (Read 2910 times)

0 Members and 1 Guest are viewing this topic.

searcher

    Topic Starter


    Rookie

  • Do good and have good!
    plz help..sql server and visual studio(i'ts urgent)
    « on: October 02, 2011, 02:12:33 PM »
    Hey Somebody has given me Human resource management system folder to connect with both sql server 2000 and visual studio 2008.
    I really dont know how to connect :(
    I have two folders
    In folder1 there are two files only of format ".mdf" and ".ldf"
    In folder2 there are so many files of "aspx","aspx.cs","aspx.vb" and some folders named"App_Code", "App_Data", "images", "Reports"

    here is some info abt my pc:
    OS= Windows 7
    visual studio 2008
    sql server 2000
    I have to connect the server.but dont know which folder to connect with which program and how?
    please explain step by step.
    Dont give me links.as i have googled but there were issues with connectivity.
    Thanks for your time

    Geek-9pm


      Mastermind
    • Geek After Dark
    • Thanked: 1026
      • Gekk9pm bnlog
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 10
    Re: plz help..sql server and visual studio(i'ts urgent)
    « Reply #1 on: October 02, 2011, 06:13:21 PM »
    OK. Yo already did the Google search and you found this question has already been addressed by others and now you came here hoping for a different answer.

    You are r trying to downgrade. From 2000 to 2008 is a span of eight years. Microsoft does not offer much support for older product. And they do not encourage the use of newer software with older software.

    The above is a paraphrase of comments by others.
    Why don't you want links? You are not going to find a answer that will neatly fit on one page of this forum. You question is much to specific to dedicate pages to the issue. It is more that knowing the directory.

    Here is a brief history of Visual Studio. Some older versions are now free downloads. Have you tried an older version?
    http://en.wikipedia.org/wiki/Microsoft_Visual_Studio
    Life support
    http://support.microsoft.com/gp/lifeselectindex
    SQL 2000 documentation
    http://msdn.microsoft.com/en-us/library/aa175269%28v=sql.80%29.aspx
    http://support.microsoft.com/gp/lifeselectindex

    Pardon me if my remarks are not what you want to hear. I am being very frank, which saves both you and me some time. Here is a post that forms the basis of my observations. If he was wrong, then so am I.

    Quote
    1.) SQL 2000 support has been dropped from all of VS, not just database projects. There is a cost to maintaining providers and the SQL 2000 Engine is much different than 2005 and 2008. With limited resources we have focused on 2005, 2008, 2008 R2 and the upcoming version of SQL.

    2.) No, you will not be able to directly deploy to SQL 2000 instance in 2010.  You would have to target 2005 or 2008 and use the script produced and run the script against a 2000 database.  The project and the resulting script is not validated for 2000 regardless of the compatability setting of the database. Validation is driven by the version of SQL you target in the project properties.

    We recognize this is not ideal, but is the best it gets for SQL 2000 in 2010.  For customers targeting 2000 we suggest running 2008 GDR and 2010 Side by Side.
    Thanks,
    First answer on...
    http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/37d137be-f119-4d49-bddf-99f398328096/