Had to install MySQL ODBC Driver on Windows when I was trying to use SSMA to convert a MySQL DB to Microsoft SQL. When I tried to install the driver, I got the below error and was completely puzzled. I finally found the fix..
Error 1918. Error installing ODBC driver MySQL ODBC
5.3 ANSI Driver, ODBC error 13: The setup routines for
the MySQL ODBC 5.3 ANSI Driver ODBC driver could
not be loaded due to system error code 126: The
specified module could not be found. …\myodbc5S.dll…
I spent a full day attempting to setup Database Mirroring on two SQL Server 2017 Development Editions with SSMS 17.4 to test a setup. Took a full day when it should have only took a few minutes and I could not find any help online, so I thought I would share my fix.
I was getting this error at first:
Database “AdventureWorks” is not configured for database mirroring. (Microsoft SQL Server, Error: 1416)
After doing some research, I discovered that I needed to restore a full backup with the NORECOVERY option. Did that. Here is what I got then:
Database ‘AdventureWorks’ cannot be opened. It is in the middle of a restore. (.Net SqlClient Data Provider)
I recently made the switch from a Linux LAMP server to a Windows Server 2016. It didn’t take me too long to figure out I forgot to transfer my cron jobs for my PHP pages. I went to start the transfer and I soon realized that Windows does not support cron jobs. However, I did find the Windows version of Cron jobs. Below is what I did to create these cron jobs so my PHP crons will continue run on schedule. This trick will really work in all versions of Windows, but you must get to it different methods. Continue reading “Creating Cron Jobs in Windows 10 and Windows Server 2016”
When you are looking to start a blog of your own, it can seem like a daunting task. In reality, if you take it one step at a time and with the right instructions, you can easily create your own blog in just a couple minutes. The hardest part is choosing your website name and creating content. But if you are serious about it, in just a few minutes you can be on your way to creating your first blog post.
Step 1 – Choose a provider
The first thing you want to do is pick out a hosting provider. A hosting provider is who will actually store the files for the website and who will make it available for people on the internet.
I, myself, am a hosting provider, therefore I host my own sites. If you are interested in using me as your hosting provider, you can signup at https://axelwebhosting.com and use the coupon code “1STMONTHHALF” and you get your first month 50% off. This tutorial will show you how to setup a WordPress blog on my hosting platform using the WordPress easy installer. Continue reading “How to start your own blog”
The title above is quite long, but exactly to the point – I found myself unsure how to add a resource room in Office 365 for Exchange online because it was set up by previous employees and hadn’t been done since then. Then I needed to add it to the Rooms List. I will walk you through my process of how I created a room and added it to a room list. This was also done in a hybrid environment (Exchange Online and Exchange 2013).
Create User Account
The first step is to create a regular AD user account. I created it in Active Directory User and Computers. You will not need to know the password, so set it to something crazy long and forget it. Be sure to set the password to never expires. And after all of this is said and done, we will disable the account for security.
When we first switched to SharePoint Online, I loved the new view! The only problem was as an administrator, I needed to switch back to the classic view to manage some parts of a list that wasn’t available in the new look. I could not find a button that allowed me to just switch back. After looking up some blog posts, I found that people said to simply log off and log back on. However, this did not work for me. Here are some other ways I found to do it, and some more “advanced” ways to do this, as well as a way to script it (or add a button for end users).
For the past couple days now, I have been trying to compact a couple virtual machine hard drives VHDX via Hyper-V Manager. One of them worked without a hitch, however the other one I would go to Hyper-V manager, click edit disk and follow the normal procedures, but when I clicked finish, the box would just go away without it ever actually changing the size. I found a fix around this using a one line PowerShell command!
A few days ago, I used Vmware P2V tool to convert my physical server to a virtual server. After doing that, I wiped the machine. I then decided to use Hyper-V instead. I had to find a way to convert the hard drive to a Hyper-V .VHDX disk instead of a VMWare disk without having an actual running VMWare server.
Many times when I go to build someone a new computer, I run into old outdated software that is no longer supported, cannot find the installer, or just simply don’t exist anymore. I recently ran into this with Quest PowerGUI 220.127.116.11. Luckily, I was finally able to find the download link and get my end user a new computer. Continue reading “Where to find Quest PowerGUI 3.8”
My company has been using SharePoint Server for a few years now. Everyone was comfortable with it and following a set of processes. We decided to migrate to the cloud to get the server maintenance off our back and to take advantage of the many features available in SPO.
One of our departments has been using Discussion Boards and forwarding emails into SharePoint 2013 to archive emails, be able to “process” and count them and to easily access them if ever needed. After the migration, we found out you can no longer email things into lists – and boy was my world turned upside down when this was noticed. Continue reading “Adding emails into SharePoint Online Discussion Boards”