I'm not sure why you would have problems - can you send the actual error
message?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 21, 2000 2:25 PM
To: CF-Talk
Subject: RE: MSDE on Win2K... anyone successfully install it?
Thanks, Jeff. That's the information I was looking for. One more question:
do you have a preferred installation method for MSDE? It's not happening for
us on either 2K or NT (sorry, don't have the exact error here).
-Ron
> Hi Ron,
>
> My sites usually end up running on SQL Server, so when I ca't develop
> directly in SQL Server, developing in MSDE makes sense to me. I
> run MSDE on
> Windows NT Workstation 4.0 at work, and on Win2k Pro at home.
>
> The short answer:
>
> MSDE appears to the developer exactly like SQL Server. It does not come
> with SQL Enterprise Manager, so you'll either have to get a copy
> of that, or
> use MSAccess 2000 as the front end. Using Access, you'll set up a Project
> that connects to the MSDE engine. The nice thing about using
> Access is you
> have the query by example tools, making query development very easy.
>
> MSDE, like SQL Server, requires more planning than an Access database.
> There are more security options, and you have a larger number of
> datatypes,
> etc. For simple, small web sites that don't generate much traffic, Access
> is usually OK. I've written intranets using Access that are hit
> by 10 - 15
> users without problems. Remember that these are not 'concurrent'
> accesses -
> simply concurrent users.
>
> One nice thing about MSAccess is that it's very portable; as long
> as you can
> set up an ODBC source to it, you can use it (on a Win box, of course).
> However, Access is not a prime-time database, so for anything requiring
> multiple concurrent access or any kind of load, don't use it
> unless you have
> no other choice. If you have to interact with any third-party
> data sources,
> applications or other DBs (ex: replication with a SQL Server), don't use
> Access - it's going to be very slow and will put a much heavier
> load on the
> remote server. We always use MSDE for this IF the client doesn't have SQL
> Server or another client-server RDBMS.
>
> Hope this helps!
>
> Jeff
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 8:09 PM
> To: CF-Talk
> Subject: MSDE on Win2K... anyone successfully install it?
>
>
> Just curious... anyone out there successfully running MSDE on Win2K?
>
> If so, pros and cons vs. MSAccess for relatively low-volume sites? Ease of
> administration? Installation?
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
