Take ANY SharePoint 2010 or 2013 Library. Does clicking on “Open in Explorer” hang your computer with an error after 1-2minutes?

Lets say you have a SharePoint Library and want to open in in Explorer to a whack of files by copying them in rather than through the web interface. BUT you cannot as there is an error. In SharePoint’s Library ribbon, you can if you…

Click Library -> Open with Explorer

And it hangs your computer for about 1-2 minutes – arriving with an error box

“Your client does not support opening this list with Windows Explorer”

Root Cause: The webclient services is not running and (in my case) COULD NOT start. Do this …
Continue reading

Share Button

Dropbox .. your fired!

Dropbox cannot be run as service and always up has failed us making it so.

So … what next?

Share Button

Configuring and getting an RDS SQL Server dB from local to AWS – what a pain

The documentation is sooo not complete at AWS to get a dB restored from local to the AWS server. The error I had when i ran the stored proc (below) was “Database backup/restore option is not enabled yet or is in the process of being enabled. Please try again later.These guys got me started, but I was still a long way off, this guy finished the missing link. The instructions below hopefully will help. I wished I would have recorded this but .. this article is my best memory of how I solved it.

Connecting was mental too – I added a firewall rule – but adding to the default one was the trick that made it work. Now, after doing all this, I see why – you have to make “groups” of this or that and then apply those groups. That is the key to making things work on RDS. Continue reading

Share Button

Access Sharepoint folder as a unc for automated file add

UNC Path Naming for files stored on SharePoint

https://blogs.msdn.microsoft.com/johnguin/2012/06/24/enabling-the-webclient-service-in-windows/

http://www.smartdigitizers.com//other-development-tips/accessing-sharepoint-folders-using-unc/

Share Button

Choose SQL Cloud Service

UPDATE POST RDS trial: OH NO: RDS has no sysadmin rights and the app I need has Stored Procs that need that. So I installed an EC2 instance which is a fancy way of saying “got a computer up and running, logging into it using RDP and installing my own SQL express”. Gee I could have done that in the first place 🙂 Alas. BUT … a super cool article with how-to’s for both RDS and EC2 setup. A CLI is also avail. Firewall calc.

After doing some digging, AWS is likely a good value for a SQL server. It is called AWS RDS. It can be sized and all sorts of databases (MySQL, PostgreSQL, MS SQL Server etc) can be chosen and the power of the machine and file size can be chosen. $20-$100 for 20GB of space. But that is not all you have to think of when sizing up the machine. Here is an RDS matrix.

Share Button

Cloud Sync and Storage … where to begin

Google of course. Here are the links that turned up. I am looking for 500GB – 1TB for a customer.

Pricing

Share Button

How to register your tlb file for VBA use on a destination machine AND have VSTO running. SUCCESS.

It took HOURs to figure all this out and the answer!? (see older post) The issue that we are having is that  the VSTO would work initated from the ribbon, but the VBA when you added a “reference” to the .tlb file would tell you that it could not create an ActiveX object or other message saying “what!?”. Solution:  to run from the command line:  

regasm /codebase <pathToMyDll> /tlb:<pathToMyTlb>

But that command too could not “just run”. Here is a guy doing the exact same thing as me, except I found this article last – or at least I stopped looking. It is the key. Making VSTO things and wanting to use them in the “old world” and the new. This confirms all I have learned. Lots of links at the bottom about CLSID’s, regasm etc. COM====ActiveX in case you run into ActiveX – it is 100% the same. I used RegShot to see the registry items to learn what to google next

Continue reading

Share Button

Get COM enabled VBA compatible VSTO project to work using an installer

First, here is what we are looking for our of our VSTO

  • VSTO just works
  • VBA code can use the new libraries AND have intellisense (eg pre-binding)
  • to be used by all users of the computer (click once installer is thus ‘out’ thus – custom installer)

UPDATE: This article has the answer: The stuff below is also good information to use and do. Continue reading

Share Button

Characters not allowed as SharePoint Names

http://sharepoint.stackexchange.com/questions/105992/which-special-characters-are-not-allowed-in-sharepoint-2013-files-folders

I uploaded something I got from a collegue – it seems to be plagurizing the doc above BUT HAS even MORE info.  I would love to give credit, but I don’t know where it comes from: Ilegal Characters _SharePoint.pdf

Share Button

3 computer crashes/rebuilds in 3 years – same machine – I finally snapped and did the VM thing

OK – so 1.5 days down without pay. That stinks and is not going to happen to me again. I have always wanted to make a VM and run Windows inside my VM. 2 machines later and 3 crashes – I finally snapped and did it. I don’t have a blog with many links, but here is what I did… and it works. Again , I wrecked many a VM on purpose – fiddling and knew how quick a restore could be – so why am I not working like this on purpose for my own disaster recovery? A whole weekend went down the drain – but never again … here’s how… Continue reading

Share Button