Setting up SQLite on 64bit Windows 7

File:SQLite370.svgIf you try to install the 64 bit version of SQLite on your Windows 7 64 bit system, you’ll find that your code will break.  It simply won’t work.  You’ll also find that when you try to add a connection in “Server Explorer” inside of Visual Studio, that there’s no option for making a SQLite connection.

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

image

This is because, for some reason, none of the current versions have the install for a SQLite connector.  For that, you’ll have to install the really old version 1.0.66.0 executable first.  After that, you can install the latest 32bit version (the 64bit version doesn’t work).  Once 1.0.66.0 is installed, you’ll have SQLite available in Visual Studio:

image

You can get v 1.0.66.0 from here:

You can download the 32bit DLLs here sqlite-netFx35-setup-bundle-x64-2008-1.0.77.0.zip:.  It’s under the section titled “Precompiled binaries for Windows”.

See these images?

imageimage

You’ll find an actual working versions of them at the top and bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.

Check back later for updates too!

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

[poll id=”3″]

That’s it.  Good luck!

Review: Acer All-In-One AZ3731-UR21P Touch Screen Computer

 

imageB004X5XVL8_image_1

image_thumb[1][1]

I’ve recently downgraded this system from 4 stars down to 2 stars.  Check back soon for WHY.

The most prominent feature of this PC is that it has a Multi-Touch monitor!  Yes!  You can control the PC by touching the screen!  The next most prominent feature is how inexpensive this was.  The ENTIRE set up was cheaper than most touch screen monitors.  I mean, the whole PC, monitor, keyboard, mouse, software, EVERYTHING was cheaper than a single touch screen with no PC or anything else.  This PC retails for $649 at the time of this writing.

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

I bought this for my daughter for Christmas 2011.  She was at the house when UPS dropped it off, so it was no longer a surprise, so we went ahead and opened it and gave it to her (no sense in wasting 30 days of a 90 day return warranty!)

Note, the actual warranty is a 1 year, limited warranty.

Note that we’ve had about a month and a half experience with this at the time of this writing.  So, let’s get started:

Unboxing

It came in one box about 4 feet wide, 2 feet tall, and 8 inches thick.  There was a box with the mouse and keyboard in it and there was the computer between two large Styrofoam protectors and wrapped in a cushy bag.  The keyboard and mouse are wireless and came with a tiny USB receiver.

Note that this is an all-in-one PC.  That means the monitor and the PC are one piece of hardware.  Just as the picture indicates, you’ll have 3 items on your desk.  The PC, keyboard, and mouse.  That’s it, which was nice not having tons of cables and junk to mess with.

Hooking it up

This was, by FAR, the easiest set up of a desktop PC I’ve ever had!  There’s only ONE cable!  ONE!  And that’s the power cable.  I plugged in the wireless receiver to a USB port on the right side of the monitor.  I pulled the tab from the battery compartment on the mouse and turned on the mouse.  I added the provided batteries to they keyboard (2 AAA) and I plugged in the power cable.

When I turned it on, it recognized the wireless keyboard and mouse and booted into the Windows 7 Home Premium desktop.  I created my admin account and my daughter’s user account.  It found my wireless network and I entered the credentials and was online in seconds.

That’s it!  DONE!  And it’s nice having only ONE cable!  I can’t express now nice that is!  Really!  Look at MY cable set up on my own PC (Note:  This is NOT the cables of the Acer PC in this review… This is to show how bad things can be without the Acer PC in this review!!!)

image

And this is AFTER a MAJOR clean up!  This is as good as it gets with my PC!

ShovelWare/CrapWare

“ShovelWare” or “CrapWare” is crap software that computer makers like to load up your new PC with.  Most of it is usually trial software for anti-virus software, games, and utilities.  Most of it is usually CRAP!  Many times it slows down the booting of your PC and interferes with the performance while using it.

PC Magazine defines it as:

“Refers to the many “extra” programs pre-installed on some PCs that offer little value (they are “shoveled” in without regard to quality). Also called “crapware,” shovelware is geared to first-time buyers, who think they are getting more for their money. The term first appeared in the mid-1990s when tons of shareware programs were copied onto CD-ROMs and advertised in magazines or sold at computer flea markets.

UrbanDictionary.com defines it as:

“an array of haphazard software emphasizing quantity rather than quality

This shit is totally half-assed. Who assembled this shovelware?

This computer is no exception.  I won’t list the junk that’s on there, but there’s plenty of it.  I uninstalled all that had no redeeming value.

What’s Unique, Software-wise?

It is nicely configured for touch capability with oversized title bars and buttons on the title bars of all windows (easily user configurable since the early 1990’s, BTW).  It has an icon in the upper-right on the desktop.  When you touch it, it slides out a touch interface for several touch programs and settings.  It’s pretty nice.  BTW, if you haven’t tried Google Earth with a multi-touch monitor, you’re missing out on life!

There’s a touch, video keyboard to and you can even use it to log into Windows.  It works well.

Windows Paint, which is not an awesome paint program by any measure, works very well with touch, and even with multi-touch.  Let’s go ahead and define multi-touch.  That’s the type of touch interface that can respond to multiple touches at the same time, as opposed to touch screens, like the older Windows Mobile phones (and most others in the pre iPhone era) that could only recognize ONE touch point on the screen at a time.

Specs

I won’t repeat all the specs here.  If you want a full spec sheet, click here for it on Acer’s web site.

In short, it has:

  • 64bit Windows 7 Home Premium
  • Intel Pentium E6700 Dual-core 64bit 3.2Ghz processor.
  • 4GB RAM (you can max it to 8GB)
  • 1TB Hard Drive, 5400RPM
  • DVD-RAM/+-R/+-RW optical drive.
  • Full HD monitor (1920×1080)
  • Full Multi-Touch capability on that monitor.
  • Gigabit Wired Ethernet, 802.11b/g/n wireless.
  • WebCam built into top of monitor, like a notebook, with mic.
  • 6 USB 2.0 ports.

 

Performance

I didn’t run any benchmark tests on it, but it is plenty fast from my own, personal testing and I’m an overclocking geek with a QuadCore CPU on my own desktop (NOT THIS COMPUTER that I’m reviewing!)  Games and graphics software and the whole user experience is very zippy.  I noticed no lags on anything important.

Problems?

  • Sliding your finger across the screen to say, drag a window is kind of difficult at times as your finger tends to be kind of sticky on a slick surface and bounces, losing contact.
  • There appears to be a membrane in front of the monitor made of a thin, flexible plastic and it seems to NOT be attached and almost wrinkles while sliding your finger across the screen.

Conclusion

My daughter is highly pleased with it and spends an awful lot of time on it both browsing the web and using the paint software.  I also installed several other graphics programs for her as she is a bit of an artist.  I was pleasantly surprised at the ease of set up and the fact that there’s only ONE cable!  That just astonishes me!  The performance is great.  The multi-touch screen is awesome.  It comes with plenty of RAM and hard drive space, and the low price is fairly shocking considering what all you get.  I’ve always been pleased with Acer hardware.  They tend to have the best bang for the buck and they didn’t disappoint with this computer.

My daughter, who uses it much more than me says she’s “really likes it” and the only problem is the touch on smaller items is difficult to touch the right thing.

I’m giving it 4 out of 5 stars.

image

The only thing holding it back is the shovelware and the wrinkly film on the touch screen.

See these images? imageimage
You’ll find an actual working versions of them at the top and bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.

Check back later for updates too!

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

Is Google+ boring to you because it seems like no one’s there?

Well, if that’s the case, then you’re using it wrong.  There’s more activity on Google+ than you can shake a smartphone at!  Remember, G+ is NOT Facebook!  You can follow anyone, even if they don’t follow you back!  You just have to start following some interesting people.  It doesn’t matter if “my friends are all on facebook”!  I’ve met TONS of interesting people on Google+, 99.9% of which I’ve never met in person.

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

Do this:

  1. Fill out your Google+ profile page, specifically, your profession and interests (but don’t put too much personal information there… remember, this IS publically available to all pedophiles, stalkers, sex offenders, burglars, etc… and THEY use the internet too… probably more than YOU do!)  (Be careful what you publish about yourself or your loved ones online!)
  2. Now, find some interesting people:  In the “Search Google+” bar at the top, search for something you’re interested in.  Then click the “Search Google+ for” item right under your original search term:
    1. image
  3. You’ll get PLENTY of results of posts by fellow G+ users that match your search.  If you like what they have to say, click on their name and it’ll take you to their profile.  Look at their posts.  Are they interesting?  The add them to your circles!  Now you’ll see their public posts.  They might follow you back too!  Feel free to comment on their posts if you have something to add or ask.  You’ll get responses!  Now, go!  Go do it!
    1. image

 

Other things you can and should do:

  • Go to SocialStatistics.com.  You’ll find the most popular Google+ people and posts.  You’ll find plenty of people to follow there too.
  • Go to PlusCloutand find popular people from G+ there too.
  • Write some posts about things you’re interested in.  Be sure to post them public.
    • image
  • Comment on other posts.  People will interact with you and you’ll likely get some people to start following you!
  • Post your Google+ ID on Facebook and Twitter (the whole URL from your profile page).
    • image
  • Invite friends and family to start using Google+.

 

Google+ has a cleaner user interface and is more secure that Facebook.  Just be careful when you post.  Don’t post publicly unless it’s something you want everyone to see and don’t care if it’s seen by your employers, friends, parents, kids, future employers, grandkids, great grand kids, and your entire family lineage for generations to come, because it will never go away!  Be careful what you publish about yourself or your loved ones online!

See these images?

imageimage

You’ll find an actual working versions of them at the top and bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.

Check back later for updates too!

Click here to follow me on Google+.

Follow me on Twitter @CSharpner.

Check out my 3rd article on Chris Pirillo’s Lockergnome.com

imageI’ve been asked by Chris Pirillo to write some articles for his web site Lockergnome.com. This is my third article. It talks about the pros and cons of the new Windows 8 app store.

Windows 8 App Store:  What You Need To Know

If you haven’t heard of Chris Pirillo (and shame on you, if you’re a techie and haven’t), he used to host the TV show “Call for Help” on TechTV and lots of other cool stuff. You can follow him on Google+ here:

Follow Chris Pirillo on Google+

For that matter, you can follow ME on Google+ here:

Follow ME on Google+

I’ll be writing some more for Lockergnome.com, so check back here and I’ll post the links as they’re posted. I’ll also be announcing them on Google+.

Check out my 2nd article on Chris Pirillo’s Lockergnome.com

imageI’ve been asked by Chris Pirillo to write some articles for his web site Lockergnome.com. This is my second article.  It describes how to save money and protect yourself online when making purchases with a credit card.

Save Money and Protect Yourself with Your Online Purchases

If you haven’t heard of Chris Pirillo (and shame on you, if you’re a techie and haven’t), he used to host the TV show “Call for Help” on TechTV and lots of other cool stuff. You can follow him on Google+ here:

Follow Chris Pirillo on Google+

For that matter, you can follow ME on Google+ here:

Follow ME on Google+

I’ll be writing some more for Lockergnome.com, so check back here and I’ll post the links as they’re posted. I’ll also be announcing them on Google+.

Web.config and App.config variables can be fully type safe

I’m going to introduce a MUCH better way of accessing your variables that you have created in your web.config or app.config file.  Most likely, you’re probably storing your variables in your .config file like this:

Click here to follow me on Google+.

 <appSettings> <add key="EMailAddress" value="me@something.com"/> <add key="IsProduction" value="true"/> <add key="MaxWait" value="15"/> appSettings>

And your code to access them probably looks like this:

this.EMailAddressLabel.Text = ConfigurationManager.AppSettings["EMailAddress"];if (ConfigurationManager.AppSettings["IsProduction"] == "true") this.NotProdNotifyLabel.visible = false;else this.NotProdNotifyLabel.visible = true;this.MaxWaitLabel.Text = "Maximum wait time is " + ConfigurationManager.AppSettings["MaxWait"] + " seconds";

That’s an awful lot of typing, has the potential for typos that aren’t caught by the editor or the compiler, doesn’t have intellisense, and is not type safe.

Solution!

Visual Studio has a very easy to use and very powerful feature for creating and accessing config variables.

Now, depending on what version of Visual Studio you’re using, things could be different.  As of this writing, the latest version is Visual Studio 2010.  But, this feature is available going all the way back to the original version of Visual Studio .Net back in February 2003.  So, it’s supported in all versions, but there are differences, not in how you do it, but in what choices you’ve already made for existing apps.  First, I’ll discuss doing this the right way when creating a new app:

BTW, this works for ALL .Net apps, not just ASP.Net web apps.  It works for WinForms, ASP.Net MVC, ASP.Net, Console apps, Windows Service Apps…

I’ll be using an ASP.Net WebForms app as an example, because that’s where the differences lie between the different version of Visual Studio.Net.

First, we’ll work with making a New app.

    1. Create a web app app.  Depending on your version of Visual Studio, you might have an option for “Web Site”.  DON’T CHOOSE THAT!  This whole solution is unavailable for web sites.  It MUST be a web app!

 

  • Right-click your project and choose “Properties:

 

  1. image

 

  • Click on the “Settings” tab.

 

  1. image

 

  • Click on the link, “This project does not contain a default settings file.  Click here to create one.”

 

  1. image

Now, your app contains what’s needed to support your simple typed config variables.  Notice the new stuff added to your project?

image

Now, never look at it again.  I just wanted you to see that it’s there.  This adds no complication to your life because you’ll never use it directly.  It’s just generated code.  Put it out of your mind and never think of it again.

Notice the grid that showed up on the screen?

image

This is where you’ll create your config variables… not in the config file itself.  This simple tool will automatically add them to the config file for you.  You don’t have to putz around with the messy config file anymore for your config variables.  Now, let’s add the 3 config variables we used the old way from the top of this article:

For each variable we create, we can choose the type of that variable!  Check out what happens when I create the IsProduction variable:

image

I picked “bool” from the “Type” drop down list.  Look at the “Value” column.  Notice that it knows what is valid for a boolean?  I’ll pick “True”.

Now, when I add MaxWait, I’ve got some options.  I can make it an int to represent number of seconds, but in reality, it’s representing a time span.  Guess what?  .Net has a TimeSpan type!

image

image

It inserts a value for me, showing me the format I need.  That’s HH:MM:SS, BTW.  I can add a decimal after the seconds to get milliseconds, if I want.  There’s a way to do days too, but I’ll let you figure that out.

I’m going to enter 15 seconds:

image

Now, this is important (but simple).  I need to hit “save”.

image

Now, look at what it did to the config file:

image

image

Now, there’s one more thing I want to draw your attention to… and it’s not important that you know this because you’ll never need to mess with this, but I want to give you a glimpse under the hood of what else has happened:

image

Pop open the Settings.settings branch and open the Settings.Designer.cs file:

 

 1: //------------------------------------------------------------------------------
 2: // 
 3: // This code was generated by a tool.
 4: // Runtime Version:4.0.30319.237
 5: //
 6: // Changes to this file may cause incorrect behavior and will be lost if
 7: // the code is regenerated.
 8: // 
 9: //------------------------------------------------------------------------------
 10: 
 11: namespace ConfigVarsSample.Properties {
 12: 
 13: 
 14:     [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
 15:     [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "10.0.0.0")]
 16:  internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {
 17: 
 18:  private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));
 19: 
 20:  public static Settings Default {
 21:             get {
 22:  return defaultInstance;
 23:             }
 24:         }
 25: 
 26:         [global::System.Configuration.ApplicationScopedSettingAttribute()]
 27:         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
 28:         [global::System.Configuration.DefaultSettingValueAttribute("me@something.com")]
 29:  public string EMailAddress {
 30:             get {
 31:  return ((string)(this["EMailAddress"]));
 32:             }
 33:         }
 34: 
 35:         [global::System.Configuration.ApplicationScopedSettingAttribute()]
 36:         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
 37:         [global::System.Configuration.DefaultSettingValueAttribute("True")]
 38:  public bool IsProduction {
 39:             get {
 40:  return ((bool)(this["IsProduction"]));
 41:             }
 42:         }
 43: 
 44:         [global::System.Configuration.ApplicationScopedSettingAttribute()]
 45:         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
 46:         [global::System.Configuration.DefaultSettingValueAttribute("00:00:15")]
 47:  public global::System.TimeSpan MaxWait {
 48:             get {
 49:  return ((global::System.TimeSpan)(this["MaxWait"]));
 50:             }
 51:         }
 52:     }
 53: }

This is the code that got generated for you.  Now, put it out of your mind (again), because you’ll never actually edit this file.

Now, remember the old way of accessing the config variables?

this.EMailAddressLabel.Text = ConfigurationManager.AppSettings["EMailAddress"];if (ConfigurationManager.AppSettings["IsProduction"] == "true") this.NotProdNotifyLabel.visible = false;else this.NotProdNotifyLabel.visible = true;this.MaxWaitLabel.Text = "Maximum wait time is " + ConfigurationManager.AppSettings["MaxWait"] + " seconds";

Here’s the new way:

Add this to your using section:

using

 

ConfigVarsSample.Properties;

And in your code, you do this:

image

Notice how you get intellisense?!?!?  Let’s continue:

var settings = new Settings();this.EMailAddressLabel.Text = settings.EMailAddress;this.NotProdNotifyLabel.visible = !settings.IsProduction;this.MaxWaitLabel.Text = "Maximum wait time is " + settings.MaxWait.ToString();

See how much cleaner this code is?  And, since it’s typed, you can use the IsProduction variable as a boolean rather than examining the text value of it.  The MaxWait variable can actually be used in time and date functions and directly in calculations!

What have you gained?

    1. Intellisense.

 

  • Edit time typo checking.

 

 

  • Compile time error checking.

 

 

  • Strongly typed variables.

 

 

  • Code that won’t fail at run time.

 

 

  • .config files that you don’t have to edit directly as often.

 

 

  • Increased productivity.

 

See this image?

image_thumb26

You’ll find an actual working version of it at the bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.

Check back later for updates too!

Click here to follow me on Google+.

Check out my article on Chris Pirillo’s Lockergnome.com

imageI’ve been asked by Chris Pirillo to write some articles for his web site Lockergnome.com.  My first article is how to choose the right kind of light bulbs to save the most money, taking just about all variables that affect your expenses into account.

How to Save Money with the Best Light Bulb

If you haven’t heard of Chris Pirillo (and shame on you, if you’re a techie and haven’t), he used to host the TV show “Call for Help” on TechTV and lots of other cool stuff.  You can follow him on Google+ here:

Follow Chris Pirillo on Google+

For that matter, you can follow ME on Google+ here:

Follow ME on Google+

I’ll be writing some more for Lockergnome.com, so check back here and I’ll post the links as they’re posted.  I’ll also be announcing them on Google+.

Google+ Netiquette

imageNow that Google has opened the flood gates to Google+ to anyone, without the need for an invite, it’s time to publish the proper netiquette on Google+.  If you’ve been lucky enough to have been in the trial phase, you probably noticed that, for the most part, discussion has been civil. Of the thousands of posts I’ve seen, I’ve only seen less than a handful of people commenting with things like, “well, I blame the!”
thumbnail
Most people on G+ would prefer it to stay civil and if newcomers (and old-timers alike) abide by the same netiquette that’s formed on G+, then G+ will remain a civil place to socialize online.
  1. Remember the Golden Rule: Treat people the way you want to be treated. Continue to do this even when they don’t.  Always be polite, even to people that disagree with you, even if they’re not polite to you.
  2. Avoid posting anything that’s likely to start a fight.
  3. Don’t vilify a person or group that you know many support or respect.  Put special effort into avoiding obvious hot topics like blaming a political ideology for anything.  Other obvious argument starters are: Religion, Global Warming, Politics.
  4. Contrary to popular opinion, you’re NOT legally bound to provide a counterpoint to every statement made that you disagree with.  Let it go!
  5. Agree to disagree.
  6. Don’t draw people into an argument. This is called “trolling”. If someone politely (or even impolitely) disagrees with you, they’re NOT obligated to give you a detailed explanation, complete with footnotes, links to research, etc… to justify their disagreement. They’re not even obligated to give you ANY explanation at all. A simple “I disagree” can simply be left at that.  See “Golden Rule”.
  7. Learn to walk away.
  8. If someone is tired of arguing with you, it means they’re wrong and you’re right because clearly they can’t defend their position. And if you believe THAT I’ve got a bridge to sell to you. People’s personal time is more important than satisfying your debate lust.  And, if YOU walk away, it doesn’t mean “you know you’re wrong” either, in spite of the fact your opponent will undoubtedly say it does.  No one reading the thread is stupid enough to believe it and most likely, neither does the person saying it.  They’re just trying to pull you back in.
  9. Having “the last word” does NOT make you appear as the “winner” to the other readers. It just makes you look pedantic.
  10. If you’d like to debate someone, please leave OR contact them privately and POLITELY ask for clarity. Your intent should be to better yourself by learning more from another viewpoint, NOT to “put them in their place”. If that’s not your purpose, then leave well enough alone.  See “Golden Rule”.
  11. Instead of being pulled into arguing with someone, block users that continue to violate netiquette. Feel free to announce who and why. But, try not to do that until you’ve asked them to respect your differences. If they continue to be a troll, block them.  Blocking is, by it’s very nature, the lastresort.
  12. Write in clear English (or clear in any human language).  You have unlimited space, so write in complete sentences.  Google+ is NOT your phone’s texting service and it’s NOT Twitter.
  13. Just because YOU’RE familiar with Twitteresque writing, doesn’t mean your G+ followers are.  Google+ is Google+.  It’s not Twitter.  Believe it or not, many people on Google+, including many tech savvy people, have never and never will use Twitter.  Leave your Twitter shorthand and hasheson Twitter.  (Update:  Google+ now supports hash tags.)
  14. Don’t cross post.  Don’t set up automation to automatically copy your posts between Google+, Twitter, and Facebook.  Each service is different with different expectations from the users.  Google+ users expect actual content, not just bit.ly links and unreadable shorthand.
  15. Be forgiving.  People can and will slip up from time to time.  So will you.
  16. Don’t spam (do I really have to say this?)
  17. Don’t hijack someone else’s thread.  Don’t start a separate conversation with a buddy you found commenting on someone else’s thread.
  18. Stay on topic to the original post.
  19. It’s none of your business if someone uncircles you.  Don’t take it personally.  Dealwith it!
  20. And for crying out loud!  If someone has different tastes than you, don’t waste your and everyone else’s time explaining why you think their “taste” is wrong!  Let it be!  (I’m speaking to YOU, you MS vs. Apple, iOS vs. Android, Linux vs. everybody else crowds!!!)
  21. Avoid analyzing, out loud, the other person or people in the thread.  In other words, all your text should be about the subject matter.  NEVER discuss the other person, no matter how much you think they’re a nimrod.  That’s GUARANTEED to start a flame war and YOU will be responsible for it.  Refer to #18 above.  NEVERmake it about someone in the thread.  The best way to avoid this is to never use the word “you”.
  22. Don’t be a jerk (see 1-21 above).

Here’s how a civil disagreement degrades into a pointless pissing match.  DON’T do this!

  1. Person A posts an opinion or some news report about something debatable.
  2. Person B questions the facts.
  3. Person A provides references.
  4. Person B questions the reliability of the source(s) and provides counter facts.
  5. Person A questions the source.
  6. A or B calls the other’s source “biased” or “nutjobs”.
  7. A or B complains about A or B and not the facts.
  8. A or B calls the other a pinhead (usually it’s not quite that nice of a word).

Where did the fail?  At 6.  Don’t do that.

 

Got any more netiquette suggestions to keep the civility?  Let us know in the comments below.

See these images? imageimage
You’ll find an actual working versions of them at the top and bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.

Check back later for updates too!

Click here to follow me on Google+.

Good Luck and Enjoy your Google+ account!

Free Voice calls from your cell phone

 

imageClick here to follow me on Google+.

If you’re tired of outrageous fees for minutes on your cell phone, read on, I can tell you how to get you on your carrier’s cheapest plan and get unlimited minutes.  Read on…

 

Let me clarify:  After this, you’ll STILL have to pay a monthly fee to your cell phone provider.  This article instructs you how to make calls without using up your plans’ minutes!  Everyone clear on that?  Good.  Now, let’s get started!

What you’ll need:

Option 1:

  • A cell phone with the minimum plan that supports a “friends and family” or “faves” plan that let’s you add 1 or more phone numbers as always free calls to or from that (or those) number(s).
  • A free Google Voice account with a free telephone number.

Option 2 (doesn’t require friends and family plan):

 

How?

Instructions if you don’t have an Android or an iPhone (skip ahead to the “Android or iPhone” instructions if you have an Android phone):

Regular cell phone (NOT an Android and NOT an iPhone) (least preferable, but this still works):

  1. Call your cell phone service provider (Verizon, T-Mobile, Sprint, etc…) and ask them if they have a “friends and family” type service (different carriers call it different things.  Verizon calls it “friends and family”, T-Mobile calls it “My Faves”, and others may have different names and not all of them have it).  This service lets you set up one or more telephone numbers as always free calls.  This is so you can add your Mom or whomever you call most and those calls (either incoming or outgoing) will never use up your bank of allowed minutes.
    1. If you cell provider doesn’t offer this, stop now because this won’t work for you, unless you upgrade to an Android phone, then you can skip to the “Android Only Phone” instructions below.
    2. If your provider DOES offer this, you’ll need to add your Google Voice number to the plan (continue reading these steps for instructions on acquiring a free Google Voice number).
  2. Go to http://voice.google.com and either log into it with your existing Google account (if you have a GMail account, you have one) or create a new one.
  3. You’ll be prompted for a new phone number.  Follow the instructions and pick a phone number in the area code you prefer and pick a number you like.  If you have family in a different area code than your cell phone currently is, maybe choose a number in THEIR area code so they can call you free of charge to THEM.
  4. You will be prompted to have calls to that number forwarded to your cell phone.  Go ahead and enter your cell phone number.
    1. When prompted if you want to use Google Voice to replace your carrier’s voice-mail, I recommend to do this, but it’s not necessary for this free calls tutorial.
  5. Now, configure GV (Google Voice) to show YOUR Google Voice # instead of the incoming caller’s caller ID (this makes all incoming calls FREE via your “Friends and Family plan”)
    1. Click on the gears icon menu in the upper right of the web page (not your Browser’s wrench menu, which on Chrome, is just above the GV gears menu) and choose “Voice settings”.
      1. image
    2. Click the “Calls” tab, then select “Display my Google Voice number” by “Caller ID (incoming)”, then check the global spam filter, then click “Save changes”:
      1. image
      2. The other settings can be set to anything you like.
  6. Set you PIN (Personal Identification Number):
    1. Click on the “Voicemail & Text” tab.
    2. By the “Voicemail PIN” label, enter your PIN in both fields.
    3. Click “Save changes”
      1. image
  7. Now, call your cell phone provider (Verizon, T-Mobile, Sprint, etc…) and add your new Google Voice number to your “Friends and Family” plan (or the equivalent plan with your carrier).  Note that you MAY have to upgrade to a more expensive plan to get this if you’re on T-Mobile’s cheapest plan.  This will NOT be worth it if you never go over your minutes.  If you’d LIKE to have more minutes and not worry about it, then upgrading might be a good option.  You’ll have to weigh it yourself.
    1. I recommend you do NOT tell them that this is your Google voice number.  If they ask for a name to be associate with the number, just say “Home” or make something up.  That name is just for your reference later so you know who that number’s for.  Just don’t say “Google Voice”!
  8. Tell everyone you’ve changed your cell phone #.  Give them your new Google Voice #.
  9. When you make outgoing calls:
    1. Call your Google Voice # (this is necessary so that your carrier sees this outgoing call as one going to one of your “Friends and Family” numbers, making it a FREE CALL.
    2. When you hear the v-mail greeting, dial *.
    3. Enter your PIN (the one you created in step 6 above).
      1. Next, if you have new voicemail messages, you’ll have to either listen to them or hit 7 on each to mark as “read” (you can listen to them later via your phone or with your web browser).
    4. Enter 2 to place a call, then follow the instructions.

This, obviously, adds extra steps and time to making outgoing calls, BUT THEY’RE FREE!  For incoming calls, you lose the caller ID information because it’ll always show your Google Voice #, BUT THEY’RE FREE!

 

Android or iPhone

If you have an Android or iPhone, this next set of instructions works better than the instructions above for non smartphones.  There’s an even better option for Android only phones.  For that, skip ahead to the “Android Only” section.

Follow instructions 1-8 above, but forget about step #9 above.  Since you’ve got an Android or iPhone (and I think this works for Blackberries too), do this:

  1. For Android, download GVMyNumber.  For iPhone, download this app.
    1. Why not use the official Google Voice app for Android?  Because it may not call the same number every time, making calls OUTSIDE of your FREE friends and family list!  This is probably a problem on iPhone too.  There may be an iPhone app like GVMyNumber that always calls your OWN Google Voice number.  If anyone knows of one, please leave comments at the bottom for our iPhone users.
  2. For GVMyNumber:
    1. Start the app and tap “Settings”.
    2. Tap “Google Voice Number” and enter your Google Voice Number, then “OK”.
    3. Tap “Google Voice PIN” and enter your PIN that you create in step 6 above, then “OK”.
    4. Now, when you place a call, you’ll be prompted if you want to use GVMyNumber or not.  If you’re calling during prime time and to a number not on your friends and family list AND not to a number that fits your carriers free numbers, let the app take over.  The call will take a little longer to go through because it’s going to call your GV number, enter your PIN, go through the menu and such to make your call, BUT IT’S FREE!

 

Android Only

If you have an Android phone, this may be the preferred method.  Note, however, that you can use THIS method as well as the method above in the “Android and iPhone” section.  I recommend installing GVMyVoice regardless.

What’s different about THIS set of instructions?  All the sections above make and receive calls via your cell providers voice calls.  Your cell provider is aware of the phone calls (maybe not the final destination).  They appear to your cell provider as a call to or from your GV phone number and they DO use your plans minutes UNLESS you have your GV # on your “Friends and Family” plan.  Your cell provider will log the call(s) and probably show them to you on your bill as minutes accumulated on your free calls.

THIS set of instructions doesn’t use your cell providers voice service AT ALL.  As far as your cell provider is concerned, with THIS set of instructions, you never place or receive call.  This is because you’re using your DATA PLAN instead.  These are VOIP (Voice Over IP (Internet Protocol)) calls.  In other words, it’s as if you’re using voice chat from one PC to another over the internet.  You’re not using the phone systems at all.  It’s all internet traffic as far as your cell provider is concerned.

Here’s now:
  1. Go to http://voice.google.com and either log into it with your existing Google account (if you have a GMail account, you have one) or create a new one.
  2. You’ll be prompted for a new phone number. Follow the instructions and pick a phone number in the area code you prefer and pick a number you like. If you have family in a different area code than your cell phone currently is, maybe choose a number in THEIR area code so they can call you free of charge to THEM.
  3. You will be prompted to have calls to that number forwarded to your cell phone.  DON’T DO THIS!
  4. Open the gears menu in the upper-right and choose “Voice Settings”
    1. image
  5. Click on the “Phones” tab, then uncheck everything except “Google chat”.  Make sure “Google chat” is checked.
    1. image
  6. Install the app Groove IP from the Android Market.  This app is not free, but for a one time fee of $4.99, it’s well worth it for unlimited free calls to and from your cell for life!
  7. Open the app, open the menu, and choose “Settings”.
  8. Tap on “User name” and enter your Google Voice account name that you use to log into your Google Voice account, then “OK”.
  9. Tap “Password” and enter your Google Voice account password that you use to log into your Google Voice account, then “OK”.
  10. Check ON “Allow 3G/4G calling”.  Read the notes on that option and decide if you really want this.  Almost certainly you DO!
  11. “Accept calls on answer”:  I recommend leaving this UNCHECKED so you can screen your incoming calls.
  12. Tap “Built in dialer preference”.  I recommend choosing “Ask every call”.  When you place a call using your phones standard dialer, Groove IP will intercept and ask if you want to use Groove IP for the call or let the call go through as a regular cell phone call that your carrier will handle.  If the call you’re making would be a free call through your carrier (nights and weekends or someone on your friends and family list, or with some carriers, calls to any mobile, or calls to other mobile users with the same carrier), you’ll want the call to be handled by your carrier.  It is more reliable and usually slightly better quality.
  13. Tap on “Call Filtering”.
    1. Tap “Exclusion Numbers”.  You’ll set up a list of number that should never use Groove IP for calls… Any phone number that’s always free, you should just call it normally without using Groove IP, especially other cell phones on your account (your spouses, your kids, on your same plan are almost always free calls).  In addition, if you REALLY want your other numbers on your plan excluded from Groove IP because even though it may be free for you to call them with Groove IP, it’s probably NOT free for them to RECEIVE them, because they’ll be receiving a call from your Google Voice #, NOT YOUR CELL PHONE NUMBER!, so your provider will NOT consider it a free call ON THEIR END!
      1. Enter all the phone numbers that are always free from your regular cell phone.  Separate each phone number with a comma.  Make sure you enter the area codes on all of them too.  Tap “OK” when done.
  14. Go back to the Groove IP main menu and scroll down to the bottom and tap “Miscellaneous”.
    1. Check ON “Autostart” so that this app starts when you power on your phone.

That’s it.  Feel free to peruse the other options on Groove IP and fix to your likings.

Now, when you place calls, you can either use your phone’s standard dialer or open the Groove IP app and dial from there.  If you use the Groove IP dialer, you won’t be prompted if you want to use your cell provider for the call.  All calls will go over the internet as VOIP calls, except for those numbers in your exclusion list.

Incoming calls (as long as the person calling you dialed your Google Voice number and NOT your cell phone number) will trigger Groove IP to ring your phone.  You’ll answer the call with the Groove IP app (which will already be up, front, and center when an incoming Google voice call arrives).

Note that if someone calls your REAL cell phone number, your cell phone will ring normally and when you answer, it’s a NORMAL call that consumes minutes per your contract plan.  Incoming calls will NOT be free unless they’re to your Google Voice number.

Be sure to tell everyone (except those whose incoming calls are free anyway, like your spouse and kids on the same plan) that you’ve changed your cell phone number.  Give them your new Google Voice number.

Congrats!  You’re done!  And all of your incoming and outgoing cell phone calls should be ABSOLUTELY FREE! with the obvious exception of people calling your cell phone number instead of your Google Voice number.  You can easily just let those go to voicemail, then call them back with Groove IP and give them your new number so they’ll stop calling your old one that costs you money.

Caution!:

Since these are INTERNET based calls, the quality can be crappy sometimes.  In those cases, you can either wait until you’re in a wireless LAN spot, a 3G or better spot, or if it’s important that you make the call right then, just make a regular call and use up your minutes.  You should have an ample supply of minutes every month with your carrier’s cheapest plan though since the vast majority of your calls will be over the internet.

See this image? image_thumb26
You’ll find an actual working version of it at the bottom of this article. Please click the appropriate buttons in it to let your friends know about this printer scam.

Check back later for updates too

BTW, if you want an invite to Google Plus, e-mail me at image. That’s not a clickable e-mail address… It’s a picture to prevent spammers from easily scraping it. You’ll need to type that address, exactly as you see it, including the G and the + in front of the word “Invite”. I’d also appreciate you clicking the “+1” at the bottom of this post.

Click here to follow me on Google+.

Good Luck!