SyntaxHighlighter

Friday, 22 July 2011

Quick Review of Asus EEE Pad Transformer

Well, I've not long opened my new Asus EEE Pad Transformer and so far everything is really sweet with it! My major gripe at the moment is the lag between the docked keyboard and the browser - it's shockingly slow!

That aside, the tablet iteself is really nice and the on-sreen keyboard works with no lag :) The docked keyboard randomly makes you go somewhere else on the screen (especially in the browser) and I keep end up typing something in the address bar - well annoying!

I can pretty much second what everybody else has said on their reviews of this device - and honestly - it is really nice. I purchased it to use it as a work tool as well an internet browser. So TeamViewer is on and working a treat on the nice 10.1" screen.

I'll no doubt put more details with how I get on with this as time goes by...but for now, it's play time!

Friday, 15 July 2011

Sending Email using VBScript via Google Apps Mail / GMail

Following on from my previous post Sending Email using ASP.NET via Google Apps Mail / GMail, I have needed to send an email via GMail / Google Apps using VBScript. So here it is...

Dim objMessage

Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "MY_SUBJECT"
objMessage.From = "FROM_ADDRESS_SAME_AS_USER_NAME"
objMessage.To = "TO_ADDRESS"
objMessage.TextBody = "MY_MESSAGE"

objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/smtpusessl") = true
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/sendusername") = "MY_USER_NAME"
objMessage.Configuration.Fields.Item( _
"http://schemas.microsoft.com/cdo/configuration/sendpassword") = "MY_PASSWORD"
objMessage.Configuration.Fields.Update

out = objMessage.Send
Set objMessage = Nothing

Thursday, 14 July 2011

Linux / Unix Commands

Found myself the last few days having to use a lot of Unix commands and have been using this site to help me with commands and syntax: http://www.computerhope.com/unix.htm#04

Friday, 24 June 2011

How To Enumerate / Iterate an Enum

I often find myself needing to iterate/enumerate an enum. It's dead easy, but seem to always forget! What a fool ;)

Anyway, here ya go...

Public Enum MyEnum
    Jim = 0
    Bob = 1
End Enum

For Each e As MyEnum in [Enum].GetValues(GetType(MyEnum))
    Console.Write(String.Concat(e.ToString(), "=", Int32.Parse(e)))
Next

The GetValues method is quite useful as you can also get stuff like the length from it:
[Enum].GetValues(GetType(MyEnum)).Length.

The C# is pretty much the same just that [Enum] has no square brackets around it.

Wednesday, 22 June 2011

Auto Trimming - Whitespace Removal in SQL Server/MSSQL

I got really angry about this one yesterday as I can't see one possible reason why this "feature" would be required.

If you run this script, the whitespace padded string is also returned along with the unpadded string.

CREATE TABLE #t ([col1] varchar(100))

INSERT INTO #t ([col1]) VALUES ('hello')
INSERT INTO #t ([col1]) VALUES ('hello     ')

SELECT '''' + [col1] + '''', LEN([col1]), DATALENGTH([col1])
FROM #t

SELECT * FROM #t WHERE [col1] = 'hello'
SELECT * FROM #t WHERE [col1] = 'hello     '

DROP TABLE #t


How can this possibly be right? If I want 'hello     ' to be returned, then return 'hello     ' not 'hello'. These are two very different strings!

Peoples arguments are why would want to save that and other such silly statements. My philosophy is, if I can think of it, it will happen! I can think of many cases where it would be beneficial to have the padding - dealing with old systems or external systems over which control is not possible.

Now I know that SQL Server does this stupid thing, I can account for it - but seriously - why?? It's stupid!

Oh and ANSI_PADDING - makes no odds!

Thursday, 16 June 2011

Clear / Remove Recent Projects in Visual Studio

For those of you still unlucky enough to be using Visual Studio 6 out there this is how to clear the recent Visual Basic projects from the recent projects list:

  1. Run regedit from Start > Run
  2. Go to KEY_CURRENT_USER\Software\Microsoft\VisualBasic\6.0\RecentFiles
  3. Delete or change the paths as necessary

For more recent versions of Visual Studio, clear the recent project list by doing this.

Tuesday, 14 June 2011

MSSQL Saving Change is not Permitted (Prevent)

This was a cheeky one I came across today. Where I was getting the following message from SQL Server 2008 in the table designer:
Saving change is not permitted. the changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.
The solution is to change the setting by using the menu: Tools > Options > Designers, then unchecking the "Prevent saving changes that require table re-creation" box.


 Guessing it's not a problem and more like a feature. Little bit odd, but I can understand why...

Thursday, 9 June 2011

Website Availability Monitoring

I was looking for a tool that would easily monitor the availability of a website that I work on. This particular site has a tendency to become unavailable. Usually some kind of network related issue.

Anyway...
After some hunting around I came across www.siteuptime.com. They have a range of packages, but I used the free one as that gave me enough for this site. It's checking every 30 minutes and the reporting seems pretty much spot on. The service will email me if the site becomes unavailable, so hopefully I'll spot it much sooner now!


Tuesday, 7 June 2011

System.Web.Services.Protocols.SoapException: The permissions granted to user 'IIS APPPOOL\MyUser' are insufficient for performing this operation

I had this error (System.Web.Services.Protocols.SoapException: The permissions granted to user 'IIS APPPOOL\MyUser' are insufficient for performing this operation) and took me a while to work out what to do to fix it. All the references I found  to it were relating to SharePoint.

In my instance I had added a web reference to my application to make use the reporting services (SSRS) web service (http://localhost/ReportServer/ReportExecution2005.asmx). Although it was working locally, it was not working when I deployed it to the dev or live server.

Turns out the account that is used by the reporting services service account needed to be the same as the account that the application pool was using.

So check the service account in the reporting services configuration tool:


Then from within the IIS, change the identity that the application pool is using (right click the pool and choose Advanced Settings...):


FYI, here's the full error message:
System.Web.Services.Protocols.SoapException: The permissions granted to user 'IIS APPPOOL\MyUser' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'IIS APPPOOL\MyUser' are insufficient for performing this operation. at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo2& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)


Monday, 6 June 2011

Remove Importance Markers from GMail

GMail recently introduced the importance marker as part of their priority inbox feature. I accepted the setting to see how it worked. It wasn't for me so I wanted to turn it off. So this is how to do it...

Go to Mail Settings and choose the Priority Inbox tab. Then set the Importance markers option to No markers and click Save - Happy days :)


Thursday, 19 May 2011

Compacting a Microsoft Virtual PC (VPC) Hard Disk

Depending on how busy your VPC installation is, it can grow massively beyond the size it really needs to be, so periodically it is very useful to compact it.

So here is an MSDN blog on how to compact a virtual PC image.

Wednesday, 20 April 2011

Format of the initialization string does not conform to specification starting at index

When I recently moved a site from the dev location to the live location, I got presented with Format of the initialization string does not conform to specification starting at index when trying to make a database connection.


This obviously wasn't happening on the live and the connection string, which was in the Web.Config file, was correct. I was using SQL authentication and the password had both semi-colons (;) and ampersands (&) in it. I wasn't sure which character was causing the problem. As I was able to, I changed the password for the user (removing the ;&). All worked a treat then :)

Tuesday, 19 April 2011

Test a POP3 Connection (Telnet)

I often find myself needing to be able to check a username and password combination for somebodies email connection (normally because they have forgotten their password - again!). A really quick and easy way to do this is using telnet. Here's the easiest way to do it, from the DOS/command prompt:

> telnet mail.mydomain.com
> user my_user_name
> pass my_password


At this point, if all is good, you will have made a successful connection. Show all messages as a list using:

> list

If you want to see the contents of a specific mail then use:

> retr mail_item_number

If you leave the connection with no activity then it close the connection itself, but preferably use:

> quit

There are some more telnet commands here. Also, if you using an IP address, you may well have to use a port number (usually 110). e.g. 123.123.123.123 110

Thursday, 7 April 2011

Could not establish trust relationship for the SSL/TLS secure channel with authority

I recently had this error (Could not establish trust relationship for the SSL/TLS secure channel with authority) when trying to make a remote call from a C# web app. I hunted around and came across this article on thejoyofcode.com.

ServicePointManager.ServerCertificateValidationCallback = new System.Net.Security.RemoteCertificateValidationCallback(
    delegate
    {
        return true;
    }
);

So I used the suggested code to bypass the certificate verification, but got a trust level permission error. In order to get round that I modified the Web.Config file to have the trust level set to Full.

Just for the record, this is a quick and dirty hack while I sort out what the actual problem is ;)

Wednesday, 6 April 2011

Free File Recovery

We've all been there - deleted a file we shouldn't have - oops! Well, thanks to this article on LifeHacker we can take a big sigh of relief and use MiniTool Power Data Recovery.


It's free for personal use and chargeable otherwise.

Thursday, 31 March 2011

Microsoft Image Composite Editor

I came across the Microsoft Image Composite Editor courtesy of @bbcclick. It allows you to very easily put together large landscape images. It was quite happy to take these 3 images:


And turn them into this:



It does all the alignment and colour standardising itself - happy days :) It can do other stuff too and I would argue that the join lines are impossible to see.

Here's another:


Friday, 18 March 2011

Changing the RAM/Memory Setting in Microsoft VPC

I recently added a shed load more memory to my lappy (thanks Orca), so I finally got round to increasing the memory on the various VPCs I use. So I did the usual of going to the settings, but the memory slider (to choose how much you want to assign) was not there. Not disabled. Not there at all!

In the end I removed the VPC (I didn't physically delete it, just removed it) and added it again, using the wizard. Hey presto, just like magic, I could change it again.

It's a bit like the old "have you turned it off and on again?"...

Monday, 28 February 2011

I Forgot What Access Was Like...

I haven't used MS Access for a fair while now. There was a time when I used to have use it loads. Thankfully not so much now. The more the years have gone on the more the glorified filing system has got annoying. I remember the good old days of 97 when it did what it said on the tin and didn't try to be too clever for it's own good.

I have had the unfortunate opportunity of using it again today in anger. What a ball-ache! That much of a ball-ache that I decided to blog while I, once again, wait for this update query to run (which would take a matter of seconds in SQL Server). 20 minutes in and I'm slightly bored!

That coupled with my previously stated hatred of IIf, that got right on my tits! So another annoyance to add to that is that you can only have up to 6 nested IIf statements - great! I needed 36. Switch was no good either - that only goes up to 15 (at least in the query editor anyway).

So regular crashes and constant "not an updateable query" messages later - I'm still waiting... Roll on tomorrow so I can get back to a real database and a proper programming language!

Friday, 4 February 2011

Blogger App on Android

Finally here! An android app for Blogger >> http://market.android.com/details?id=com.google.android.apps.blogger

So in honour of it here is a post using it.

Biggest issue far is that there is no formatting - not even basic stuff. But I'm sure that will come...and existing posts aren't available to view.

Thursday, 3 February 2011

If You Can Think Of It, It Will Happen!

Just had a really good one :)

If there's a faint possibility that a parameter for a routine might change, I whack it in the config. Now doing what I do means I work with a lot of different types of coders some good (not many) and some bad (surprising how many!). Anyway, one particular guy is one of those why would they ever want to do that or what's the point, that'll never happen types of guys. Fine - if he wants to do as little possible then that's fine. But. And it's a big but.

Today, the remote mail server they use for emailing from within their web applications has been changed and no longer allows remote mails to sent. Oops!
So all smug I say "just swap the mail server address that you'll have used in your config to use localhost - everybody's happy"
Him - guess what it was...drum roll..."like that's gonna happen, they're all hard coded, gonna take ages to swap all them!"
Me (raising my eyebrows with a small lips twist): "oh well..."

So I feel really good about that :) A classic example of if you can think of it, it will happen syndrome.

Labels

.net (7) ajax (1) android (7) apache (1) asp.net (3) asus (2) blogger (2) blogspot (3) c# (16) compact framework (2) cron (1) css (1) data (1) data recovery (2) dns (1) eclipse (1) encryption (1) excel (1) font (1) ftp (1) gmail (5) google (4) gopro (1) html (1) iis (3) internet explorer IE (1) iphone (1) javascript (3) kinect (1) linux (1) macro (1) mail (9) mercurial (1) microsoft (3) microsoft office (3) monitoring (1) mootools (1) ms access (1) mssql (13) mysql (2) open source (1) openvpn (1) pear (2) permissions (1) php (12) plesk (4) proxy (1) qr codes (1) rant (4) reflection (3) regex (1) replication (1) reporting services (5) security (2) signalr (1) sql (11) sqlce (1) sqlexpress (1) ssis (1) ssl (1) stuff (1) svn (2) syntax (1) tablet (2) telnet (3) tools (1) twitter (1) unix (3) vb script (3) vb.net (9) vba (1) visual studio (2) vpc (2) vpn (1) windows (4) woff (1) xbox 360 (1)