Question about MSDE

[DH]

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.

[Arthur Wood]

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.

[DH]

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.
>

[Arthur Wood]

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.
>>
>