If only one computer/login accesses the SQL server, can i get away with using a CAL or do I need a CPU liscense?

OK, so if my web server is the only one computer accessing the SQL server and even though the web server runs queries for everybody on the net, it would only take one CAL, and I could just buy the min CAL package available?

vdub wrote: Can you host the SQL server with linux and the forum on 2k. MS is stupid to charge so much. I just orderd RedHad 9 I don't give it that much longer before Linux takes MS over becuse of there high pricing. As soon as people find out linux works just as well in a server advirment if not better and its FREE!!!!!!!!

SQL Server does not run on Linux, and Linux will never take over MS because first off it is not a product by itself, it is an open source project, Red hat is just one of many. Besides though, I don't think SQL Server is so much overpriced. Can you imagine the manpower, research and time involved in producing a product like SQL server? And you can't so much go by the shelf price anyway. It is just a small percentage that pays that anyway. Companies that have hundreds of clustered SQL servers do not pay the price you see on a shelf, e.g. my companies mother company is a MS certified partner. We pay under $100 for a copy of SQL plus the individual user licences. Now compare the price with other Database Systems. Oracle, way way outta there (Not talking about Total cost of Ownership here). Pervasive SQL is not that ceap either.
So personally I think it is not overpriced, also it was never made for individuals (well you could always buy a Personal Edition for $1200 or so)

vdub wrote: I don't give it that much longer before Linux takes MS over becuse of there high pricing

vdub wrote: hey how many posts before i am no longer a Groupie

Perhaps when you stop making ridiculous comments!

If Linux ever challenges Microsoft for dominance in anything software-related, they will simply drop their prices.  I will agree with you vdub, some of what they charge is outrageous, but they arent even close to the worst out there.  I was looking into purchasing 3d Studio Max 5.0 recently until I saw the price on it -  $3500.  Now that's crazy, especially when I can pirate it for absolutely free.  Pirating, may I add, is also part of the reason for the high price in software.  Everyone wants software for free, never paying a penny for anything.  Look at what happened to Napster? It was the biggest and best thing to ever hit the 'net until they were forced to start charging a very minimal fee to download songs.  Now they are in bankruptcy court because users wouldnt pay $2.99 a month.  

People are cheap - that's part of the reason they use Linux in the first place - it's free.  However Microsoft is here to stay, no matter what you, me, or even supreme court justices have to say about it.  There are way too many absolutely brilliant programmers, cunning lawyers, and cut-throat businessmen employed by that company to ever see another company rival them.

Damn I got off course, didnt i? haha

Blade  

Linux ist the No.2 Server Operating System behind Windows NT, it never ever outran Windows yet. It did that only counting web servers but not servers in general. why RedHat will probably not grow as fast, smaller software companies that make almost 47% of the Home user Software Marketshare are hesitant to develop software for Linux, therefore it will take time for Linux to have a Software base attractive to the normal home user.
Linix a.k.a. Unix is older then windows yes, but in the beginning (I don't know how old you are so if you remember) it was a pain to use. So nothing for Johnny Normal. Even MS DOS back then was easier to use, this is why Microsoft outgrew Linux in the Desktop market, now they are holding 95% of the Desktop Marketshare and you are telling me that is changing soon, I doubt it. Don't get me wrong, I would love for a competitor to get into MS' rank, because competition makes stuff better. But it will take a long time before somebody will be able to stand up next to Microsoft.
You remark about CPU license, well it is a tough subject, it actually comes cheaper in some cases but I agree in a lot of cases it helped out see web hosting. Nevertheless compare SQL Server to Oracle and on a Server with 8 CPU's:
Oracle 9i Enterprise   SQL 2000Enterprise Ed.
$320,000                 $159,992                      
$480,000                 $159,992                       'Using Data Mining
       Now the Standard Editions
$120,000                 $39,992

There you see comparing to just the main competitor it is much "cheaper". Hey I know, it is a lot of cash and yes it ptobably should be cheaper but hey, everybody is doing it and I think MS is just being attacked so much cause it is Microsoft.

To your last point though....
If you can prove me that you can install Microsoft SQL Server 7 or 2000 onto a Linux Operating System (Not Windows for Linux). I buy you a year of Web Wiz Hosting.

vdub wrote: ok that was rude.

I agree with you on that.

Bunce, you are an idiot. Shut up. You flame everyone.

boy

Is it possible to order or download a beta version SQL?

Boy

vdub,

you might be mistaken for MySQL Server, which is different from SQL Server.  MySQL Server comes with redhat.

Look, we don't mean to be rude, but I suggest you do some research and try to understand the topics you are talking about before you make these overarching statements about software applications and platforms.

Hopefully these will start you off:
* SQL is not a database.
* NO programs act as SQL Server except SQL Server.

i think borg has said MySQL work very differently from SQL Server. He would have to re-write ENTIRE codes. So No, there's no plan for mysql from borg. You're completely out of luck with WWG stuffs if you don't have MS SQL or Access.  

But fortunately for you, there are equally big communities for ANYTHING you choose. For me, it really comes down to what is available for me (server-wise)  

OMG! You just don't get it do you.

Here's my 5 seconds of research that tells you what is widely known in the Database community.

SQL SERVER DOES NOT RUN ON ON LINUX:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp - http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

Its the FIRST thing I learnt when I sat the MS SSQL Server Administration course.

Could you now please stop harping on about something you are completely wrong about.

In answer to your questions:

• WWF runs on MS Access
• WWF runs on MS SQL Server
• WWF does not currently run on mySQL
• WWF does not currently run on any other DB platforms.
• S.Q.L. stands for Structured Query Language. It is NOT a database.
• SQL Server pricing is not expensive relative to other RDBMS platforms with its features.
• SQL Server recently finished top in numerous performance benchmarks:
  http://www.tpc.org/ - http://www.tpc.org/
  http://www.crn.com/sections/coverstory/coverstory.asp?ArticleID=40277 - http://www.crn.com/sections/coverstory/coverstory.asp?ArticleID=40277

It great that you'd like to fine cheaper alternatives for everyone, but the fact is, WWF runs on those two database platforms ONLY. SO even if by miracle you got SQL Server to work on Linux, you still have to pay for it!!

In the end, you get what you pay for.  Plus, the forum is already free! Unless you want to write a mySQL version of the forum then you are out of luck.

Cheers,
Andrew

Let's give vdub the benefit of doubt.

Is there possibly a program that runs on Linux and emmulates MS SQL? By emmulate I mean: accept connection and querry exactly the way SQL Server does. Then we're in for the money.

I know right off the head that ASP CAN run on linux by chilisoft.

vdub, what you need to convince peepz now is to post a link to that program I said above. Then, we'll see.

cheer. and take it easy, everyone.

Being open minded goes a loooong way

There is no way to 'easily mod the forum'. Once you understand how databases work you'll realise that.

The SQL statements that Borg have used were designed for SQL Server (and Access). They are not currently compatible with mySQL. They need to be rewritten to work in mySQL.  There is NO quick 'function' to do this.

Additionally, the SQL Server version utilises stored procedures. mySQL doesn't even support stored procedures yet! So the functionality that these procedures produce woul need to be converted *back* to inline SQL statements, which would impact on performance.

Now there are some other database platforms that do support stored procedures, however SQL Server stored procedures use a language called T-SQL. Therefore this platform will have to understand T-SQL.

Off the top of my head, the only other DB that supports T-SQL is Sybase, but then they aren't completely compatible. How many hosting companies offer Sybase and how much does it cost?

So in order to do what you are trying to do, which is find another database platform that will support the WWF code, that runs on Linux, means that:

• It must support the dialect of inline SQL statements that Borg uses.
• It must support stored procedures.
• It must understand T-SQL language.
• It must be readily available on web hosting platforms
• It must be cheap.

Don't you think, that just maybe, someone here would know about it already!! Give us some credit.

By all means go ahead and waste your time, but until then, don't make statements such as:

• "I don't give it that much longer before Linux takes MS over becuse of there high pricing. " ...wrong
• "Linux already dominates Microsoft when it comes to servers they hold the biggest percentage of market share" ..wrong
• "Linux was created in 1991 that’s 12 years it has grown about 50X faster then Windows has" ...any source? or made up.
• "Not only dose Linux support ASP" ...wrong. It supports ChilliASP. They are different.
• "And by the way Linux dose support SQL Server" ...wrong. How can Linux support SQL Server when it doesn't run on it!
• "Keep in mind that Linux realy is about 60% faster" ..any source? or made up.
• "as of the last 2 years that I have been using Linux and windows at the same time the only thing that I cant do in Linux that I can in Windows is FP" .. You can't be doing much then. I have Linux installed here at home as well, and having passed my MCP on Administering Win2K Server, there is plenty that Linux cannot do.
• "I have been surfing the web for 6 hours today and I have found a lot of promising options" Then show them! Give us some hope!
• "Keep in mind there are 10 times the amount of Open Source dev. then there are win32." ..Source? or made up

I wish you the best, and hope that you find something that will benefit everyone. I hope this makes it clearer and apologise if my comments were too harsh.

Cheers,
Andrew

Your attitude discredits you.

I am trying to ask for info to maybe better the community and everything that comes out of your mouth is negative.

I have erased my posts because I no longer want to be part of this discussion with you because all you’re doing is trying to act like the dominant know it all and I have more respect for my self to even try to talk anymore about it with you.

If you would open your mind and not your mouth you might be creditable. But all I see you as now is a Dell owning Microsoft lover that wants nothing more then to hold down your peers to make yourself look better.

Its sad that others have to deal with that

Its a pity you felt you had to do that.

However it does proove you either didn't believe the comments you wrote, or you had no basis to back them up. Not once have you responded, answered or even tried to back up any points you made.

Its a shame as I was hoping there were actually merit to the points you made and I was looking forward to seeing them.

Oh well, in the future, please feel free to post your solution should it ever magically appear.

Good luck and best regards,
Andrew

PS. This topic should probably be closed as since he removed his posts there's now no issue that it is covering except his flaming.

No I did it to stop this conversation because we are getting way off base.

The fact is SQL Server cost to much money and I was hoping to start a mind storm to find another idea.

You on the other hand chose to criticize instead of help.

And by the way I am not the reason this topic should be closed. But that’s the one thing I agree with you on. This topic should be closed.

I have listed alternatives.
I have tried to explain to you how databases work.
I have listed performance benchmarks.
I have listed why mySQL isn't compatible with WWF.
I have even listed exactly the features required to help you find what you are looking for.

This is called HELP. It is called INFORMATION. You obviously haven't read any of mine, or other peoples posts, or you are too pig headed to listen. Michael even listed the relative costs involved and the SQL Server is NOT relatively expensive compared to other systems of its type.

Shared hosting of SQL Server is cheap. The forum is already free, yet you continue to bag it. Stop being a cheapskate. You get what you pay for in this world.

And you've offered absolutley nothing helpful whatsoever, except to make uneducated and baseless statements which you then removed, as you realised they were rubbish.

To not even have any confidence in your own opinions, and remove your posts, I'm sorry is pathetic and gutless.

If you wish to continue this conversation, take it off list and PM me. There's no point continuing this sort of crap here and embarassing yourself any more.

Didnt I just say I don't want to get in to this anymore

STOP Trying to antagonize me please.

Will some one please close or delete this to shut him up.