For some reason there still isn’t any easy way to update the driver used on a previously defined ODBC data source in Windows. There’s no option when stepping through the configuration. I suppose you’re expected to delete and recreate the data sources, specifying the new driver at that time. But what if you have dozens, or hundreds, of existing sources?
My OpenVPN likes to have difficulty and go yellow from time to time. The problem with this is twofold – I have any and all downloads stop at the absence of VPN, and when I’m not home connecting to my server is more difficult when VPN has hundged up. The simplest fix for now is just to restart/reconnect VPN on the daily.
I recently needed to set up a Win10 Hyper V, and then join it to a domain over a VPN connection. The first issue that I faced was that Cisco Anyconnect VPN client detected the virtual machine as a Remote Desktop Connection and refused to allow it to connect. I solved this by switching from Enhanced Session to Basic Session by clicking this on the toolbar of the virtual machine:
My second issue was that, even after successfully joining the machine to the domain, there was no Switch User option (I needed to switch to a domain user while on the VPN in order for it to authenticate to the domain server and build the local profile for the domain user). No matter where I looked there was no option. Not in the power options, not via Alt+F4, nowhere.
I solved this by invoking tsdiscon.exe directly via a run line. Bear in mind that it’s my understanding tsdiscon.exe is not available in Win 10 Home edition, though I don’t know why anyone would build a virt of Home edition.
I wanted OpenVPN to autologin on one of my servers. The issue here is two fold: UAC grabs the executable and demands confirmation, and the gui doesn’t retain credentials. The solution to the latter does unfortunately require storing those credentials plaintext in a file, but if you’re not worried about that then read on. Continue reading →
Got an app you want to work only when connected to VPN? Have Windows Firewall do the work for you
First, connect to your VPN. Then, ensure that your Public connection is that VPN connection. You can do this by opening Network and Sharing Center. In the example below, clicking on Ethernet 3 on the Unidentified network reveals the VPN IP address.
Save this file. You can double click it to test it. After having confirmed it works, create a task pointed to it in Windows Task Scheduler. Modern Windows OSes should natively run a vb script in scheduler. If not, use CScript to launch the script:
I use the mighty Pi-Hole to streamline my browsing experience. Sometimes, though, the ole Hole can get in my way, blocking something I need to see. If it’s a one time deal, and not something I want to whitelist (which Pi-Hole has thankfully made easy to do via the web interface as of the latest edition), I wanted an easy way to temporarily switch DNS servers.
Enter QuickSetDNS, a groovy little exe that can do just that. Download QuickSetDNS and unpack it into the destination of your choosing. There’s no installer – it’s a simple standalone exe. Fire it up, right click in the whitespace and create a new DNS server entry. I’ve got one for my Hole, and one that points to Google’s public DNS servers.
After creating your entries, right click on one and choose Copy SetDNS Command Line. Then right click on your desktop and create a new shortcut. Paste the SetDNS command line in for the location of the shortcut and click Next. Name it something informative, and save it. Do the same with your other DNS entries in QuickSetDNS.
There. Now you have shortcuts you can double click to change your local DNS settings.