Running Vista; Redmond, we have a problem

So I’m running Windows Vista. And although it’s running very smoothly itself, there are some problems.

  1. SQL Server 2005 won’t install
    This is the weirdest one and I have no idea how to solve it. The server/service itself has installed, but client tools (Management Studio) doesn’t. And that’s currently the application I need most.
  2. Outlook Webmail Access uses a DHTML Editor that’s not installed with Windows Vista because of security reasons. I can read, but not write and email. There is a solution (download) for it, but that only installs the editor for applications, not the browser enabled version. The only solution is to install the latest Exchange patch so the DHTML Editor isn’t neccesary anymore. Luckely we have VPN as well, so I can still write email.
  3. Visual Studio 2005

I already knew it had some issues, but I just had to try and see for myself. First things I’ve noticed are that VS2005 can’t attach itself automatically to the web server anymore. I haven’t tried IIS and/or WinForms yet.

Another problem I have is that Vista has IPv6 support. This means that Dns.GetHostEntry suddenly also returns hexadecimal email addresses. But I was building up some links for an intranet website/application using ip addresses. Win2003 can’t handle the IPv6 ip addresses! πŸ˜‰

Luckely I found some code on the internet that should be the solution, I guess.

    private IPAddress GetIPAddress(string dataSource, System.Net.Sockets.AddressFamily addressFamily)
    {
      try
      {
        IPAddress[] addresses = Dns.GetHostEntry(dataSource).AddressList;
 
        // Try to avoid problems with IPV6 addresses
        foreach (IPAddress address in addresses)
        {
          if (address.AddressFamily == addressFamily)
          {
            return address;
          }
        }
 
        return addresses[0];
      }
      catch (Exception ex)
      {
        // If it's not possible to get the list of IP adress associated to 
        // the Data Source we try to check if Data Source is already an IP Address
        // and return it
        try
        {
          return IPAddress.Parse(dataSource);
        }
        catch
        {
          // In this case we want to rethrow the first exception
          throw ex;
        }
      }
    }

You can request your own ip address should be retrieved using the following line:

GetIPAddress(Dns.GetHostName(), System.Net.Sockets.AddressFamily.InterNetwork );

I’m currently connected to the internet and our company’s VPN, so I have 6 ip addresses in my AddressList. The first IPv4 address return is indeed what I need and I can only assume this also works in production. I’m still unsure how to write a test* for this though.

*= I didn’t write unit test, because else people might start complaining. πŸ˜‰

You may also like...

6 Responses

  1. RJ says:

    This afernoon I installed the SQL Server 2005 client tools without a problem. It upgraded the tools from the SQL 2005 Express edition to the normal SQL Server 2005 edition.

    You don’t have some UAC /access-rights problem?

  2. @RJ : Not that I’m aware of. I ran the setup with my user in the admin group, I ran it with that user using “Run as administrator” Γ‘nd I enabled the administrator account and installed it with that user. Nothing worked.

  3. RJ says:

    Have you tried it again with the UAC turned off?

    Windows button + R, “msconfig”, click continue, click on last tab, scroll down, select ‘disable UAC’, click Launch, restart

    Yesterday I couldn’t add a printer while having my UAC turned on… after I disabled the UAC, adding the printer worked fine…

  4. No I haven’t, thanks for the tip.

    It’s definitly a personal problem, I figured so far. No one else is having problems like mine.

    I installed the latest (SP2 enabled) SQL Express btw, which installed fine. I have the Express Management Studio running now, so I can still access data.

  5. Adel Khalil says:

    I ran into another problem, the Dataset designer, in other word if you open xsd file to play with the tables.. a little.. the VS IDE will frezz every time you try to move any element from the xsd editor surface (TableAdapters) and unfrezz after few seconed but will frezz again with the next move.. so useless
    πŸ™

  6. Adel Khalil says:

    I ran into another problem, the Dataset designer, in other word if you open xsd file to play with the tables.. a little.. the VS IDE will frezz every time you try to move any element from the xsd editor surface (TableAdapters) and unfrezz after few seconed but will frezz again with the next move.. so useless
    πŸ™

Click on a tab to select how you'd like to leave your comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.