SQL 2008 RTM Slips to Q3 2008

Over the coming months, customers and partners can look forward to significant product milestones for SQL Server.  Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3.

Full story at http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx

Yahoo’s CAPTCHA Broken…Is a Spam Tsunami in the Offing?

Uh oh…

The CAPTCHA security system that Yahoo, and many other email service providers adopt to prevent spam, may not be secure, according to Russian security researchers. The researchers claim to have found a way in which the security system can be compromised. This would result in a huge increase in spam coming from yahoo and other email accounts.

Full story at http://internetcommunications.tmcnet.com/topics/broadband-mobile/articles/18772-yahoos-captcha-brokenis-spam-tsunami-the-offing.htm

My FlexWallet to eWallet Upgrade

For years, I used FlexWallet on my Treo 700w to keep track of my passwords and such.  Recently, FlexWallet was merged into eWallet, so I had to install new software and remove the old.  Always scary.

Since eWallet’s file format is different than FlexWallet, an import was required.  It failed.  So I e-mailed support, and after exchanging a couple e-mails, they sent me a link to an updated eWallet.  The import worked this time, and I’ve been very happy with eWallet.  Thanks to Kevin for speedy response!  I’ve updated my Treo 700w must-have list, replacing FlexWallet with eWallet.

DotNetVideos.net Launches

Shiny new thing to eat up bandwidth!

I’m a solo developer in a corporate environment, so I’m really on my own to learn new things.  As good as blogs and books are, there’s sometimes no substitute for being shown how.  That’s why Microsoft highlights so many videos on its asp.net site.  ASP Alliance also has a growing library of videos.

Enter onto this list one more site–DotNetVideos.net.  Right now there are around 100 videos on a great number of topics.  Apparently there are a couple hundred more in the pipeline.  And, if you sign up now, you get 6 months of ASP.NET Pro magazine for free.  That alone is worth the sign-up.  ASP.NET Pro is one of my favorite trade mags (I have an online subscription, and have for several years).

When you’re Googling for info on whatever you’re working on, don’t forget to check out this site, too, and see if someone is showing you how it’s done.

Full disclosure: I was asked to say something about the new site, and I usually ignore such requests.  But after checking it it, it’s one I’ll be spending some time on, and recommending to others.

(edit – fixed links)

Error: Both DataSource and DataSourceID are defined on ‘controlname’. Remove one definition.

Assuming you don’t actually have both a DataSource and DataSourceId defined on the same control, this may actually be a bug.  My situation is Visual Studio 2008, compiling an application for .NET 2.0.  I tested this with both Enterprise Library 2.0 and Enterprise Library 3.1.  For me, I’m trying to hydrate a RadioButtonList from a dataset, which is created from a stored procedure call with a parameter passed.  If I hardcode some values in the sproc and don’t pass the parameter, it all works fine.  But, if I pass the parameter, I get the error.  I have a workaround in mind, and I’ll post it whenI get it done.

I reported this at http://connect.microsoft.com/, with an issue ID = 323454; the title is “Both DataSource and DataSourceID are defined…”.  If you’re having the same problem, log in and vote for this issue–more votes = higher priority.  The text of my report is below:

I’m using VS 2008 (9.0.21022.8 RTM), compiling for the .NET 2.0 framework.

On a web form, I’ve added a RadioButtonList, as below:

<asp:RadioButtonList ID=”rblShippingPlatform” runat=”server” CssClass=”FormFieldsAjax” />

In code behind, I call a function in a CBO in the same project to hydrate the values:

cPub.fillShippingPlatforms(rblShippingPlatform, cPublic.Segment.Lane)

The function in the CBO makes a call to the DAL, which is a shared library added as a project reference:

    Public Sub fillShippingPlatforms(ByVal rblPlatforms As RadioButtonList, ByVal sSegment As String)
        With rblPlatforms
            .DataSource = cDb.GetShippingPlatforms(sSegment)
            .DataValueField = “ShippingPlatformID”
            .DataTextField = “ShippingPlatform”
        End With
    End Sub

The DAL simply executes a stored procedure and returns a dataset:

    Public Function GetShippingPlatforms(ByVal sSegment As String) As DataSet
        dB = DatabaseFactory.CreateDatabase
        cmd = dB.GetStoredProcCommand(“lpGetShippingPlatforms”)

        With dB
            .AddInParameter(cmd, “@Segment”, DbType.String, sSegment)
            Return .ExecuteDataSet(cmd)
        End With

    End Function

There’s nothing fancy here, but when I load the web form, I receive an error stating “Both DataSource and DataSourceID are defined on ‘rblShippingPlatform’. Remove one definition. “.

I can hydrate the RadioButtonList if I adjust the stored procedure and remove the parameter handling.

    Public Function GetShippingPlatforms(ByVal sSegment As String) As DataSet
        dB = DatabaseFactory.CreateDatabase
        Return dB.ExecuteDataSet(CommandType.StoredProcedure, “lpGetShippingPlatforms”)
    End Function

This issue occurs with both the Jan 2006 and May 2007 versions of the Enterprise Library.

Registration Open for Pittsburgh Launch of Visual Studio 2008

Registration is now open for the Pittsburgh launch of Visual Studio 2008, SQL Server 2008 and Windows Server 2008.  The launch is April 14 at the Westin Convention Center–additional details as they become available.

The date seems to have changed–I recall is being April 4 last week, so make sure you schedule the right day to be out of the office.

Register at http://www.heroshappenhere.com/.

Dell Vostro: Not Totally Free of Crapware

One of Dell’s selling points for its new Vostro line is a lack of trial-ware.  In fact, Dell’s website makes the following claim on the Vostro homepage:

No trialware.
Customers said they hated trialware, so we took it away. Vostro systems come without annoying trialware pre-installed. You only get the software you want.

If only it were true that you only got the software you want.  Remember these machines are designed and priced for small offices, 1-25 employees.  You know the kinds of offices these are–they’re the ones without IT, and are subject to the whims of their vendors.  We recently purchased three Vostros (two Vostro 200 slim towers to expand the POS in my wife’s flower shop, and one Vostro 1500 laptop for myself), and I was dismayed to find software I didn’t really want on all three:

1) Google Toolbar is preinstalled with IE.  Google recently seems to have changed its motto from “don’t be evil” to “total world domination”, and I understand they pay a bounty to Dell for preinstallation of their toolbar.  In case you’ve missed out, Google’s been involved in a couple of privacy flaps lately.  The toolbar remembers where you go and what you do, which has probably been a reason for some of these unsecured data exposures on the Internet–the file location was sent to Google after being accessed by an unsuspecting user, and Google indexed it.  Yes, the business was stupid to not secure the data, but Google is the one who indexed the data and made it public, so I hold both complicit.

2) Google Desktop.  This one is worse than the toolbar, IMHO.  Again, it’s my understanding a bounty is paid for each installation.  And again, there are privacy issues, especially since it opens (automatically, BTW) with default settings.  If the user doesn’t know the software is installed and is indexing their documents, they might be surprised to see them show up in their searches.  While usually pretty secure, Google’s various properties have been subject to exploits recently, and there is the chance sensitive data can be compromised because of the Google desktop.  Additionally, Google Desktop introduces unexpected keyboard behaviors (e.g., double control brings up a search box), and for unknowledgeable users, this software makes their computer a thing of surprise.

3) The Dell Search Redirector.  Oh how this one works my main nerve!  If you goof a website’s address in IE, you’re transported to a Dell/Google cobranded page of “suggested results” and (drum roll please) AdWords ads.  The standard “Internet Explorer couldn’t find the website you’re looking for” page has been totally replaced.

4) Dell Network Assistant.  Yet another replacement for Window’s built in network connection utilities.  Granted, the user-friendliness of Windows XP’s network management is really low, but the Dell NA takes forever to find the preferred network and connect.  How slow is it?  I can boot, open Thunderbird and have it searching for my e-mail servers, and it’s still another minute or so before DNA connects.

5) Dell Support Assistant.  I feel bad for people who agree to use this one.  You get the annoying toasts saying there’s some update for your PC somewhere, but the UI is confusing and uninformative.  If there’s an alert, I should be taken right to it when I open the tool.  Plus, we don’t need the staff freaking out that something is wrong with the new PCs just because an unexpected notice pops up.  That’s disruptive to the day’s work, and takes them out of their flow if they’re taking an order and one of these messages appears.

Now, you can turn off and uninstall all of these options, but that’s not very friendly.  It should be that I can turn on anything I want, not have to turn off what I don’t.  Except for the Dell Network Assistant, all of the others have been removed from our PCs.

kick it on DotNetKicks.com