Question about MSDE


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Question about MSDE

  1. #1
    DH Guest

    Question about MSDE


    Hello all:

    I read "How to use Ms access as a centralized database. It's very instaeresting.


    I want to know from where I can have MSDE. We do have VB6 prograssion. But
    we did not find that the VB6 install indicates a "MSDE" was installed and
    no MSDE driver be found in ODBC(Data sources) after install.

    Where I can have the newest version of MSDE install and how to start it after
    instll.

    Thank very much for you help.

  2. #2
    Arthur Wood Guest

    Re: Question about MSDE


    DH,
    MSDE comes on the Office 2000 install disks. It is a completely separate
    installation, not part of the Office 2000 Installation. On my CDS, it is
    found in the SQL/X86/SETUP folder on DISC 1. Look for SQLSETUP as the Installer
    to use.

    Arthur Wood


    "DH" <nannanhu@aol.com> wrote:
    >
    >Hello all:
    >
    >I read "How to use Ms access as a centralized database. It's very instaeresting.
    >
    >
    >I want to know from where I can have MSDE. We do have VB6 prograssion. But
    >we did not find that the VB6 install indicates a "MSDE" was installed and
    >no MSDE driver be found in ODBC(Data sources) after install.
    >
    >Where I can have the newest version of MSDE install and how to start it

    after
    >instll.
    >
    >Thank very much for you help.



  3. #3
    DH Guest

    Re: Question about MSDE


    Thank you, Arthur.

    We got to install it.

    One more question: How it works with NT 4.0 workstation on Security issue?

    I just read an article "Microsoft Data Engine (MSDE) for Microsoft Visual
    Studio 6.0" from http://msdn.microsoft.com/library/en...asp?fram=true.
    It stated "MSDE database running on Windows NT and Windows 2000 platforms
    are capable of utilizing Windows 2000 - integrated security to protect database
    object."

    We installed MSDE on a NT workstation. If the user of the workstation change
    his/her password to log in later (our company periodical needs a user to
    change their password), can MSDE still work, to start and run, properly?


    If it may not how should we set up the security for MSDE to sync with a user/NT
    workstation?

    Thanks lot for your help.

    DH

    "Arthur Wood" <wooda@nospam.com> wrote:
    >
    >DH,
    > MSDE comes on the Office 2000 install disks. It is a completely separate
    >installation, not part of the Office 2000 Installation. On my CDS, it is
    >found in the SQL/X86/SETUP folder on DISC 1. Look for SQLSETUP as the Installer
    >to use.
    >
    >Arthur Wood
    >
    >
    >"DH" <nannanhu@aol.com> wrote:
    >>
    >>Hello all:
    >>
    >>I read "How to use Ms access as a centralized database. It's very instaeresting.
    >>
    >>
    >>I want to know from where I can have MSDE. We do have VB6 prograssion.

    But
    >>we did not find that the VB6 install indicates a "MSDE" was installed and
    >>no MSDE driver be found in ODBC(Data sources) after install.
    >>
    >>Where I can have the newest version of MSDE install and how to start it

    >after
    >>instll.
    >>
    >>Thank very much for you help.

    >



  4. #4
    Arthur Wood Guest

    Re: Question about MSDE


    When you install MSDE, it is just like a normal installation of SQL Server
    (there is NO Enterprise Manager however, with MSDE), and you can set the
    Security settings at installtion time. By the way, the default account is
    "sa", with a Password of "" (BLANK).

    Arthur Wood


    "DH" <nannanhu@aol.com> wrote:
    >
    >Thank you, Arthur.
    >
    >We got to install it.
    >
    >One more question: How it works with NT 4.0 workstation on Security issue?
    >
    >I just read an article "Microsoft Data Engine (MSDE) for Microsoft Visual
    >Studio 6.0" from http://msdn.microsoft.com/library/en...asp?fram=true.
    >It stated "MSDE database running on Windows NT and Windows 2000 platforms
    >are capable of utilizing Windows 2000 - integrated security to protect database
    >object."
    >
    >We installed MSDE on a NT workstation. If the user of the workstation change
    >his/her password to log in later (our company periodical needs a user to
    >change their password), can MSDE still work, to start and run, properly?
    >
    >
    >If it may not how should we set up the security for MSDE to sync with a

    user/NT
    >workstation?
    >
    >Thanks lot for your help.
    >
    >DH
    >
    >"Arthur Wood" <wooda@nospam.com> wrote:
    >>
    >>DH,
    >> MSDE comes on the Office 2000 install disks. It is a completely separate
    >>installation, not part of the Office 2000 Installation. On my CDS, it

    is
    >>found in the SQL/X86/SETUP folder on DISC 1. Look for SQLSETUP as the

    Installer
    >>to use.
    >>
    >>Arthur Wood
    >>
    >>
    >>"DH" <nannanhu@aol.com> wrote:
    >>>
    >>>Hello all:
    >>>
    >>>I read "How to use Ms access as a centralized database. It's very instaeresting.
    >>>
    >>>
    >>>I want to know from where I can have MSDE. We do have VB6 prograssion.

    >But
    >>>we did not find that the VB6 install indicates a "MSDE" was installed

    and
    >>>no MSDE driver be found in ODBC(Data sources) after install.
    >>>
    >>>Where I can have the newest version of MSDE install and how to start it

    >>after
    >>>instll.
    >>>
    >>>Thank very much for you help.

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center