I've heard of some "new" database solution from Microsoft, designed for
developers. I thought it was called "MS DB" or "DEV DB". I also heard it
sells from Microsoft for around $50.

I've heard it supports the big databases (SQL Server). I'm curious if it
also supports any smaller (cheaper) databases?

My questions:
1) Anyone know where I can get this?
2) What database does it support?

Dan Baker

Thank you. That is what I have heard of, and was looking for.

I'm curious if I can use this in my small office application, but NOT
require my clients to purchase SQL Server?
Does the Developer Edition support other smaller databases? If so, what are
the database solutions available to my end users?

Dan Baker


"Cindy Winegarden" <cindy.winegarden (AT) mvps (DOT) org> wrote

Hi Dan,

As I understand it, the Developer Edition is for development and testing
only - it's for you to use while you develop your application.

For a small office (not many users, not much data) look at Microsoft Desktop
Engine (MSDE). It's optimized for 5 "active" users and is limited to 2GB of
data per database (you can have more than one database). For more see
http://www.microsoft.com/sql/msde/default.asp and
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (AT) mvps (DOT) org, www.cindywinegarden.com

"Dan Baker" <danbaker (AT) efilecabinet (DOT) com> wrote

Dan,
The developer edition itself is only licensed for a single developer.

You can "ship" the MSDE (Microsoft SQL Server Desktop Engine) with you app.

http://www.microsoft.com/sql/msde/

The basic difference being the Developer edition includes developer tools
(Enterprise Manager, Query Manager) while the MSDE does not include these
tools.

In either case you are limited to something like 5 simultaneous connects.
With the disconnected nature of ADP.NET this should not be an issue for most
..NET apps.

Hope this helps
Jay

"Dan Baker" <danbaker (AT) efilecabinet (DOT) com> wrote

I found my log files. Here is a snippet of the problem (cnfgsvr.out) :
################################################## ##########################
###
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=MYMACHINE\VSDOTNET;UID=sa;PWD=;data base=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
################################################## ##########################
###
################################################## ##########################
###
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=MYMACHINE\VSDOTNET;UID=sa;PWD=;data base=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
################################################## ##########################
###
It appears to have installed at:
C:\Program Files\Microsoft SQL Server\MSSQL$VSDOTNET\
the ..\Data folder has tempdb.mdf and templog.ldf
I'm wondering if I need a master.mdf file?

Other ideas of why this baby won't install ?
DanB


"Dan Baker" <danbaker (AT) efilecabinet (DOT) com> wrote

Hi Jay,

According to http://www.microsoft.com/sql/msde/pr...o/features.asp, "It
has a managed concurrency workload governor that limits up to five
concurrent batch workloads for optimal performance ..." which I take to mean
any number of "idle" users and up to 5 "busy" ones. Ultimately, after the
6th user becomes "busy" the app will slow down, but the user won't be
refused. I know people who have 30 users using an MSDE app.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (AT) mvps (DOT) org, www.cindywinegarden.com

"Jay B. Harlow [MVP - Outlook]" <Jay_Harlow (AT) email (DOT) msn.com> wrote

Cindy,
That is effectively what I meant. I did not say it well. Thanks for
clarifying.

Jay

"Cindy Winegarden" <cindy.winegarden (AT) mvps (DOT) org> wrote