Tim Maxey | Tampa Bay Web Design

Could not find stored procedure

Tim Maxey — Fri, 30 Sep 2011 12:54:33 GMT

I haven't had to use a direct call to a stored procedure in a long time, but came across the could not find stored procedure error. (And yes I had all security set fine). If I uncommented out the "commandType" it worked!

Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("myconnection").ConnectionString)
        Dim cmd As New SqlCommand
        Dim execStr As String = "EXEC dbo.InsertActivity " & userid
        cmd.CommandText = execStr
        'cmd.CommandType = CommandType.StoredProcedure DOES NOT WORK WITH THIS UNCOMMENTED, WEIRD
        cmd.Connection = conn
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()
        cmd.Dispose()

Tethering on DROID X Verizon just fine

Tim Maxey — Tue, 05 Jul 2011 12:24:13 GMT

Click on the link below to start tethering with no problems on Verizon with Gingerbread! Thank you to the guys over at:

Geek Sailor

In fact, I am posting this blog post from the tethering software, installed quick and worked fast!

Reset forgot nopcommerce admin password

Tim Maxey — Wed, 29 Jun 2011 19:41:58 GMT

So you forgot and can no longer get into the nopCommerce administration? Easiest way to do it is this:

1. Register a new user from the main website
2. Open SQL server and update that user to "IsAdmin=1"
3. logout and login with that same user
4. Goto the administrator and customers and change whatever account your need etc..

Hope this helps!

Android SDK and AVD Manager not Installing Packages

Tim Maxey — Wed, 29 Jun 2011 02:41:24 GMT

I came across the problem of when I wanted to update my Android SDK, or add Google Maps api, or add the Google Checkout, Licensing packages, I'd get "nothing installed" and some crap about can't update the packages, check the path etc, etc..

Well come to find out, you got to go to the start menu, Android SDK Tools right click on the SDK Manager and run as Administrator...

I just happen to try that and it worked! Hope it helps someone else out there!

Microsoft.VisualStudio.OLE.Interop.IServiceProvider’

Tim Maxey — Wed, 04 May 2011 14:55:33 GMT

Microsoft SQL Server Management Studio: An error with a message like “Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{6D5140C1-7436-11CE-8034-00AA006009FA}’ failed due to the following error: No such interface supported (Exception from HRESULT: 0×80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

My error, the first solution, download the cmd file this dude made and run as admin, reboot, geesh! It worked for me, hope it works for you and gets on Goolge, save someone some time!

http://www.davidmoore.info/2009/08/19/solution-explorer-open-each-folder-in-same-window-error-and-sql-management-studio-ie-and-team-explorer-errors/

BlogEngine XML Migration Provider

Tim Maxey — Mon, 07 Mar 2011 14:39:12 GMT

So on my TimMaxey.com blog I am using BlogEngine.Net, a great opened source Blog software! I am not sure which one I like better, this one (SubText) or BlogEngine. (I am leaning towards BlogEngine for the XML provider...

So anyway I was using MySQL as the provider for my blog over there and I wanted to change it to the XML provider. I found a great article and zip file for the migration. It also works for going from XML to a Database, but I hadn't tried that yet.

Worked like a champ, but remember to change ALL DEFAULT providers in the web.config to the the xml provider. I orginally only set the first one in the web.config and kept getting garbage characters when I tried to login, finally realized I didn't change the security, roles etc provider deep in the web config to the xml provider. All good now!

Here the post: http://www.nyveldt.com/blog/page/BlogEngineNET-Provider-Migration.aspx

RegEx RegEx.Replace Regular Expressions Explained

Tim Maxey — Thu, 11 Nov 2010 21:24:54 GMT

Ok, gonna try to explain this, for me and for you:

I needed to strip apart a strap number like U-22-29-5J5-0000.20 and pass it to the property appraiser's site like: 29225J5000020U

Now how do you do that? You have to use Regular Expression Replace, so pattern the above like this:

([0-9a-zA-Z]{1})([\w-]{1})([0-9a-zA-Z]{2})([\w-]{1})([0-9a-zA-Z]{2})([\w-]{1})([0-9a-zA-Z]{3})([\w-]{1})([0-9a-zA-Z]{4})([\w.]{1})([0-9a-zA-Z]{2})

Say what? huh? Let's break it apart. The above regex is the "pattern" to look for, so we are matching in the first () i.e. ([0-9a-zA-Z]{1}) all numbers and letters. Note: each character in the orginal strap is represented by "something" in parentheses ()

This first set ([0-9a-zA-Z]{1}) is the "U" notice the [ ] then the { } we have a {1} to represent only one character and what's inside the [ ] is normal regex matching for numbers and letters. Then the next character ( a dash - ) is represented like ([\w-]{1}) (The \w is match word characters like dashes or periods, in our case toward the end I use ([\w.]{1}) to represent the period toward the end of the strap string.

So if you follow the above "pattern" it will match the orginal strap. Now we do this so we can replace, move stuff around, each section or what is in the parentheses is a unit, or in our instance, there are 11 section patterns, does this make sense? ([0-9a-zA-Z]{1}) is 1 and ([\w-]{1}) is another (2), ([0-9a-zA-Z]{2}) is 3 etc, etc,

So our "replace" filter is represented by a $ then the "section" number, so in our case since we need U-22-29-5J5-0000.20 to look like 29225J5000020U, we need the 5th section first: $5, then we need the "22" which is the 3rd $3 and so forth until we get this: $5$3$7$9$11$1

Broken down:
U = 1
- = 2
22 = 3
- = 4
29 = 5
- = 6
5J5 = 7
- = 8
0000 = 9
. = 10
20 = 11

Now we can use this is a RegEx.Replace

This example is VB.NET but you could do it for whatever supports RegEx.Replace...

Dim strP as String = "([0-9a-zA-Z]{1})([\w-]{1})([0-9a-zA-Z]{2})([\w-]{1})([0-9a-zA-Z]{2})([\w-]{1})([0-9a-zA-Z]{3})([\w-]{1})([0-9a-zA-Z]{4})([\w.]{1})([0-9a-zA-Z]{2})"
Dim strR as string = "$5$3$7$9$11$1"
Dim mynewstrap = RegEx.Replace("U-22-29-5J5-0000.20",strP,strR)

The variable mynewstrap now = 29225J5000020U

Alternatively if you needed the "new" strap to be 29/225J50000/20U (notice the forward slashes) how would you do that?

Dim strR as string = "$5/$3$7$9/$11$1". Hope this helps, you can really do a lot with this stuff, mix and match etc, like the 5J5 for instance, that "section" ([0-9a-zA-Z]{3}) could be "broken" up if you needed the J in the front, so that section would then become ([0-9a-zA-Z]{1})([0-9a-zA-Z]{1})([0-9a-zA-Z]{1}) and the $numbers would be:

5 = $7
J = $8
5 = $9

and the rest of the sections would now have different numbers

- = $10
0000 = $11
. = $12
20 = $13

Then if you needed this U-22-29-5J5-0000.20 to look like this J292255000020U, then the strR would look like this:

$8$5$3$7$9$11$13$1

Hopefully this all makes sense to me the next time I need it!!!

How To Remove Google Redirect Virus

Tim Maxey — Wed, 20 Oct 2010 14:42:40 GMT

Many thank to this blog entry for my help!!! http://www.review-buddy.com/spyware-removers/how-to-remove-google-redirect-virus.html

"Google Redirect Virus is a parasite which is created by some online criminals to hijack user’s Google search results. The main purpose behind redirecting Google search results and hijacking them is, getting users to visit malicious websites and have them purchase rogue software or trick them into other on-line scams. The criminals who have created this google hijack virus know that people search Google everyday and they can take advantage of it to make money for themselves.

There are lots of ways your system can catch this infection, but It is carved in stone that you have visited a malicious website unknowingly. It is very possible that you are not aware which malicious website you visited since those websites look very professional but inject the trojan on user’s computer by display fake online scanners. The other reason supportive reason for this infection is, your antivirus software is not be capable of stopping spywares efficiently.

Lots of people complain on forums that they have an Antivirus Software installed but their computer still got infected. There are several reasons for this :

1. Your Antivirus software is not capable of detecting and removing spywares. In this instance, you must get a powerful antispyware software in your system which provides real time protection.
2. If your Antivirus software supports removing spywares, its database may be out of date and without updating its definitions frequently, it will not be able to detect the latest threats. Make sure to update the software frequently and better set the updates to automatic mode.
3. The Antivirus software you are using is simply not powerful and it has no information of Google Redirect Virus in its database and It simply failed to recognize this threat.

When you system gets infected with Google Redirect Virus, you’ll be redirect to malicious websites once you click on the search results and It doesn’t matter If you are using Internet Explorer, Firefox of Opera. You’ll search on Google and click on the desired result but you’ll automatically get redirect to a website which you really don’t intend to visit. Most likely, you’ll be redirected to malicious websites which will give more pain to your computer by injecting other Trojans in your system. As soon as you discover that search results are being redirected, please stop clicking on search results and work on solving this redirect virus problem. You can even get some very nasty fake antivirus programs which are very hard to get rid of. You will click on right result but your browser will take you to a malicious website. "

Ok so after reading and downloading the software that ONLY worked for me, I was fixed. Took me like 3 hours of my afternoon to finally fix the darn thing! Here is what the post above said and I have copied it here for all!

This virus is very dangerous and It infected my computer when I visited a music related website which was obviously malicious. I spent almost 2 days trying to remove this virus and ran several scans with different spyware removers but no joy. It was a real nightmare sitting in front of PC till 5 AM in the morning and still the virus was laughing at me.

After that, I researched about this malware on various forums, blogs and other websites. Finally, I found a solution which worked for me and I want to share it with everyone. During my research, I gained a lot of knowledge about this virus and here is the solution for you. Please follow these steps literally to remove Google redirect virus permanently :

"1. Please bookmark this page as you may need it later and may have trouble finding it again.

2. First of all, please Download TDSSKiller (not a virus, my first thought when I downloaded it, but it worked!) and run it in your system. It is a very small (just 900 KB Size) utility and It scans your computer for the hidden services created by this redirect virus. Most Spyware Removers will fail removing this virus because they don’t scan for hidden services.

3. After downloading, please run this utility and It will start scanning your computer. I’m pretty certain that It will find malicious hidden services and remove those malicious services at its own.

4. Don’t restart your computer yet! Now you need to scan your computer and and delete the traces of Google redirect virus. This virus can have its files hidden deep in folders and it is almost impossible for anyone to identify those files without scanning the whole computer. If you let those files reside in your computer, the virus will be back at any time bugging you again.

For scanning your computer to find the culprit files, please click on the button below to download the most powerful legitimate Spyware Remover and install it in your system. After installing, please scan your computer and delete all the infections in finds."

OK, so now I had to download "Spy Doctor" and I paid for it, like $29 (and yes I already had spyware software I paid for before, but it DIDN'T ever find my parasite!!! This did, I downloaded it and it that combined with TDDSKiller, I was FREE!! Thank you review buddy!

You can download Spy Doctor right here!

This all worked for me! I hope it fixes it for you, this parasite is a pain in the butt!

You can also get SpyDoctor with antivirus which works too, but mo money!

Spyware Doctor with AntiVirus is a top-rated malware, spyware & virus removal utility that detects, removes and protects your PC from thousands of potential spyware, adware, trojans, viruses, keyloggers, spybots and tracking threats.

Download Here!

If you are still having issues, there are manual removing as well, refer to review buddy's blog:
http://www.review-buddy.com/spyware-removers/how-to-remove-google-redirect-virus.html