Persist Security Info default value changed in Windows Vista (Development | VB6)

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.

3/25/2007 8:48:05 AM (Central Europe Standard Time, UTC+01:00)    Comments [2]

Antivirus applications and Media Center MPEG streaming (Personal | Software)

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.

3/10/2007 12:34:02 PM (Central Europe Standard Time, UTC+01:00)    Comments [0]

Windows Defender problem with Microsoft Update (Personal | Software)

There 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.

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.

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.

3/10/2007 9:59:32 AM (Central Europe Standard Time, UTC+01:00)    Comments [1]