Slashdot Log In
Vista Not Compatible With SQL Server
Posted by
CowboyNeal
on Sat Dec 16, 2006 11:31 AM
from the some-extra-patience-required dept.
from the some-extra-patience-required dept.
kiran_n sent in an article by Fortune's Owen Thomas on Vista not being compatible with SQL Server. An excerpt:
"But now Microsoft has a problem. Vista, its long-awaited update to the Windows operating system, can't run the current version of SQL Server. The company is working on a SQL upgrade that is compatible with Vista — called SQL Server 2005 Express Service Pack 2 — but it's in beta and can be licensed only for testing purposes. Microsoft hasn't set a release date for the new SQL program."
This discussion has been archived.
No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Full
Abbreviated
Hidden
Loading... please wait.
Oh NO! (Score:5, Funny)
If anybody... (Score:5, Insightful)
In other breaking news, Oracle does not work with Red Hat Enterprise Linux V.5.
Re: (Score:2)
Much better if other than Micsrosoft's anything.
Re:If anybody... (Score:5, Insightful)
Parent
Re:If anybody... (Score:5, Funny)
Why can't everybody just get along?
Parent
Re:If anybody... (Score:5, Funny)
Hi, you must be new here. Welcome to Slashdot!
Parent
Re:If anybody... (Score:4, Interesting)
Of course the old rule applies - never install version 1 of anything. The last beta was so poor I haven't even be able to bring myself to install the RTM on the test machine dedicated to it... and there's no customer demand yet (takes about a year to filter through normally. Just starting to get Solaris 10 interest for example).
Parent
Other Software (Score:5, Insightful)
Re: (Score:3, Interesting)
The unfortunate problem is what kind of consequences can actually be "given" to Microsoft?
From a buisness perspective, if you stop using Microsoft's operating system you'll have dozens (or possibly hundreds) of applications which are either not supported or not functional on Linux/Unix/OSX; these applications represent Millions of dollars in licences or development that would have to be re-spent imm
Re: (Score:3, Insightful)
While I appreciate your concern, the situation is much more complicated than you present it. First of all, there is no need to spend millions of dollars _immediately_; with a lot of softw
actually far worse (Score:5, Informative)
Good thing there is windows server 2003 still.
Re: (Score:3, Informative)
This is knows as the transfer tables hell. example 1 [google.com]
another thread [google.com]
and so on. Just go on google groups and you will see tons of people on the microsoft newsgroups why have been screwed over.
If you have figured out how to change the query that it performs, please let the rest of us
Re:actually far worse (Score:4, Insightful)
For the most part SSIS is a huge improvement over DTS, it is also much more scalable, and now has it's own dedicated runtime. Components for SSIS are also C# components as opposed to com components under DTS. Theoretically if you code is written well, you can reuse parts of it inside a 2005 DB with the CLR enabled.
"Horribly broken" is really a rather exagerated claim. No one's software is perfect.
Also, it's rather rude to call individuals "liars" when you don't have any evidence that that individual is in fact lying.
Parent
Re: (Score:3)
Re: (Score:3, Informative)
Backwards compatibility (Score:2, Insightful)
This is expected (Score:4, Insightful)
Think of it: Did anyone of you expect the current version of SQL Server to simply play nice with the "new and improved" Microsoft Vista OS, with all enhancements, bell and whistles? Heck, these "enhancements" took more than 5 years to implement! Way more time than was planned. Give me a break!
Misleading Article (Score:5, Interesting)
The article implies (and pretty much states) that Vista doesn't work with SQL server, implying that your client/server programs that depend on SQL Server won't work on Vista. They may in fact *not* work, but it has nothing to do with SQL Server!!!
The article is written by someone that doesn't know what they're talking about, or they DO know what they're talking about and they wanted to get readers and ad-clicks.
Re: (Score:3, Informative)
FUD at its best (Score:4, Insightful)
Second, Vista is NOT RELEASED YET. Despite that, early adopters can download SQL Server Express SP1, which runs fine on Vista, although it is not technically "supported" by Microsoft. In fact, almost all of the issues are easily worked around by running the setup as admin, and SQL Server Management Studio as admin.
For those people who have additional problems, there is plenty of good documentation [msdn.com] on how to get it running, or they can install the beta of SP2, which should be RTM by the time Vista hits the shelves in the end of Jan anyway.
So despite the author's obvious attempts at a sensational title that would get him lots of hits (and, evidentially, posted on Slashdot), his content is almost pure FUD... and pure gold for Slashdot.
Re:FUD at its best (Score:4, Informative)
Bet on. One of the most idiotic ever.
See:
Wrong, it was compatible. It is not meant to be used on that - on a poroduction environment, but it is compatible, and a good reason to install it on XP is development. Like having a SQL Server avaialble on your laptop.
Bullshit. Serious. Vista was RTM what - three weeks ago? It is even avaialble in a boxed vervion in shops already in limited distribution (i.e. in SOME shops, wide availability is in january). Companies / developers have download access ot the gold/rtm master code for weeks - like my company is rolling out Vista business between christmas and new year on all desktops, and is inthe middle of testing that.
Check your facts. Idiotic statements like yours make open source look bad.
Parent
Re:FUD at its best (Score:4, Insightful)
Parent
Just for clarification (Score:4, Informative)
Lame (Score:5, Insightful)
What's funny is there are already numerous comments here, but apparently NONE of those judging and commenting have actually tried what the article seems to be talking about. MSSQL Server 2000 and 2005 run *just fine* under Vista. There may be some minor compatibility problems and yes, the installer warns of these, but you can click right through that. Maybe some issues crop up if you tried to use it as a full fledged server solution as is, but for development purposed they work *just fine*.
Plus, this article is talking about MSSQL Server 2005 Express, which is the local, chopped up locked down version. The rest of the versions work just fine, plus there will be, soon enough, updates to increase the compatibility.
Please keep this kind of crap off Slashdot. It's fine to love OS and hate MS. But at least get your facts *sort of* straight. This is just way off the mark.
Re:Lame (Score:5, Insightful)
Parent
SQL Express vs SQL Server (Score:5, Insightful)
Why use SQL express? It's more stable and more flexible than just using ODBC to connect to an Access database file. Plus you can use all other features that you can not use in Access. It's also the defacto standard for Visual Studio 2005 developers so it gets a lot of use now adays in development. It's also far easier to use than installing the clients for Oracle or MySQL and reduces your program's foot print. (1.2MB vs 35 MB)
I actually use this, and when testing Vista didn't run into a single problem with it in it's current state. (It installed and ran fine under Beta 1 and 2 although it warned you that it could be unstable, it seems in RC and RTM they actually added it to the "Can't install" list)
And there's more than one way to connect to a database, SQL express isnt' the primary route, so the article is being VERY presumptious about impact on the industry. It's not writen by someone who knows the difference between SQL server (The server app that runs on Windows Server 2000, 2003 and uses a client program to handle the connections to a server) and the SQLExpress App (For use in stand alone programs and development environments and will not allow connections from any machine other than the host machine)
It's also amazing that the author of the article thought that you wouldn't test seperately on both platforms. He makes it sound like having to test on Xp then on Vista is a bad thing. Honestly, if you arn't testing on both and on Windows 2000, you're not doing your job right.
Is it important? Yes, it sucks to have apps that I was testing under Vista Beta 1, that I can no longer test because of the "no-install" flag. But SP to the rescue!
As for using Oracle vs MS-SQL, which is the bigger point. Well. having to deal with both at work I can tell you, MS-SQL is far easier to maintain and manage and back up. Oracle still has far too many legacy items in 9i and 10 that require "special" treatment. Not to mention that it's error reporting system is pointless 90% of the time, and we have to hand step everything we do to figure out why we're getting an error instead of a single error message that says, "OCA-XXXXX: Column can not hold data" instead of "ORA-XXX: 'DOCNAME' is too long for column." You can imagine what a pain Oracle is when you've got an SQL statement that a page long. I won't even go into how unfriendly Oracle's support is. Half the time you ask them for help the answer is "If you were an Oracle trained admin you'ld know that." How about, "If you put it in the manual, I'd already know that. Or if your people would reply to emails without the snotty tone I'd know that." Ug...
Sorry about the rant, enjoy!
Ironic (Score:4, Interesting)
Latest news! (Score:3, Funny)
Later it has also been announced that the Sun is hot. We're waiting for more breaking news...
Re: (Score:3, Informative)
Re:I can't help but wonder... (Score:4, Informative)
Parent
Re:I can't help but wonder... (Score:5, Funny)
Parent
Re:I can't help but wonder... (Score:5, Informative)
With all due respect, RTFA:
Parent
Re:I can't help but wonder... (Score:4, Interesting)
Indeed. And perhaps the real question: Why the hell should we care about the compatability virtues of a workstation SQL server?
Parent
Re:I can't help but wonder... (Score:4, Insightful)
How about because if you were developing code for me, and I found you testing your code against the production database on a real server, you'd be out the door so fast your head would spin?
(Though TBH I wouldn't give you access to the production database anyhow, but that's by the by.)
Parent
Re: (Score:3, Insightful)
This is why people have QA servers to test against. I certainly hope, for the sake of your company, you don't just test against your workstation and then place it in production. LOL.
Re:I can't help but wonder... (Score:5, Interesting)
I'd be very surprised if anyone can make a business case for "upgrading" to Vista. Other than a small handful of situations, I can't imagine it would be worth the trouble.
Parent
Re:I can't help but wonder... (Score:5, Funny)
Parent
Re:I can't help but wonder... (Score:5, Funny)
Parent
Re:I can't help but wonder... (Score:5, Informative)
Parent
Re:I can't help but wonder... (Score:4, Informative)
Parent
Re:I can't help but wonder... (Score:4, Informative)
Parent
Re:I can't help but wonder... (Score:4, Insightful)
Parent
Re:I can't help but wonder... (Score:5, Insightful)
I'd agree except that most boxen now use some sort of GUI for the admins, though the older and more experienced admins still live in command shells and scripting (automation!)
But the question of what constitutes a "server" is normally a question of hardware capacity, not artificial restrictions imposed by multi-layer bundling. The prices for AIX, HP-UX, Solaris, Oracle, Sybase, etc. (i.e. both OS and core services) are based on CPU capacity, number of users, and other metrics that have nothing to do with some vague concept of server vs. client. (Plus X-11 and related display technologies reverse the terms anyhow, so they really have no meaning. I prefer digraphs -- data/command comes from here and goes there.)
The add-on modules for most operating systems and products are feature add-ons -- GIS data type package, enhanced application integration/administration packages, developer/compiler package, etc. The only operating system I know of that clips out all the shell scripting, scheduling services, and other components needed to do real work is Windows.
There are no "desktop" or "home" editions of Linux, Solaris, HP-UX, AIX, VM/MVS, AS400, or other systems because the concept is irrational. You run the same binaries on a two-way HP-UX desktop as on an 8-32 way SMP server. It's just minor configuration variables that change to tune performance; Microsoft is the only one to try to make you pay for those tweaks.
Or you can download a package that will apply the registry changes and make your desktop act like a "server". To me that just highlights the inanity of the marketting distinctions.
Parent
Re:I can't help but wonder... (Score:4, Funny)
I applaud your clarity of reason, sir!
"Normally, your boss pays you, but when you buy him a Christmas present, you're effectively paying him. So you can see that this whole 'employee' thing is pretty meaningless."
"Cheap, unpowered speakers normally emit sound, but if you plug them into the microphone jack, you'll be able to record. It just goes to show you what a bourgeoisie lie this so-called 'stereo equipment' is."
"I flew from New York to LA last week. Now I'm flying back, so as you can see names of cities have no meaning."
Oh, I see -- you don't like words that describe things that are different at some times than they are at others. You'd rather use digraphs [wikipedia.org]. Now I understand.
"I connected to the mail Ph using my work Oo instead of the Ee I use at home."
Parent
Re:I believe... (Score:5, Funny)
Pronunciation: 'I-r&-nE also 'I(-&)r-nE
Function: noun
1 : a pretense of ignorance and of willingness to learn from another assumed in order to make the other's false conceptions conspicuous by adroit questioning -- called also Socratic irony
2 a : the use of words to express something other than and especially the opposite of the literal meaning b : a usually humorous or sardonic literary style or form characterized by irony c : an ironic expression or utterance
3 a (1) : incongruity between the actual result of a sequence of events and the normal or expected result (2) : an event or result marked by such incongruity b : incongruity between a situation developed in a drama and the accompanying words or actions that is understood by the audience but not by the characters in the play -- called also dramatic irony, tragic irony
Nope, doesn't look like irony to me. Irony would be if this problem was discovered while trying to upgrade Microsoft's own servers to Vista. This is just poor planning and communication between departments.
Parent
Re:Why? - For development. (Score:4, Informative)
Just not on Vista, it appears.
Parent
Re:Same as the Zune (Score:5, Funny)
Christ, it won't run SQL Server either?
Lame
Parent
Re:Must have really bad code (Score:4, Interesting)
Parent
Re: (Score:3, Insightful)
Uh, no, Windows is not good at backwards compatibility: the entire OS has changed radically over the last 15 years. There are some compatibility hacks, but old software does not work well on newer versions of Windows.
In contrast, 20 year old UNIX software compiles, runs, and takes full advantage of modern hardware; the APIs have hardly changed because UNIX got them right in the first place. That includes the window system.
You might want to try that sometime, in practice its not so clear cut on the UNIX side. And yes, I have experience in this area.
Re:I am running SQL Server Standard 64 bit (Score:4, Interesting)
There are numerous clues which may indicate Jet deprecation:
1. Jet is not ported to x64 platform, and probably will never be, according to MS devs.
You can only install 32-bit Jet 4.0 SP8 on an x64-based Windows OS.
Since Jet is an in-process component, it is not possible to use a Jet database in a 64-bit application.
2. Access 2007 uses its own, non-redistributable database back-end, codenamed Ace. Jet databases are supported only for legacy reasons.
3. Jet libraries have been removed from MDAC 2.8 package. You have to install Jet 4.0 separately.
4. Many newer MS articles and whitepapers suggest using SQL Server 2005 Express as opposing to Jet, as a superior technology.
Parent