Notes from Daily Encounters with Technology RSS 2.0
 
# Sunday, March 25, 2007

In Windows Vista the default value for the Persist Security Info parameter of an ADO connection string has changed from True to False.

You should be aware of this because it can prevent your legacy code from working properly under Windows Vista. If its value is set to False the Server, Database, Trusted_Connection and Password parameters will be removed from the ConnectionString property of the Connection object once the connection has been opened. If you’re creating new connections by just copying the ConnectionString property from an existing and already opened connection to the new one, your code will break under Vista.

The problem can easily be fixed by explicitly setting Persist Security Info to True in your original connection string but it should be mentioned that this can be a potential security risk if untrusted code gets access to your Connection object. Even more so in case you’re not using integrated security and the connection string actually contains the user’s password for accessing the database. It’s a much better practice to have the actual connection string stored separately and use it directly to create new connections.

On a side note, SqlClient in ADO.NET works much more consistently. The Persist Security Info parameter always defaults to False. It also only removes the Password parameter from the ConnectionString property which makes changing its value to True completely unnecessary unless you really feel a strong urge to share your user’s password.

Sunday, March 25, 2007 9:48:05 AM (Central European Daylight Time, UTC+02:00)  #    Comments [2] - Trackback
Development | VB6
# Saturday, March 10, 2007

One of the first tasks on my to-do list after buying a new computer with Vista Home Premium edition was setting up Media Center Extender for Xbox 360 along with Transcode 360 to make my Xbox 360 a true multimedia device.

Unfortunately the problems started immediately after setting up the Media Center Extender on my PC. (At this point I’d like to mention that the required 8-digit setup key can be acquired by starting Media Center on Xbox 360. I spent more time than I should, figuring this out.) Browsing pictures worked fine, also music and WMV streaming. On the other hand MPEG streaming resulted in errors.

I quickly dismissed a few probable causes for the problem:

  • After noticing that Windows Media Player couldn’t properly play MPEG2 files (but strangely DVDs worked just fine) I installed FFDShow with MPEG2 playback option turned on. It fixed the playback in WMP 11 but the problem on the Xbox 360 side remained.
  • Just to be sure I temporarily disabled the firewall although the required ports have already been opened and WMV streaming worked just fine. No surprises there – MPEG streaming still didn’t work.
  • The last desperate act was completely disabling my antivirus solution in case it would be causing problems. It didn’t help either.

The weekend was coming to its end so I decided to try out the alternative media server solution TVersity. It worked out of the box without problems, even transcoding of unsupported formats to WMV. But during the following week I was growingly unsatisfied with it:

  • Fast forwarding and rewinding of transcoded videos didn’t work until they were played back for the first time and cached.
  • To make the matters worse even pausing had its problems causing the playback to stop early for the amount of time it was paused in between. Once again the problem only appeared for directly transcoded videos not yet in the cache.
  • While music list was properly organized by albums and authors the video list was completely flat making it a real pain scrolling through a few hundred alphabetically sorted files.

All of that convinced me to revisit the Media Center problem. Not wanting to reinstall my machine being otherwise already quite nicely setup by that time I decided to uninstall PC-cillin Internet Security 2007 just to be sure after reading in a few forums that both  McAfee and Norton can prevent streaming altogether even if they are disabled. It actually solved my MPEG streaming problem although I thought it highly unlikely since WMV streaming worked all the time. I still can’t explain why only MPEG streaming was affected but since then I’m using NOD32 and still waiting for the first problem it would cause. Not to mention that it also uses far less system resources than PC-cillin.

The last of my problems was that the default Transcode 360 installation had problems with UAC therefore I had to manually remove it (uninstall didn’t work) and reinstall it in the unsupported service mode.

Now that all problems are solved, my Xbox 360 really is the universal home entertainment system. Being properly connected to my HD LCD TV and surround sound system I am now using it for watching DVDs, streaming videos from my computer, listening to music and watching photos. Even the user interface is very intuitive and easy to use. Only my music collection still needs some reorganization for all the different views in the Media Center to work as intended.

Saturday, March 10, 2007 12:34:02 PM (Central European Standard Time, UTC+01:00)  #    Comments [0] - Trackback
Gadgets | Xbox | Software | Antivirus | Windows

The program can't check for definition updatesThere seems to be a problem with updating Windows Defender when using Microsoft Update instead of Windows Update in Windows Vista. The problem becomes apparent when Windows Defender puts up a warning in the system tray that its signatures are not up to date. This of course shouldn’t happen at all with Automatic Updates turned on. Manual attempts to update Windows Defender result in an error, while Microsoft Update insists that the system is up to date and no new updates are available.

Error found: Code 0x80240029

According to the list of Windows Update 5 errors the above error code is 0x80240029 – WU E INVALID PRODUCT LICENCE: A product with an invalid license was found on the system. This is just plain silly (in my case it was happening on an OEM Vista Home Premium edition that came with my new computer) though a look in the WindowsUpdate.log file sheds some light on it:

2007-03-10 07:30:30:258 1144 1308 Report REPORT EVENT: {3B3B2164-091C-4856-9FBC-9D99EDAE3198} 2007-03-10 07:30:25:259+0100 1 154 101 {00000000-0000-0000-0000-000000000000} 0 0 Windows Defender Failure Software Synchronization Client has an invalid Pid.

Looking at this record you can quickly stop wondering why the Pid is invalid. An empty value instead of an actual one is used. Fortunately the solution is quite simple (once you know what it is): disabling the Use Microsoft Update checkbox in the Turn automatic updating on or off section of the Control Panel.

Use Microsoft Update

Once you do that Windows Defender will successfully update itself. Windows Update will also find its updates now and maybe even some other updates that didn’t show up when Microsoft Update service was used.

Saturday, March 10, 2007 9:59:32 AM (Central European Standard Time, UTC+01:00)  #    Comments [1] - Trackback
Software | Windows
# Wednesday, January 03, 2007

The functionality of the Run as context menu item is often an invaluable tool. The following two scenarios are probably the most common.

  • If you’re using a LUA account (which you always should) you can use it to run specific applications with administrative privileges.
  • If you’re a developer you can use it to test how you’re application behaves with different credentials.

The downside of this command is that unless you want to use the administrator’s account, you have to enter the desired username every single time which quickly becomes tedious.

You can work around that if use the Runas command. Its /user parameter allows you to set your desired username in advance. To avoid typing you can create a shortcut pointing to the following location:

C:\Windows\System32\runas.exe /user:MYCOMPUTER\MyUser MyApplication.exe

Apart from opening a command prompt for password instead of a nice GUI this should be a perfect solution, as long as you don’t want to run too many applications this way. Creating shortcuts for all of them can once again get tedious.

But fear not, there’s a solution for this as well; create your own context menu command by adding the following entry into the registry:

[HKEY_CURRENT_USER\Software\Classes\exefile\shell\Run as MyUser...\command]
@="C:\\Windows\\system32\\runas.exe /user:MYCOMPUTER\\MyUser \"%L\""

Of course you should replace MYCOMPUTER\MyUser with your desired username in both above examples; and MyApplication.exe in the shortcut with the path to your application. Use HKEY_LOCALMACHINE instead of HKEY_CURRENT_USER to add the command for all users not only for you.

Wednesday, January 03, 2007 9:54:16 PM (Central European Standard Time, UTC+01:00)  #    Comments [2] - Trackback
Software | Windows
# Sunday, December 31, 2006

Microsoft Office 2007 applications (at least Outlook and OneNote in particular) require Windows Desktop Search 3.0 to be installed for their built-in search capabilities to work fully. Since out of the box this version of WDS doesn’t support the indexing of files on network shares you also have to install the WDS Add-in for Files on Microsoft Networks. You still have to map the network drives to be indexed but at least you can select them in the WDS options window afterwards.

In Windows Vista WDS 3.0 is already built-in but you still have to install the add-in for the indexing of files on network shares to work.

Sunday, December 31, 2006 8:45:04 AM (Central European Standard Time, UTC+01:00)  #    Comments [0] - Trackback
Software | Windows
Sponsored Ads

About Me
Twitter
@MladenPrajdic @andrejt use the middle mouse button then 1 day ago
@matevzg @MladenPrajdic Ctrl+F4, as well 1 day ago
Great #DotNetRocks show: Troy Hunt Secures http://t.co/oxClbXLe http://t.co/MiMasNuZ PDF is worth checking out as well http://t.co/z4BHAzqh 3 days ago
Hazards of Converting Binary Data To A String http://t.co/lb8kRSsU via @haacked 5 days ago
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

All Content © 2012, Damir Arh, M. Sc. Send mail to the author(s) - Privacy Policy - Sign In
Based on DasBlog theme 'Business' created by Christoph De Baene (delarou)
Social Network Icon Pack by Komodo Media, Rogie King is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.