Print Page | Close Window

MSDE support?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=249
Printed Date: 06 April 2026 at 10:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: MSDE support?
Posted By: trendecide
Subject: MSDE support?
Date Posted: 17 February 2003 at 10:50am

my understanding is that MSDE is a stripped down version of SQL Server, but it's free.  I'm not too familiar with it, but would it be worth supporting it in v7.0?



-------------
Love, Peace and Chicken Grease!



Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 11:37am
If you mean the desktop version of SQL server then it should be, but I'm not sure if you can connect to it using TCP/IP (mixed mode), which would mean it can't be used as a web backend database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: trendecide
Date Posted: 17 February 2003 at 11:41am

ASP.NET forums use it as an alternative to SQL Server...

http://www.asp.net/Forums/Download/default.aspx?tabindex=1 - http://www.asp.net/Forums/Download/default.aspx?tabindex=1



-------------
Love, Peace and Chicken Grease!


Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 11:50am
Then it should work, just download the SQL server version, and setup the right connection to the database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: michael
Date Posted: 17 February 2003 at 2:54pm
though the forum does not create the database and MSDE does not come with client tools so either get some freeware app to create a db and a user or use osql, is just as good.


Posted By: trendecide
Date Posted: 17 February 2003 at 7:59pm
I'll toy around with it and let you know what I can come up with.

-------------
Love, Peace and Chicken Grease!


Posted By: tmcquinlan
Date Posted: 17 February 2003 at 8:44pm

MSDE was originally offered as a free developers version of SQL but is now often used for desktop apps that are designed for a single user.

The biggest reason you won't want to use it for a discussion forum is that it has an inbuilt maximum of 5 users.  It will allow more users to connect, but performance will be seriously, purposely, degraded over 5.



Posted By: thekiwi
Date Posted: 18 December 2003 at 12:55pm
Originally posted by tmcquinlan tmcquinlan wrote:

MSDE was originally offered as a free developers version of SQL but is now often used for desktop apps that are designed for a single user.

The biggest reason you won't want to use it for a discussion forum is that it has an inbuilt maximum of 5 users.  It will allow more users to connect, but performance will be seriously, purposely, degraded over 5.

http://www.aspfaq.com/show.asp?id=2343 - http://www.aspfaq.com/show.asp?id=2343

Specifically concerning the "concurrent users", the aboive statement is not 100% correct.

"MSDE 2000 allows 32,767 connections to an instance of the database engine. There is no limit for the number of connections that can be executing operations at the same time. The only effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time."

and

"Once it has been activated, the workload governor limits performance by stalling a user connection for a few milliseconds each time the connection requests a logical read or write on any of the pages in the data files of a database"

and

"When the number of active operations is eight or lower, the database engine does not wait before scheduling any reads or writes. When the workload governor is active, it equally affects all connections; it is not limited to slowing down only the connections that activated the governor. The length of the wait implemented by the governor is constant (it does not vary depending on how many operations are active beyond the limit of eight)."

Given that an "operation" will only last milliseconds anyway ... the impact when compared to an access database will be very very minimal.

Id consider MSDE a far better option than an access database



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: Tegwin
Date Posted: 18 December 2003 at 11:31pm

Originally posted by trendecide trendecide wrote:

I'll toy around with it and let you know what I can come up with.

 

For what its worth, I have been using MSDE as a backend for the forum for a while now. It works like a charm...  As was mentioned in an earlier post, you will have to create the database first and then your away

 

 



-------------
If you dont want my peaches, dont shake my tree



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net