Showing posts with label Windows Vista. Show all posts
Showing posts with label Windows Vista. Show all posts

Saturday, April 21, 2007

Installing Orcas Beta 1 from the 5.32 GB ISO Image

Conventional single-layer DVD-R/RW and DVD+R/RW discs hold 4.7 GB. So unless you have a double-layer DVD burner and media, you won't be able to run the 5.32-GB Visual Studio Orcas Beta1 Setup program from a physical DVD.
Setup fails before completion of .NET Fx 3.5 when run from a networked drive. Believe Setup's Start Page where it says:
Some components require that network connections be temporarily suspended during setup.

Click for full-size image.

If you try installing from a network drive, which includes third-party apps that mount ISO images to virtual CD or DVD drives, you might experience what appears to be a non-fatal timeout message while Setup is copying its initial set of files. Even if not, you'll undoubtedly see this message during the installation of .NET Fx 3.5:

and end up with this screen when installation fails:

Click for full-size image.

This means that your double-layer DVD burner must be local to the machine on which you want to install Beta 1. Virtual machines connect to the host OS's physical drives as networked drives, so you're out of luck if you want to install Orcas Beta 1 on Vista as a guest OS.

The Solution

Use Daemon Tools' free Virtual Daemon Manager (VDM) to mount the en_visual_studio_orcas_beta_1_professional_dvd_23591.iso image file to a virtual DVD drive. The current VDM version (4.09) works fine under Windows Vista as a host or guest OS, despite what you might have heard on the Web.

Note: When you install VDM on virtualized Vista, save and run the setup file. You must reboot to finish VDM's installation. Under Virtual Server 2005 R2 RC1 with Vista as the guest OS, you must explicitly run daemon4091-x86.exe a second time to complete the installation after rebooting.

Update: 4/24/2007: Commenters have suggested using WinRAR or IsoBuster to extract the image to executable files. WinRAR isn't free (it has a 40-day trial license) and IsoBuster requires the PRO version ($29.95 personal, $49.95 professional) to open an image of this size. Some commenters have suggested other virtual DVD drive apps, but VDM is free and has proven itself under Vista.

Tuesday, March 06, 2007

Orcas March CTP on Vista Database Connections Problem Solved

An anonymous commenter provided the solution to the connection string problem I reported in my March 04, 2007 Orcas March 2007 CTP Installation Problems post: If you set up the Self-Extracting Install version of the Orcas March 2007 CTP on Windows Vista without installing SQL Server 2005 Express, you can't persist Data Connections in Server Explorer. Installing SQL Server 2005 [Express] under any current Windows OS breaks the Project Designer's Properties page and the Workflow Designer. Update 4/25/2007: This fix does not apply to Orcas Beta 1, which doesn't exhibit the preceding problems. See SQL Server Compact Edition FAILS to connect in Server Explorer with Beta 1 in the ADO.NET Orcas forum. Update 3/7/2007: Windows Vista isn't the culprit. "Anonymous" says that the connection string problem also occurs with—and the solution works for—Windows XP SP2. My installation on Windows Server 2003 R2 SP1 under Virtual Server 2005 R2 SP1 Beta 2 didn't have the problem. Inspecting that machine.config file shows that the offending line commented out below wasn't present. I believe I omitted Orcas support for devices from that install. I'll run another test with Windows XP SP2 as the guest OS later this week to confirm. Here's the full text of the comment:

The issue with SQL Connection strings is much larger than what you elude to. It also breaks almost all visual database design tools in Orcas, SQL Server Management Studio and Visual Studio 2005. This includes the table designer, database diagrammer and the view designer.

I have good news though. There is a fix. If you open up the machine.config file you will notice multiple entries for the SQL CE stuff in the system.data section. Comment these out (this will break SQL CE, which is fine for most people) and your SQL Server editing will return. I believe if you comment out 2 of the 3 leaving the version 9 dll intact the SQL CE stuff will remain working.

The commenter is correct. To enable persisting Data Connections in Server Explorer under Windows Vista comment out the line shown in bold from \Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine[.config]:
<system.data>
  <DbProviderFactories>
    <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <!-- <add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Everywhere Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> -->
    <add name="SQL Server Compact Edition Data Provider" invariant="System.Data.SqlServerCe" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
    <add name="SQL Server Compact Edition Client Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server Compact Edition Client" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
  </DbProviderFactories>
</system.data>

The SQL Server CE Data Provider element (for v3.1 disguised as v9.0.242.0) appears to conflict with the SQL Server Compact Edition (SSCE) Data Provider v3.5.0.0, which is the correct version for Orcas March 2007 CTP, when running under Windows Vista. Version 3.5 supports the Microsoft Synchronization Services (OCS) CTP, has new data types, and other improvements. Note: The machine.config file is present only in the .NET Framework 2.0's CONFIG folder. The other framework folders (1, 1.1, 3.0, and 3.5) don't have a CONFIG folder.

Here's a screen capture of the line to edit in your machine.config file (click for full size image):

And just to prove that the fixes work, here's a screen capture of Server Explorer showing two remote SQL Server 2005 Express instances and a local SQL Server 2005 Compact Edition Test.sdf file created when the connection was made (click for full size image):

Caution: Installing Orcas March 2007 CTP without installing SQL Server 2005 Express (SSX) requires that you change the connection strings for many sample applications, such as those for LINQ to SQL, from local user instances of Northwind.mdf to remote instances of the Northwind sample database. My Updated Orcas March 2007 CTP LINQ C# Samples post provides an example for the Sample Queries project's LinqToSqlSamples class.

Note: Here's a link to an ADO.NET Orcas post from a tester with the problem solved here. Two more confirmations here and here.

Update 3/19/2007: Use Orcas's Server Explorer, not SSMS, to manipulate SSCE data files. Server Explorer's Show Table Data context menu choice lets you edit SSCE table data.

Laxmi Narsimha Rao ORUGANTI from Microsoft India posted the following in the Microsoft Synchronization Services for ADO.NET forum regarding SSCE versioning issues:

With SQL Server 2005 (RTM, SP1, SP2), the version of SQL SERVER COMPACT EDITION integrated with it is 3.0/3.1 (Note: DLL versions would still remain as 3.0.xxxx.0). SQL Server CE 3.5 which is part of ADO.NET Sync Services CTP is not integrated with database management tool SSMS. We would encourage you to use ORCAS to manipulate the Sync Services databases created on client side. SQL Server CE 3.5 is fully integrated with ORCAS. Use Database Explorer (or Server Explorer). We are also working towards to integrate with Orcas Express editions but nothing is concrete or materialized yet so no promises.

Sunday, March 04, 2007

Orcas March 2007 CTP Installation Problems

Project Designer's Properties Pages Are Inoperable Many Orcas March 2007 CTP testers have reported that the Project Designer's Properties pages don't work. A red ball with an X appears and you receive this error for any page you select:

An error occurred trying to load the page. Microsoft.VisualStudio.Shell.WindowPane.OnCreate()

Update 4/25/2007: This fix does not apply to Orcas Beta 1, which doesn't exhibit the preceding problems. See SQL Server Compact Edition FAILS to connect in Server Explorer with Beta 1 in the ADO.NET Orcas forum.

I experienced the same problem with the Self-Extracting Install on Windows Server 2003 R2 and Vista, as well as the VirtualPC Image on Windows Server 2003 SP1, as the guest OS running on Virtual Server 2005 R2. The Visual Studio Code Name “Orcas” Release Notes accessible from the download pages for the Self-Extracting Install and VirtualPC Image (not the Readme that opens when you click the View Readme button of the VS Orcas setup splash screen) states:

19. Working with Project Designer (Project Properties) is unsupported when the CTP is installed on the same machine as VS 2005 or SQL Server 2005.

Project Designer is the feature responsible for configuring application settings, handling application events, managing settings, managing resources, and working with other properties of the project. This feature currently is not supported in the March CTP if the CTP is installed on the same machine (side-by-side) with VS 2005 or SQL Server 2005. This limitation is caused by a known issue in the setup authoring of this component.

To resolve this issue, it is recommended to either:

  • Use the March CTP from a VPC image
  • Install March CTP to a different machine without VS 2005 or SQL Server 2005

This defect was known to Microsoft prior to release of the installation bits, so testers should have been warned about the issue in the download pages and ReadMe file that the setup splash screen's View ReadMe button opens.

The VirtualPC Image includes SQL Server 2005 to support Team Foundation Server; removing the SQL Server components doesn't restore Properties pages operability. You must perform a custom install of the Self-Extracting Install version and clear the SQL Server 2005 Express check box to obtain operable Properties pages.

(SQL Server 2005 Compact Edition components don't cause this problem. Rafik Robeal's four Sync Services projects build and run without issues in Orcas March 2007 under Windows Server 2003 R2 and Vista.)

Note: See Feedback: Project properties Panes not created on Orcas CTP Mars for a similar issue under Vista and Forum: Microsoft.VisualStudio.Shell.WindowPane.OnCreate() for several users experiencing the problem. Side Effects of Not Installing SQL Server 2005 [Express]

1. SQL Server Native Client (Sqlncli) for OLE DB and ODBC connections to SQL Server 2000 and 2005 isn't installed.

You can install the X86, X64, or IA64 Package from links on the Feature Pack for Microsoft SQL Server 2005 - February 2007 page or the X86 package (Sqlncli.msi) directly. 2. You can't persist an SQL Server data connection in the Orcas March Server Explorer when running under Windows Vista.

Update 2/7/2007: This problem has been solved by an anonymous commenter. An extra entry in machine.config for SQL Server 2005 CE v3.1 caused the failure. See the 2/7/2007 Orcas March CTP on Vista Database Connections Problem Solved post.

The Choose Data Source dialog behaves as expected, and selecting Microsoft SQL Server as the Data Source and either .NET Framework Data Provider for SQL Server or OLE DB opens the Add Connection dialog. You can choose a networked instance of SQL Server [Express] in the Server Name list, but the Select or Enter a Database Name list isn't populated with database names. Clicking Test displays the expected (but bogus) message:

If you type a known good database name in the list and then click OK you receive this error message:

Clicking Advanced displays this defective Advanced Properties dialog:

Here's what the Advanced Properties dialog looks like when Orcas March 2007 CTP runs under Windows 2003 Server SP1 or Windows XP SP2:

The same problem occurs when using the dialog to build a connection string from the Properties/Settings page. Typing the approprate connection string in the Settings grid's Values cell doesn't add the required providerName="System.Data.SqlClient" attribute/value pair to the app.config file's <connectionStrings> element. As noted in my earlier Orcas March CTP Available from MSDN post, Windows Vista isn't a supported OS for the Self-Extracting Install version. This problem might explain why. (Vista is a supported OS for the VirtualPC Image version.)

Note: See Feedback: Unable to create data connections in server explorer for another tester with the same problem.

Build Warning about .NET Framework 2.0 update

Building a simple VB project reports in the following warning message:

vbc : warning BC42323: .NET Framework 2.0 update not found. The win32manifest will not be embedded.

The system is using the current version as indicated by this build instruction:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll

Others have reported similar warnings when building C# projects. So far, I haven't found any problems that I can attribute to an outdated .NET Framework 2.0 version.

Note: See Feedback: C# solution upgrade creates error CS1928 for a similar issue and the Properties pages problem.

Thursday, March 01, 2007

Windows Vista Not Supported by Orcas March CTP

Section 1.1 "System Requirements" of the Readme: Microsoft Visual Studio Codename Orcas Setup Issues (Readme.htm) of the Orcas March 2007 CTP's installable setup version contains the following Operating System list:

Visual Studio Codename Orcas can be installed on any of the following systems:

  • Microsoft® Windows® 2000 Professional SP4
  • Microsoft® Windows® 2000 Server SP4
  • Microsoft® Windows® 2000 Advanced Server SP4
  • Microsoft® Windows® 2000 Datacenter Server SP4
  • Microsoft® Windows® XP Professional x64 Edition (WOW)
  • Microsoft® Windows® XP Professional SP2
  • Microsoft® Windows® XP Home Edition SP2
  • Microsoft® Windows® XP Media Center Edition 2002 SP2
  • Microsoft® Windows® XP Media Center Edition 2004 SP2
  • Microsoft® Windows® XP Media Center Edition 2005
  • Microsoft® Windows® XP Tablet PC Edition SP2
  • Microsoft® Windows Server™ 2003, Standard Edition SP1
  • Microsoft® Windows Server™ 2003, Enterprise Edition SP1
  • Microsoft® Windows Server™ 2003, Datacenter Edition SP1
  • Microsoft® Windows Server™ 2003, Web Edition SP1
  • Microsoft® Windows Server™ 2003, Standard x64 Edition (WOW)
  • Microsoft® Windows Server™ 2003, Enterprise x64 Edition (WOW)
  • Microsoft® Windows Server™ 2003, Datacenter x64 Edition (WOW)
  • Microsoft® Windows Server™ 2003 R2, Standard Edition
  • Microsoft® Windows Server™ 2003 R2, Standard x64 Edition (WOW)
  • Microsoft® Windows Server™ 2003 R2, Enterprise Edition
  • Microsoft® Windows Server™ 2003 R2, Enterprise x64 Edition (WOW)
  • Microsoft® Windows Server™ 2003 R2, Datacenter Edition
  • Microsoft® Windows Server™ 2003 R2, Datacenter x64 Edition (WOW)

Installation of Visual Studio Codename Orcas on the Intel Itanium (IA64) is not supported.

As mentioned in the earlier Orcas March CTP Available from MSDN post, lack of Vista support for the self-extracting install is surprising when you consider this post from Somasegar's blog: "Our goal with Orcas is to build the best tool set for Windows Vista ... For the first time, we have a WPF designer in the product, enabling a more complete WPF development experience."

It's fortunate that Windows XP SP2 and Windows Server 2003 [R2] have WPF support.

Tuesday, January 09, 2007

Problem Installing SQLce RC1 on Virtual Windows Vista

I've attempted to install SQL Server Compact Edition RC1 on Windows Vista Ultimate (RTM) running under Virtual Server 2005 R2 SP1 Beta 2 (1.1.531.0 EE R2 SP1) as Administrator. SQLServerEv31-EN.msi (dated 12/19/2006) creates the \Program Files\Microsoft SQL Server Everywhere Edition\v3.1 folder but only adds the System.Data.SqlServerCe.xml file.

None of the sqlce*30.dll runtime files, System.Data.SqlServerCe.dll, or EULA_EN.rtf appear in the ...\v3.1 folder. However, the 3.1 version of System.Data.SqlServerCe.dll appears to install because 1) it's in the GAC and 2) the [DataDirectory] macro works in a connection string. We've tried installing with or without UAC to no avail.

There's no problem running SQLServerEv31-EN.msi with a "concrete" Vista Ultimate instance on an ordinary partition. SQLServerEv31-EN.msi also installs correctly on a virtual Windows Server 2003 R2 instance. In either of these two cases, all expected SQLce files are present and accounted for.

Has anyone else seen this problem? Yes or no, please leave a comment.

Update 1/15/2005: Microsoft says that Virtual Server 2005 R2 isn't a supported platform for SSCE.

Previous posts on SQLce: ADO.NET Sync Framework for Occasionally Connected Systems (11/9/2006) and SQL Server 2005 Compact Edition RC1 Available (11/8/2006)

P.S.: So far, I haven't yet encountered any other issues with SQL Server 2005 Express with Advanced Services SP2 or Visual Studio 2005 SP1 with the Visual Studio 2005 Service Pack 1 Update for Windows Vista Beta running under Virtual Server 2005 R2 SP1 Beta 2.

Wednesday, December 27, 2006

Microsoft Gives Bloggers Sub-Aero (2.8) Laptops

Edelman Public Relations, who's handling PR for Microsoft's Windows Vista Launch, gave Acer Ferrari 1000 and 5000 laptops as Christmas presents to a few A-list and other influential bloggers. San Francisco's Laughing Squid blogger Scott Beale received a free Ferrari 1000 preloaded with Windows Vista Ultimate.

(Image courtesy of IStartedSomething.com)

Scott also published a few photographs of and screen captures from his new laptop. Here's his Control Panel\System screen (cropped and sharpened for legibility):

I was surprised to see a 2.8 Windows Experience Index for a laptop that's intended to show off Windows Vista Premium's virtues, especially a premium (Ferrari), 64-bit dual-core laptop with 1-GB of DDR2 DRAM and a 160GB SATA fixed disk. The way I read the tea leaves, 3.0 is the minimum index rating to run Windows Vista Premium Edition and qualify as Windows Vista Premium Ready. Here's what the Microsoft Windows Vista blog's September 22, 2006 "Windows Experience Index: An In-Depth Look" post says about machines in the 2.0 - 2.9 range (emphasis added):
A base score of 2.0 represents the mainstream Windows Vista upgrade target system. This level of PC may run Windows Aero but users may see noticeable performance issues from time to time, especially on PCs with scores less than 2.5 and/or 64MB of graphics memory. Performance issues may also be noticeable when opening many application windows at the same time or when using very large monitors.
  • PCs will run Windows Vista but in most cases will not be Aero capable.
  • Types: lower end of mid-market desktops. Many slim & light laptops.
Here's the same information for machines within the 3.0 - 3.9 index range (emphasis added):
This level represents the value end of machines that will ship at the end of 2006 and into 2007. This is the lowest capability Windows Premium Logo PC that will ship with Windows Vista™ pre-installed. Windows Vista will generally enable Aero automatically on level 3 machines. Aero will perform quite well on level 3 machines with single monitors. With dual monitors (especially larger than 1280x1024), users may see noticeable performance issues from time to time, especially on machines with scores less than 3.5 and/or 128MB of graphics memory.
  • Minimum specification needed to run Windows Vista Premium features, including the new Aero user interface.
  • Types: value end market desktops. Slim & light laptops + desktop replacement laptops.

The Acer product and Windows Vista support pages say that the F1000 and F5000 are Windows Vista Capable and Windows Vista Premium Ready. (The F1000 is claimed to be Premium Ready if appropriately configured with 1-GB RAM and a DVD-ROM drive.) Microsoft's latest requirements for the these two labels are here.

Based on the preceding Microsoft quotes, however, a 2.8 Experience Index doesn't appear to meet minimum Windows Vista Premium requirements or qualify for shipping with Windows Vista preinstalled.

Update 12/28/2006: Microsoft Watch's Joe Wilcox appears to agree in his "How Much Oomph Does Vista Really Need?" post that a 2.8 Windows Experience Index isn't sufficient to run Windows Vista properly. He says "The stated minimum system requirements are stingy" and provides his recommendations for minimum Windows Vista hardware requirements. He notes that "Microsoft would do better by overstating rather than understating system requirements. It's one thing for the operating system to run and another for it to provide a good experience." Joe's former Jupiter Research colleague Michael Gartenberg disagrees.

Note: You might experience problems opening pages on the Acer site due to loss of submarine fibreoptic cables in Tuesday night's Richter 7.1 undersea earthquake off the coast of Taiwan.

For comparison, here's a capture of the Performance Information and Tools page from my Windows Vista test machine, a Gateway S-5200D with a 2.8-GHz Pentium D (2 cores), 2 GB RAM, an NVIDIA GeForce 6600 GPU with 256 MB RAM, and an 180-GB SATA hard drive:

That's not to say the bloggers who received F1000's got a lump of coal in their stockings. It's just surprising that a PR firm would send laptops with a marginal or worse Windows Experience Index to entice bloggers into promoting reviewing Windows Vista.

Last Updated: 1/4/2006.

Subsequent events: Long Zheng's I Started Something blog reports that some bloggers received Acer Ferrari 5000s. Update 12/27/2006: MSTechToday's Brandon LeBlanc, Barb's Connected World's Barb Bowman, GeekZone's Mauricio Freitas and Zen's HeavenGames have reported receiving an F5000 as of 1:00 pm PST. NotGartner's Mitch Denny got an F1000. Update 12/28/2006: Ed Bott (Windows Expertise) received an F5000, Global Nerdy's Joey deVilla and ProBlogger's Darren Rowse got an F1000, and TechCrunch/CrunchNotes' Mike Arrington and ex-TechCruncher Marshall Kirkpatrick got unidentified models directly from Microsoft Mindshare Program Manager Aaron Coldiron. Robert McLaws at Windows Now says an AMD rep was responsible for his unnumbered Ferrari.

Australia's Sandi Hardmeier (Spyware Sucks and IE-Vista) got her F5000 today (see this blog's comments). Digital Inspiration's Amit Agarwal is awaiting a Ferrari from the DHL warehouse and plans to keep it; ValleyWag's link says that Microsoft "compromises the incorruptible." Now CrunchGear's John Biggs says that "Love Will Tear Us Apart: Microsoft Wants Its Laptops Back." Joel Spolsky refused Microsoft's offer of a Ferrari laptop, and Scott Beale's auctioning his F1000 on eBay with the proceeds to go to the Electronic Frontier Foundation (EFF).

Michael Gartenberg weighs in with "Lessons from the Ferrari Fiasco" and Joe Wilcox adds his own take on the "fiasco" with a "Microsoft's Laptop Giveaway Is About Influence, Not Bribery" post in response to eWeek "Linux & Open Source" columnist Steven J. Vaughan-Nichols' "Bribing Bloggers" post. eWeek's John Pallato says, "Bloggers Can't Ignore Basic Journalism Ethics." 12/30/2006: GigaOm's Om Malik received his Ferrari (no model number) yesterday. (He plans to return it.) Jason Calacanis (formerly of Weblogs, Inc. and AOL) says "Microsoft Vista Ferrari Payoffs--horrible move," citing Om's post. Brandon LeBlanc reports his F5000 scores a 4.8 Windows Experience index. Should the folks who received F1000s be considered "second-class Web citizens?"

Ed Bott took issue with my use of Scott Beale's Control Panel\System screen capture that reported only the base (overall) WEI score and not the subscores. Ed also noted the need to run multiple tests to achieve an accurate value, as did Sandi Hardmeier in the first comment to this post. However, Mitch Denny's "Ferrari 1000: The Windows Experience Index (WEI)" post includes a Performance Information and Tools capture with the subscores that return the 2.8 base score—the result of a 2.8 Graphics subscore for the ATI Radeon Xpress 1100 GPU. Mitch also compares the Ferrari 1000 WEI Vista scores againsft a Fujitsu LifeBook T4210 and Dell Lattitude D820. Mitch cites Ed's post, which stresses the need to run multiple Performance Information and Tools capture to get an accurate result, so I don't believe there's an error in Mitch's data, nor do I believe that I misunderstood the WEI. A few other recipients of F1000s posting captures of their WEI scores would moot this controversy.

The plot thickens: CyberNet News' Ryan Wagner is scheduled to receive a Velocity Micro Media Center PC from Microsoft and AMD this weekend, and so is Long Zheng, who was one of the first to blog about free Ferraris. (Ryan says the specs aren't on the Velocity Micro site because it's scheduled to release on January 30, 2007, but he has a photo on his site.) 12/29/2006: Gear Live's Andru Edwards has already received his Media Center PC (see this blog's comments). Abbreviated specs from Gear Live are: "AMD Athlon FX 5000+ dual core processor, 2 GB DDR-800 RAM, two 400 GB hard drives in a RAID 1 configuration." Andru reports a 5.9 Windows Experience Index, which is the current maximum, in his blog's comments.

New twists on 12/29/2006: Microsoft apparently still has some leftover Acer Ferrari 1000 laptops that didn't get sent to bloggers. They're awarding them as lottery prizes to folks who watch Microsoft Office 2007 Webcasts. Too bad the machines don't rate a better Windows Experience Index than 2.8 (out of 5.9) for Vista. However, Microsoft's Keith Combs says Vista runs fine in its Basic color scheme (no Aero Glass) on a four-year-old Compaq Evo N620c.

Brave New Year: The New York Times takes the Ferrari bait on New Year's Day: Maria Aspen wrote a brief Technology section piece entitled "Costly Gift From Microsoft Is an Invitation to Blog." (Free registration required, copy here from CNet.) Ms. Aspen confirmed that Microsoft had sent 90 Ferraris "to bloggers who write about technology and other subjects".

The Intuitive Life Business Blog's Dave Taylor concludes in his January 3, 2006 "Vista laptops for bloggers furor misses the real story" post that "There is no ethical issue associated with a vendor giving product to thought and opinion leaders in a marketplace," asks "why didn't they send out the OS and let us install it on our own computers?" and then provides his answer: "Microsoft Vista is in fact a bear to install and has prohibitive hardware requirements." CrunchGear's John Boggs agrees with Taylor, but Houston Chronicle TechBlogger Dwight Silverman doesn't. Silverman says:

Taylor's actually the one missing the point, because most users' first experience with Vista won't be via an upgrade. It will be when they buy a new machine that comes pre-loaded with it. By sending bloggers' pre-loaded notebook PCs, Microsoft is actually giving them the mainstream Vista experience . . . minus, of course, all the junkware that comes loaded onto consumer PCs.

I found Vista to be quite easy to install on my year-old Gateway desktop client (runs Aero Glass graphics, as shown above) and a two-year-old Dell server (runs Basic graphics because it has a low-end graphics card).

Backstory: Edelman Public Relations got into hot water with the blogging community when the firm designed in October 2006 the Wal-Marting Across America flog (fake Weblog) for client Working Families for Wal-Mart without disclosing Edelman's or their client's particpation in the process. Dave Taylor's "Edelman screws up with duplicitous Wal-Mart blog, but it's okay?" post on the Intuitive Life Business Blog describes the conflict between the flog and the Word of Mouth Marketing Association's ethics rules. Taylor notes that Edelman "helped craft" these rules.

Full disclosure: I make a substantial part of my living writing about Microsoft programming environments, servers, productivity applications, and operating systems in books and for magazines. I did not receive a free laptop from Edelman or Microsoft. Several years ago, I received a substantial sum of money, an Xbox, and an LCD monitor as prizes for winning the inaugural 2002 Microsoft .NET Best Web Services contest. (I donated the two AMD PCs to the Ateneo de Manila University of the Philippines). I regularly receive or download free test/evaluation software from Microsoft, and, like most other magazine writers, I receive press credentials for Microsoft Tech•Ed and the Professional Developers Conference (PDC). I don't intend to refuse free software or press credentials in the foreseeable future.

News: The OakLeaf blog made Techmeme for the first time! Search this Techmeme capture for Edelman. Robert Scoble thinks sending bloggers free laptops is PayPerPost, Update 12/27/2006: Now Robert thinks that "the Microsoft Vista giveaway is an awesome idea." Check out this 12/28/2006 Techmeme capture as the "blogger ethics" controversy became the #1 topic (OakLeaf is the next-to-last Discussion link).

Technorati tags:
, , ,

Wednesday, November 15, 2006

Microsoft Offers SQL Server 2005 SP2 CTP

Microsoft announced on November 7, 2006 the availability of a Communtity Technical Preview (CTP) of the forthcoming SQL Server 2005 Service Pack 2 for all editions except Express, and special SP2 CTPs for the Express edition (SQLX) and Express with Advanced Features. SP2 will be required to run any version of SQL Server under Windows Vista and "Longhorn" Server. The "What's New in SQL Server 2005 SP2" page summarizes upgrades to:

  • Analysis Services
  • Database Engine
  • Integration Services
  • Reporting Services and
  • SharedTools
for editions that incorporate the features. Download the appropriate SP2 CTP bits from the SQL Server Community Technology Preview Program page. Microsoft senior vice president of Data and Storage Platforms Paul Flessner expanded on the preceding list during his keynote speech at the 2006 Professional Association for SQL Server (PASS) Community Summit in Seattle on November 15, 2006. Added features include:
  • Data compression
  • Increased business intelligence functionality
  • Security updates relating to Common Criteria
  • Manageability enhancements
  • Support for Windows Vista and
  • Optimization for use in the 2007 Microsoft Office system environment
Microsoft is pursuing Common Criteria security certification for SQL Server 2005 Enterprise Edition SP1 and SP2. Many governments require Common Criteria certification and it's a preference or requirement for many industries. In the meantime, Microsoft has made available Enterprise Strategy Group (ESG) reports on SQL Server 2005 security—Microsoft SQL Server Runs the Security Table and The Security Development Lifecycle (SDL). Advantage, Microsoft. According to ESG, "Microsoft SQL Server 2005 is particularly worth examining as it is the first major product release that Microsoft has put through the SDL." Flessner also announced that Visual Studio Team Edition for Database Professionals (formerly code-named "DataDude") is set to RTM on November 30, 2006.

Updated: 11/16/2006 with additional security data.

Technorati tags: , , , , , , ,

Friday, July 21, 2006

Windows Vista Won't Support MSDE 1.0 and 2000

According to Microsoft UK's Eric Nelson, MSDE will not be supported on Windows Vista. Although Eric claims that his July 12, 2006 post wasn't the first to report this potentially calamitous news, he didn't provide links to any predecessor posts. Apparently, the "lack of support" extends to SQL Server 7.0 and 2000, but it's unlikely that anyone would run full server versions under a client OS. There has been remarkably little reaction to Eric's or predecessor posts, if there are any earlier references. Google blog search returns a few post-July 12 hits on the subject; Technorati returned only old (200+ days) entries for a July 21 search on 'MSDE'—before uploading this post. As sharp-eyed as always, Mike Gunderloy picked up the story for "The Daily Grind" on July 14, 2006. ISVs whose commercial applications depend on MSDE 1.0 or 2000 will be most affected by Microsoft having deprecated these two products to "downlevel purgatory." Users who attempt to install either product under Windows Vista Beta 2 appear to receive a warning message but can continue installation. It's not yet clear what will occur in the release version when users attempt to upgrade to Vista a Windows 2000 or XP client with MSDE installed. Eric also mentioned in passing that the "Visual Basic 6 Development Environment will not be supported on Windows Vista," which Jacqueline Emigh reported in her February 21, 2006 article, "Microsoft's Upcoming Vista To Support Legacy VB6 Apps" for Microsoft's DevSource. This article quotes Jay Roxe, Microsoft's lead product manager for Visual Studio, as stating that Microsoft will extend mainstream support for the VB6 runtime ... by another six or seven years, through the end of the Vista lifecycle. Microsoft TechNet published "Upgrading MSDE 2000 to SQL Server 2005 Express" (SP-1) on April 7, 2006. If you don't mind a cumbersome login process, you can watch "MSDN Webcast: Upgrading from MSDE to SQL Server 2005 Express Edition (Level 100)" by the white paper's author, Michael Otey. Euan Garden addresses issues with SQL Server 7.0 and 2000 versions of the Data Transformation Service (DTS) Import/Export Wizard for copying tables from one server and database to another. Euan also offers recommendations for importing and exporting data with SQL Express, which doesn't include the DTS (now SQL Server Integration Services or SSIS) runtime. Euan's "SQL MythBusters – MSDE/SQL Express has a 5 concurrent user limit" post includes brief histories of MSDE 1.0 and 2000, plus SQL Express. MSDE 2000 users can copy their .mdf and .ldf files to a new \Data folder and attach them to an SQL Express instance. It's ironic that Microsoft has been promising for years to move Exchange Server's data store from the (Blue) Jet-based Extensible Storage Engine (ESE) to SQL Server. According to eWeek's "Exchange Data Store Change Still in the Cards" article by Peter Galli, Microsoft "says it remains committed to unifying this with the SQL Server database store going forward. They just don't know exactly when yet." Exchange 2007 will continue to use Jet—a technology that Microsoft deprecated as of MSDE 2000's release—not SQL Server as its data store.*

* Note: [Updated 7/23/2006] On July 22, 2006 Euan Garden let me know in no uncertain terms that I was wrong to associate Exchange's Blue JET (Joint Engine Technology) engine with Access's and VB's Red JET engine. See my July 23, 2006 "Red vs. Blue JET Database API Confusion" post.

Microsoft officially released SQL Express (SQLX) on November 7, 2005 and Windows Vista might release in January or February 2007. This means that Vista early adopters' window to convert from MSDE to SQLX would have been about a year, had Microsoft publicized future lack of MSDE support when releasing SQLX. However, the window now is reduced to about six months as a result of July's "stealth-mode" announcement. Not nice. Technorati: , , , , , , , , , , , , , ,

Monday, June 26, 2006

Microsoft Bites the Bullet: WinFS Bites the Dust

The demise of WinFS—recounted by Quentin Clark's "WinFS Update" and "Update to the Update" posts in the WinFS team's "What's in Store" blog—shouldn't have surprised anyone. WinFS is only the latest in a chain of Microsoft's abandoned enhancements to—or replacements for—the New Technology File System (NTFS) and aborted implementations of object-relational mapping (ORM) technologies. Microsoft's Paul Vick calls them "Black Hole Projects" and provides a detailed list of their typical characteristics. I've been following—and writing about—the primrose path to the Object File System (OFS) and its successors since 1993. In a Guest Opinion titled "Is Visual Basic Ready for Client/Server Prime Time?" for the October/November 1993 issue of Fawcette Technical Publications' Visual Basic Programmer's Journal (later to become Visual Studio Magazine), I wrote:

Creating VB database front-ends by pasting together objects stored in a repository database probably will have to wait for Chicago (Windows 4.0?) or Cairo (Windows NT 4.0?) and Microsoft’s newly rumored object database for Windows NT, code-named Cumulus.

The choice of Cumulus as the codename for Windows NT's always-forthcoming OFS isn't surprising when you consider the Cirrus was the codename for Microsoft Access 1.0, which Microsoft released in November 1993 at Fall Comdex. As it turns out, Stratus probably would have been the better choice because OFS bought the farm after scud-running once too often.

OFS, RFS, Storage+ and Windows DNA

OFS morphed to the Relational File System (RFS, more commonly called Storage+) in 2000 when the successor to Windows Server 2003 was codenamed Blackcomb. Storage+, COM+, and Forms+ were to be the foundation of Windows DNA (Distributed Network/iNternet Architecture). Paul Thurott published a detailed history of OFS, RFS and Storage+, plus commentary on WinFS in his August 2005 "Windows Storage Foundation (WinFS) Preview" article. Paul's July 1999 "COM+, A Windows 2000 technology showcase" article (updated March 2000) describes Microsoft intentions for Storage+, COM+, and Forms+. Paul had this to say about Storage+:

Storage+ will do away with the NTFS file system and replace it with a new relational, object-oriented file system based on SQL Server 8.0. Expected to arrive with the next version of Business Windows (post-Windows 2000, think 2003 or 2004), Storage+ will turn the file system into a relational database, speeding searches and providing a higher level of granularity for those searches. It will also have the wonderful side-effect of finally ridding us of those limiting drive letters.

An SQL Server 2000 (8.0)-based Storage+ never appeared and there's no liklihood that future WinFS features will be derived from SQL Server 2005 (9.0). Ed Brill found SQL Server déjà vu in Bill Gates' September 2005 association of WinFS with "Katmai," the codename for SQL Server v.Next, and Steve Ballmer's December 2000 statements about WinFS and "Yukon," the code-name for the long-delayed SQL Server 2005.

One of the comments about Brill's post leads to an August 29, 2005 WinFS Team post by Peter Spiro, "the General Manager in SQL Server responsible for the WinFS team," that ends with:

A few years back Ray Ozzie came to Microsoft to speak at an internal workshop we have called WHiPS (Workshop on High Performance Systems). Ray talked about Groove. It was a pretty cool app trying to be a platform (tough to do for a small company). As we were talking after his presentation he described how he had to first build a platform on top of the operating system, which then enabled him to build the app that he had envisioned.

He said he needed storage beyond just a file system; he needed synchronization capabilities to share information between different machines/users, he needed advanced security mechanisms, he needed a way to model his particular schemas in the storage system, he needed to search on the information. So he built a richer storage system that incorporated these types of concepts and then he built the Groove app on top of his platform. His comment to me was that Microsoft should build such a platform and stop selling the same old operating system and storage capabilities that we as an industry have been polishing for 20-30 years. He felt this richer platform would create a new ecosystem that allowed a variety of new apps to be developed. He was right; and I told him we had already started on it, and that it was called WinFS.

As of June 15, 2006, Ray Ozzie became Bill Gates' replacement; and he's called Microsoft's Chief Architect.

Eight days later WinFS is dead.

Déjà vu all over again: Project Green, MBF and Object Spaces

Apropos Paul Thurott's mention of "Business Windows," how many members of the computer press and .NET-oriented book writers fell into the "Project Green" trap before Microsoft abandoned the Microsoft Business Framework (MBF) in October, 2005? My initial table of contents for Expert One-on-One Visual Basic 2005 Database Programming included an entire section devoted to ObjectSpaces, the OPath query language, and MBF. Much to my surprise ObjectSpaces and all references to MBF disappeared in Whidbey Beta 2, as I reported in my September 14, 2005 "The Language Integrated Query (LINQ) Project" post:

[Luca Bolognese, a prime mover on the ObjectSpace team, announced at Tech•Ed 2004] that ObjectSpaces had acquired a dependency on WinFS and thus was postponed to the Longhorn/Orcas timeframe. (He appeared close to tears as he made the announcement.) The dependence of the long-delayed Microsoft Business Framework (MBF) API on ObjectSpaces as its object persistence platform probably was a contributing factor to the demise of ObjectSpaces [and MBF support] in VS 2005.

Microsoft Watch's Mary Jo Foley quoted Satya Nadella, Microsoft Business Solutions corporate vice president, in her October 21, 2005 "Microsoft Scuttles Plans for Standalone Microsoft Business Framework" article:

[Nadella] said that Microsoft is planning to deliver all of the same MBF features and functionality it originally envisioned, but just in a different way.

"MBF won't ship as a separate entity. It has gotten factored into parts of our other deliverables," Nadella explained.

MBF technologies can be found in the Windows Workflow Foundation engine, the forthcoming Language Integrated Query (LINQ) project extensions to Visual Basic and C#; and the Common Data Platform (CDP) application programming interfaces; Visual Studio 2005; and "Orcas," the version of Visual Studio slated to follow Visual Studio 2005, Nadella said.

WinFS, Longhorn, and the Windows Data Platform Vision

Backing up to December 16, 2003, I wrote in my "Get a Grip on Longhorn" article for the February 2004 issue of Visual Studio Magazine:

The WinFS data model consists of Items, Relationships, and extensions. Items use an XML schema to define the metadata properties of everything that's stored in WinFS. The schema lets WinFS serialize Items as .NET objects, which you access with members of the System.Storage namespace. For example, System.Storage.Contact provides the context required to find, add, and delete Person objects, which have DisplayName, PersonalEmailAddresses, personalTelephoneNumbers, and several other predefined properties.

Relationships create joins between Item metadata values to return multiple Item types in query resultsets. For example, you can relate an Office document's Author property to a Contact Item's DisplayName property. A natural-language search returns links to matching document and contact Items. Extensions let you add new properties to an existing item's XML schema. Other WinFS features include Notifications, which let users subscribe to events raised by Item-related changes.

Synchronization between WinFS stores on multiple machines takes place through a "community folder" that's associated with groups of Items on local machines. Synchronization replicates Items between machines according to instructions contained in send-only, receive-only, or send-receive synchronization profiles. Information Agents automate actions for users based on WinFS data, rules, preferences, and contexts.

So 2-1/2 years later WinFS has gone the way of ObjectSpaces and MBF: Balkanized into Paul Flessner's Data Platform Vision, with some promised features to be integrated into SQL Server "Katmai", ADO.NET 3.0, and Visual Studio "Orcas."

Note: You can watch Jim Allchin—Microsoft's Group Vice President for Platforms—explain in an August 19, 2005 Channel9 video that "we now intend to deliver WinFS after the initial availability of Longhorn client. We continue to be committed to WinFS. It is expected to beta when Longhorn client is broadly available." Jim will have retired by the time Microsoft discovers the effect of the loss of WinFS on Vista sales.

DevX Executive Editor A. Russell Jones reported June 14, 2006 from Tech•Ed 2006:

WinFS Lives: WinFS, cut from the first version of Vista, isn't dead; it's still being improved. Shan Sinha, a Program Manager on the WinFS team, showed off the newest features, and promised a second beta later this year. WinFS wraps the tried and too-familiar NTFS file system in a relational database, providing new and revolutionary relational abilities to the Windows file system. Doing that has far-reaching implications, and presents huge technical hurdles. For example, a relational file system must manage its own indexes, backup, and recovery, and must do so both invisibly and with no human intervention (no database admin). Despite adding new and integrated file system capabilities, it must maintain file-level compatibility with earlier versions, so that existing programs don't break, and it must be able to maintain the new information and relationships across backups. From the demos though, it looks as if Microsoft has conquered the problems. In one demonstration, Shan destroyed the data on a disk sector, then walked the audience through the automatic recovery process. Very impressive. [Emphasis added.]

Peter Galli's June 27, 2006 eWeek interview with Corey Thomas, Microsoft group product manager for SQL Server, explains "Why Microsoft Pulled WinFS as a Stand-Alone Product" after three Tech•Ed 2006 presentations. Thomas adds a surfeit of spin but no mention whatsoever of Ray Ozzie.

Analysts and Bloggers Write WinFS's Obituary

Analyzing WinFS has consumed thousands of reporter-hours and untold barrels of electronic ink. Mary Jo Foley has been reporting the WinFS saga for Microsoft Watch since PDC 2003. Follow Mary Jo's WinFS breadcrumbs for the chronology of the "Rise and Fall of WinFS":

Note: You can watch Mario Juarez interview Mary Jo Foley at TechEd 2006.

Microsoft Monitor's Joe Wilcox's also has taken Microsoft to task for its WinFS peregrinations:

You also might want to check out Microsoft's Dare Obasanjo's reflections on WinFS and recent events:

Dare says in his last post cited above: "WinFS merging with Object Spaces is my canonical example of scope creep at Microsoft." The link is to Franz Brouma's May 22, 2004 post, which includes a comment from Microsoft Distinguished Engineer Tim Brookins. Tim had posted "MBF Joins the Longhorn Wave" on May 10, 2004 to explain why MBF would not be included in the VS 2005 (Whidbey) beta, as reported in InformationWeek's "Microsoft's Business Framework Gets Pushed Back" story of May 5, 2004 and CRN's "Microsoft Business Framework To Wait For Longhorn, Orcas" same-date article by Barbara Darrow.

InfoWorld's "Strategic Developer" columnist and chief blogger Jon Udell emphasizes the lack of support for Internet-based social networking in Cairo and WinFS, but doesn't buy analysts "WinFS is dead" pronoucements:

InfoWorld's "Enterprise Windows" columnist Oliver Rist entered the fray on June 29, 2006 with his "Microsoft kills the WinFS dream" article that's subtitled "Server admins' hopes fade as better Windows file system management goes the way of the dodo."

The DaVinci Code Effect: WinFS as Empty Holy Grail

Finally, the Seattle Post-Intelligencer's Todd Bishop quotes Bill Gates at PDC 2003 in his "WinFS: Microsoft's 'Holy Grail' file system still elusive" article:

WinFS -- this is unified storage. Some of you here have heard me talk about unified storage for more than a decade. The idea of taking the XML flexibility, database technology, getting it into the file system: that's been a Holy Grail for me for quite some time. And here it is." -- Bill Gates, October 2003.

As Todd Bishop observes, "Well, not yet, at least as a part of Windows."

[Updated June 27, 28, and 29, 2006. Minor changes and links added on July 1, July 5, and October 20, 2006.]

Technorati: , , , , , , , , , , , , , , , , , ,