Today I couldn’t install some tool on Windows 2003 SE despite being assigned to the Admisnitrators group. Whenever I tried I get the following message:
Windows cannot access the specified device, path, or file. You may not have the appropraiate permissions to access the item.
If you face such problem, first of all check what permissions you have. To do that, right click on My Computer and choose Manage; then System Tools\Local Users and Groups\Groups; double click Administrators on the right part of the window and check if you are on the list of users with that persmissions.
As I said, I was the Admisnitrator of that machine so that was really strange. So I righ clicked the exe file I needed to run and chose Properties. In the Security tab I found out I have the appropriate rights on that file. I went to General tab of that window; at the bottom, in Security section there was the infromation:
This file came from another computer and might be blocked to help protect this computer.
.
That was it! You just need to click Unblock button which is next to the above information.
FYI: The whole security section is only visible for ‘unsecure’ files. Once you enable a file’s exection and click OK, you will no longer see it.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
It’s possible to have more than one ASP.NET IIS installed and registrated on one machine (that runs Windows).
To check which version is currently registered run Command Line (Start/Run… and type ‘cmd’) and go to %SystemRoot%\Microsoft.NET\Framework\vXXX directory where %SystemRoot% is a special system-wide environment variable found on Microsoft Windows NT and its derivatives (read more on Wikipedia) and vXXX is the directory with ASP.NET IIS files.
Being in that directory, type aspnet_regiis -lv. You will be then given the list of installed/registered versions of ASP.NET IIS.
To register a new version of ASP.NET IIS, go to its direcotry in %SystemRoot%\Microsoft.NET\Framework (using Command Line) and run the following command: aspnet_regiis -i.
To unregister a new version of ASP.NET IIS, go to its direcotry in %SystemRoot%\Microsoft.NET\Framework (using Command Line) and run the following command: aspnet_regiis -u.
To learn more about ASP.NET IIS Registration Tool (Aspnet_regiis.exe) visit the description available on MSDN service.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Many times it happened to me that I needed to convert a file from one format to another (text documents, images, movies, etc). It can be difficult and expensive to download different pieces of software that can do that.
Media Convert service comes with helping hand. Let me cite the authors:
Media-Convert is 100% free. No software is needed, and you don’t have to register. You only need your favorite Internet browser. Your files are ready 7/7 days 24/24 hours (…).
Why use Media-Convert?
Simply because Media-Convert is the best manner of converting audio files, video, presentation, document, spreadsheet, etc.
Media-Convert advantages:
- More secure because you do not have to install software on your computer, which can contain viruses, spywares, etc.
- Access from everywhere in the world through Internet. You can use Media-Convert at the office, in a cybercafé, or with the PC of a friend, and then download the result quietly to your mp3 reader, cell phone or any other hardware.
So far, I must admit I’m happy with it. However, I’m not guy who converts things everyday 
Besided that service, I’ve encountered another, MC. I didn’t use it much, though. I tried to test it with convertion of doc files to pdf but all tries ended up with “You used an unknown file type!” message. It discouraged me from discovering what I did wrong, if I could do such at all
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
A few days ago I made a few major changes on my blog:
The engine change went OK. Once I updated the files, there was a imprefections in querying database, but clicking the suggested link on wp-admin page solved them all.
Currently, when I have some free time I browse plugins and themes - still can find something better/new. So far, I’ve installed the following plugins and I’m happy with them (the descriptions used there come from the home pages of that plugins):
- All in One SEO Pack - automatically optimizes your Wordpress blog for Search Engines (Search Engine Optimization).
- Google Code Prettify - this plugin using google-code-prettify to highlight source code in your posts.
- Google XML Sitemaps - this plugin will generate a sitemaps.org compatible sitemap of your WordPress blog which is supported by Ask.com, Google, MSN Search and YAHOO.
- Lightbox 2 - used to overlay images on the current page.
- pb-techTags - enhances the_tags() by adding a link to Technorati to each tag.
- SIOC Plugin - adds SIOC metadata export to WordPress blog.
- Slashdigglicious - add user-submission icons and links at the bottom of each post: Digg, del.icio.us, etc.
- Snap Shots Plugin - add Snap Shots to your website or blog. Snap Shots enhance links with visual previews of the destination site, including summaries of Wikipedia and IMDb, YouTube videos, stock charts, RSS feeds and more with just a single line of javascript.
- SpamBam - a plugin that hopefully eliminates comment spam.
- wp-cache - very fast cache module. It’s composed of several modules, this plugin can configure and manage the whole system.
If you can recommend other plugins, don’t hesitate to do that - just describe them in a comment to that post. Cheers!
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
I’ve heard that SQL Server developers happen to have problems with CONVERT function when try to obtain a value of datetime type. Recently, I’ve had that problem during a Data Transformation Services (DTS) package implementation.
One of the task in that package was “Transform Data”, which transferred data between a source and destination. To retrieve that data, I used SQL query within which I needed to add a number of milliseconds to a given date. The following snippet shows what I really wanted to execute:
dateadd (millisecond, ?, convert(datetime,?))
In abovementioned snippet, both question marks (?) are different parameters used in that query. The former is sINTEGER (the number of millseconds) whereas the latter is the date kept as VARCHAR. The latter parameter needs convertion to DATETIME.
Unfortunately, I could’t achieve what I really wanted. When I put the abovemeantioned snippet in the query in “Transform Data Task Properties” window, I couldn?t even save it ? got the following error: “… argument data type datetime is invalid for argument 2 of dateadd function”.
I spent some time analyzing what was going on. I ran thas query in Query Analyzer with hardcoded values and it was ok. Finally, I used Profiler tool to see what exactly happened when the task (and consequently that query) was run. That gave me the explanation: the second parameter was unnecessary converted by the engine which executed that package. After that convertion, the value of that parameter was wrong and finally was converted second time to a wrong DATE value.
The solution to that problem is quite easy: the described query can be put in a stored procedure which is executed during the transformation. The SQL engine had difficulties defining the data types of the parameters. Luckily, in a stored procedure, the data types are explicitly defined.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
Xobni is declared to be a new look at your email. Even the neme is tightlt connected to email - “xobni” is the word “inbox” backwords 
All in all, Xobni is a plugin for Microsoft Outlook that comes along with Microsoft Office. According to the authors Xobni allows:
- fast email search
- extract phone numbers from emails
- fast access to email attachments
- view emails as threaded conversation
- navigate your inbox by people
- presentic email statistics
Currently, Xobni works only with Microsoft Outlook. In future it is planned to assist Yahoo Mail, Gmail, Thunderbird and other email platforms.
The first impression is great. However, I haven’t tested it yet because I couldn’t download it. In the download page I could only read:
We have reached the limit of our open-invitation beta period. We will be rolling out beta invitations over the next several weeks.
The only thing I could do was to sign up and wait for invitation to download this tool. Still waiting…
Should you have any experience with Xobni, please share it.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
I learned SQL (basic and quite advanced stuff) at the univerity a few years ago. I’ve been using SQL commands quite often; it’s difficult to imagine an application or a web page without a database in the back-end.
Recently, I’ve discovered I remember little about using JOIN command in SELECTs. There are a few types of JOINs; however, I’ve been using mostly INNER JOIN. I decided to change that and refresh my knowledge in that field. This way, I created the examples queries and put them in the post you’re reading.
Continue reading ‘SELECT + JOIN’
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
