none
Microsoft SQL Server 2000 Desktop Engine Release A RRS feed

  • 問題

  • Our company had purchased a tailor made software responsible for some tasks.

     

    The software is running with Microsoft SQL Server 2000 Desktop Engine Release A for database storage.

     

    I tried to use the Microsoft Access to access that database and

    I can view the data inside the database successfully, however, I cannot modify their values.

     

    Can anyone tell me how to solve this problem?

     

    Thank you very much!

    2008年12月30日 下午 12:56

解答

  • Can use osql to access msde, or install sql client tools.

     

    2008年12月31日 上午 01:27
  • As Rmiao said, MSDE only support OSQL or if you have license on SQL 2000 Server, You may install SQL 2000 Client Tools from SQL 2000 Server CD in order to manage it with UI.

     

    1) About OSQL

     

    SQL Server 2000 Desktop Engine (MSDE 2000) does not have its own user interface as it is primarily designed to run in the background. Users interact with MSDE 2000 through the application in which it is embedded. The OSQL Utility is the only tool which is included with MSDE 2000. OSQL allows you to enter Transact-SQL statements, system procedures, and script files for maintaining an MSDE 2000 database. For additional information on the OSQL Utility as well as common script samples, please refer to Q325003 How to Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility.

     

    2) About SQL 2000 Client Tools

     

    To install Microsoft SQL Server 2000 Client Tools, do the following steps:

    1. Insert the Microsoft SQL Server 2000 Enterprise Edition CD and click SQL Server 2000 Components.
    2. Click Install Database Server.

      The Microsoft SQL Server 2000 Enterprise Edition setup begins. The InstallShield guides you through the installation. Follow the instructions in the windows. Click Next.

    3. From the Welcome window, read the information and click Next.
    4. From the Computer Name window, click Local Computer and click Next.
    5. From the Installation Selection window, click Create a new instance of SQL Server, or install Client Tools. Click Next.
    6. From the User Information window, type your name and company. Click Next.
    7. From the Software License Agreement window, read the license information. You must accept the license agreement to continue the installation. Click Yes.
    8. From the Installation Definition window, click Client Tools Only. Click Next.
    9. From the Setup window, type your CD key information and click OK.
    10. Your product ID is displayed in the second setup window. Follow the instructions and click OK to continue.
    11. From the Setup Type window, click Next to accept the default values.
    12. From the Select Components window, click Next to accept the default values.
    13. When the Start Copying Files window opens, click Next to continue with the installation.

      If you want to change any parameters, click Back. When you click Back, selections reset back to their default values. If you click Back at any time during the installation, make sure you reselect the values you wanted before clicking Next.

    14. Click Finish on the Setup Complete window.

     

    2008年12月31日 上午 02:11

所有回覆

  • Can use osql to access msde, or install sql client tools.

     

    2008年12月31日 上午 01:27
  • As Rmiao said, MSDE only support OSQL or if you have license on SQL 2000 Server, You may install SQL 2000 Client Tools from SQL 2000 Server CD in order to manage it with UI.

     

    1) About OSQL

     

    SQL Server 2000 Desktop Engine (MSDE 2000) does not have its own user interface as it is primarily designed to run in the background. Users interact with MSDE 2000 through the application in which it is embedded. The OSQL Utility is the only tool which is included with MSDE 2000. OSQL allows you to enter Transact-SQL statements, system procedures, and script files for maintaining an MSDE 2000 database. For additional information on the OSQL Utility as well as common script samples, please refer to Q325003 How to Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility.

     

    2) About SQL 2000 Client Tools

     

    To install Microsoft SQL Server 2000 Client Tools, do the following steps:

    1. Insert the Microsoft SQL Server 2000 Enterprise Edition CD and click SQL Server 2000 Components.
    2. Click Install Database Server.

      The Microsoft SQL Server 2000 Enterprise Edition setup begins. The InstallShield guides you through the installation. Follow the instructions in the windows. Click Next.

    3. From the Welcome window, read the information and click Next.
    4. From the Computer Name window, click Local Computer and click Next.
    5. From the Installation Selection window, click Create a new instance of SQL Server, or install Client Tools. Click Next.
    6. From the User Information window, type your name and company. Click Next.
    7. From the Software License Agreement window, read the license information. You must accept the license agreement to continue the installation. Click Yes.
    8. From the Installation Definition window, click Client Tools Only. Click Next.
    9. From the Setup window, type your CD key information and click OK.
    10. Your product ID is displayed in the second setup window. Follow the instructions and click OK to continue.
    11. From the Setup Type window, click Next to accept the default values.
    12. From the Select Components window, click Next to accept the default values.
    13. When the Start Copying Files window opens, click Next to continue with the installation.

      If you want to change any parameters, click Back. When you click Back, selections reset back to their default values. If you click Back at any time during the installation, make sure you reselect the values you wanted before clicking Next.

    14. Click Finish on the Setup Complete window.

     

    2008年12月31日 上午 02:11
  • Are there any freewares able to manage the database?

     

    Thank you very much!

    2009年1月3日 上午 04:22
  • Microsoft has enterprise manager for msde and ssms for sql2k5 express, they are free to download. 

    2009年1月3日 下午 09:14