Results 1 to 3 of 3

Thread: MSDE versions

  1. #1
    Join Date
    Sep 2002
    Location
    MA
    Posts
    24

    Unanswered: MSDE versions

    Hello all,


    Access 2000 comes with version 1 of MSDE, whereas MSDE 2 shipped with Access XP. Most of my clients have access 2000, and I have been unable to find any documentation on weather an Access 2000 project can be used MSDE 2. If so is there any benefit in doing so? I do plan to move over to SQL 2000 Server in a few months and would like the ease that move as much as possible.

    Thanks in advance!

    Tim

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150

    Re: MSDE versions

    Access 2000 should work on any version of MSDE as MSDE is a cut down version of SQL Server. Access sees MSDE as an SQL Server.

    I would suggest installing MSDE 2 on a machine and trying to create a project in Access 2000

    Machado

  3. #3
    Join Date
    Sep 2002
    Location
    MA
    Posts
    24
    Thanks for your response Machado,

    After an exhaustive search of microsoft kb articles, I found some interesting facts (thought you and other forum visitors might be interested).

    MSDE 2000 can be used with Office 2000 however make note of the licensing here

    http://www.microsoft.com/sql/howtobu...=en-us&gssnb=1

    MS did make some changes to MSDE 2000 that should be noted however. The install now defaults to TCP/IP instead of named pipes as the default network library. MSDE shipped with MDAC 2.6 which includes a new version of the DBNETLIB protocol. This new version allows connections to SQL Server 6.5, 7.0, or 2000 and supports named instances. Consequently, clients with older versions of MDAC (ie 2.5) will not be able to connect to an installation of MSDE 2000 installed with the default settings.

    Solutions:
    All workstations would need MDAC to be upgraded.(If Office XP not installed, any Windows desktop before Windows 2000 SP3)
    OR
    you can change the install to use named pipes
    OR
    you can configure the server to use a fixed port number and alias

    The following article contains some interesting performance testing on named pipes verse TCP/IP
    http://archive.infoworld.com/article...1126tcmdac.xml

    Configuring SQL Server 2000 Desktop Engine
    http://support.microsoft.com/default...;EN-US;Q301413

    How to Connect to an SQL Server 2000 Named Instance with the Previous Version's Client Tools
    http://support.microsoft.com/default...;en-us;q265808


    Hope this info svaes others the five hours I spent researching the subject.

    TY

    Tim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •