mike2
|
| Posted: 09/03/2004, 6:59 AM |
|
hello,
is it possible to run an mdse database with Codecharge??
thanks
kurt
|
|
|
 |
Karsten
Posts: 57
|
| Posted: 09/03/2004, 7:14 AM |
|
i did not try this myself, but normaly you can use any
database wich can be access by an ODBC driver and msde can be connected by an ODBC driver. so it should work.
_________________
If one gives up, he told himself he failed. |
 |
|
DonB
|
| Posted: 09/03/2004, 10:27 AM |
|
Yes. MSDE is the "core" of MS SQL Server, however, with limitations that
you might find unacceptable for a web application. Most significantly, it
limits the number of concurrent connections to 5. Beyond these factors, you
can treat MSDE as if it is SQL Server.
--
DonB
http://www.gotodon.com/ccbth
"mike2" <mike2@forum.codecharge> wrote in message
news:2413878e1b9827@news.codecharge.com...
> hello,
> is it possible to run an mdse database with Codecharge??
> thanks
> kurt
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/03/2004, 10:43 AM |
|
Minor correction: I recently had to look this up and I think that MSDE allows 25 concurrent users (connections), per http://www.microsoft.com/sql/evaluation/overview/default.asp
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonB
|
| Posted: 09/03/2004, 10:10 PM |
|
Hmmm, who do we believe  ?
http://msdn.microsoft.com/library/?url=/library/en-us/a....asp?frame=true
The good news is that the SQL Server Express (that will appear soon) has no
connection limitation/degradation mechanism whatsoever.
--
DonB
http://www.gotodon.com/ccbth
"peterr" <peterr@forum.codecharge> wrote in message
news:24138ad4c5cb77@news.codecharge.com...
> Minor correction: I recently had to look this up and I think that MSDE
allows 25
> concurrent users (connections), per
> http://www.microsoft.com/sql/evaluation/overview/default.asp
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> Warning: I use Google
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Karsten
Posts: 57
|
| Posted: 09/03/2004, 10:22 PM |
|
i would NEVER jail myself into M$ , especially if it comes to
decent things like DATA
mysql rules*g
_________________
If one gives up, he told himself he failed. |
|
|
|
BlinkyBill
Posts: 86
|
| Posted: 09/03/2004, 11:44 PM |
|
Quote Karsten:
i would NEVER jail myself into M$ , especially if it comes to
decent things like DATA
mysql rules*g
While I don't want to get into a holly war ove this. Statements like are just ill-informed. Comparing mysql to sql server is like comparing a volkswagen beetle to a mack truck. Sql Server supports grown up things like, stored procs, user defined functions, triggers, constraints, replication, etl functions etc etc. MySQL while suited to the small to medium end of the market does not yet have the features most of the big boys want. Most will just use Sql Server or Oracle on larger projects.
|
|
|
|
BlinkyBill
Posts: 86
|
| Posted: 09/03/2004, 11:47 PM |
|
Quote DonB:
This is the "query governor" in action, it is an artificial restriction in place to "encourage" customers to buy Sql Server. I believe Sql Server Express may not be licenced for production use, only for development purposes. It may be worth looking this up. Also the query governor can be "turned off". You will need to search this info, but it can definatgely be done.
|
|
|
|
DonB
|
| Posted: 09/04/2004, 10:04 AM |
|
I find it hard to take anyone seriously when they must resort to the cliched
"M$" symbol to make a point. Buy if you like, don't buy if you don't.
There have never been any thugs at my doorstep forcing me to purchase a
Microsoft product.
Until mySQL can get around to providing triggers, ref integrity, views,
stored procedures, transactions, job scheduling and data transformation
services, there will be a very conspicuous place for SQL Server in many
applications. Therein lies the problem with free software - it evolves at
the leisure and convenience of those writing it. In truth, Postgres is way
more advanced than mySQL, and it's free as well.
--
DonB
http://www.gotodon.com/ccbth
"Karsten" <Karsten@forum.codecharge> wrote in message
news:24139511c99c15@news.codecharge.com...
> i would NEVER jail myself into M$ , especially if it comes to
> decent things like DATA
> mysql rules*g
>
>
> _________________
> If one gives up, he told himself he failed.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
DonB
|
| Posted: 09/04/2004, 10:06 AM |
|
and the other good news is the web-based admin tool!
--
DonB
http://www.gotodon.com/ccbth
"BlinkyBill" <BlinkyBill@forum.codecharge> wrote in message
news:24139651f99d56@news.codecharge.com...
> Quote DonB:
>
> This is the "query governor" in action, it is an artificial restriction in
> place to "encourage" customers to buy Sql Server. I believe Sql Server
Express
> may not be licenced for production use, only for development purposes. It
may
> be worth looking this up. Also the query governor can be "turned off". You
will
> need to search this info, but it can definatgely be done.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
glerma
Posts: 56
|
| Posted: 09/04/2004, 12:23 PM |
|
Don't forget that there is a 2GB data file-size limitation for MSDE. Once you get to that limit, you must install the SQL Server enterprise edition (licensed) to go beyond it.
|
|
|
|
BlinkyBill
Posts: 86
|
| Posted: 09/05/2004, 6:06 AM |
|
Quote glerma:
Don't forget that there is a 2GB data file-size limitation for MSDE. Once you get to that limit, you must install the SQL Server enterprise edition (licensed) to go beyond it.
SQL Server 2000 Standard Edition will be fine and alot cheaper than Enterprise Edition.
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 09/07/2004, 4:52 PM |
|
Karsten,
You amaze me. While you obviously hate MS and everything they stand for:
1. They rule the desktop
2. Their technical support is second to none in the business
3. They get a bad security rap - most of the security issues are because of
incompetent people in charge of running the servers
You can't compare MS SQL to MySQL. Don't get me wrong - I use MySQL and
love it - but it is essntially an SQL interpreter over ISAM. I cannot come
close to doing the things I do in SQL Server with MySQL. If the problem is
one of $$$ (and, BTW, MySQL is no longer free!), there are other free
databases available which have a richer featureset than MySQL. PostgreSQL
and Firebird come to mind.
|
|
|
|
Karsten
Posts: 57
|
| Posted: 09/07/2004, 11:40 PM |
|
Benjamin,
1. i dont hate MS and everything they stand for.
2. i wont, neighter i did compare MS SQL <-> MySQL
3. i use MySQL because i never had a problem with it, with MS SQL i had much problems in the past
4. i think most users use microsoft products because of the easier use
(any little noob can start and "use" MS Access for example), thats GOOD
so they stay on their side and i stay on my side.
have a nice day
Karsten from germany
_________________
If one gives up, he told himself he failed. |
|
|
|
|
