NEOBYTES - Just another Tech blog...

Is your firewall blocking Google Drive? Many of us have faced issues of corporate firewall blocking drive.google.com, dropbox etc. My company suddenly decided that accessing google drive was prohibited.  However, I have found that you can access your files by installing google drive to your PC. First, you must find the installation files. Try searching for google tools and find a download link for google drive. Although this seems like a straightforward step, you will find that if your company blocks google drive, they sometimes have blocked the download sites as well. If the link is blocked, you may need to download the files outside of your firewall and then install them on your PC. You must have admin access to install programs on your PC to use this workaround.  or, Try this download link: https://tools.google.com/dlpage/drive/index.html?hl=en Open googledrivesync.exe to automatically install and start Google Drive on your PC. (You may receive a war...

Remember to use TRIM function when comparing data in two recordsets in LotusScript. After an ADO Database Connection has been created, create the Recordset.   Proceed to extract, transform and/or load your data.    This is an example of appending data to a recordset. In this case from SQL to DB2. ====================================================================   Do While Not SQLRS.EOF And Not Db2RS.EOF And Not Done         dubugthis = "Inside update"         record = Trim (Db2RS("YourID").Value) & " - " & Trim (projRS("YourOtherID").Value)         Print record           If Trim(Db2RS("YourID").Value) = Trim(projRS("YourOtherID").Value) Then             Db2RS.MoveNext             projRS.MoveNext     ...

ISolvable: Uninstalling ClickOnce This is an easy to read guide on how to uninstall a ClickOnce application that doesn't appear in Add/Remove Programs. This can occurr if there is an error with the installation. I notice it more on XP machines. I was able to recreate and use this script in about 1 minute.

"How does one purport to measure a construct for which there is no consensus explanation?" Cambridge Handbook of Intelligence, 2011

"IsNot", which is obviously the opposite of "Is". It is especially useful when testing for when something is not "Nothing". (I love the double-negative.) It took me a while to figure that that you can say: If var1 IsNot Nothing Then...End If Instead of the awkward: If Not var1 is Nothing Then ...End If

I've run into some strange issues with downloading the Adobe photoshop CS5 trial. This is the error message I've been receiving: Error communicating with Adobe.com (Error 100). I tried all of the steps mentioned here with no luck: http://kb2.adobe.com/cps/898/cpsid_89867.html The Solution that actually worked for me was a combination of the above with one important step (This is on a Windows 7 64 bit PC): Remove preferences folder from C:\Users\%username%\AppData\Adobe.comblahblaahblah Just delete this folder. Now uninstall Adobe Download Assistant from the contral panel. Login to Adobe.com and download the Download Assistant again. Install Close Go to Start ==> Programs ==> Right click on Adobe Download Assistant and RUN AS ADMINISTRATOR. After, I started the application as an administrator I was able to search through the Download Assistant for the CS5 trial and start my download. This all took me about 2 hours of trial and error to figure out. Hope I saved you guys som...

I just created this post to commend the awesomeness of VMware (VMs) as a virtualization solution. I now have 3 VMs setup to isolate test environments for various applications. Back in the mainframe days, this was accomplished through a series of complicated Test & Pilot systems. However, with VMs, setup is quick and there are standard wizards to assist with more complicated tasks. I was able to increase my hard drive from 10GB to 40GB without any painful MSDOS commands using the wizard. Which brings me to the objective of this post; I have installed the latest and greatest Visual Studio 2010 and will be posting some tips and tricks for integration with the AS400 using managed providers. Coming soon…. Quick Tip: MSDOS Sometimes we can forget how useful DOS commands can be for managing files and batch jobs. Here’s a quick tip on appending file names: *Run the following commands in DOS. Make sure to turn the Y?N response indicator to NO! SELECT FILE_NAME , 'copy...