Error 1918 while Installing MySQL ODBC Driver on Windows

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…

MySQL ODBC Error 1918

Continue reading “Error 1918 while Installing MySQL ODBC Driver on Windows”

Error When Setting Up Database Mirroring

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.

The Problem

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)

Well of course it is.. That is what I am suppose to do.. Everything I found online said make sure you restore it with NORECOVERY. I was in a never ending loop. I tried everything I could think of.  Continue reading “Error When Setting Up Database Mirroring”

Creating Cron Jobs in Windows 10 and Windows Server 2016

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”

How to start your own blog

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”

Creating Rooms in Office 365 Exchange Online and Add To Rooms List

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.

I filled out Display Name, Telephone Number and Password Never Expires. Continue reading “Creating Rooms in Office 365 Exchange Online and Add To Rooms List”

How to turn Modern View back on in SharePoint Online

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).

Continue reading “How to turn Modern View back on in SharePoint Online”

Nothing happens when Compacting VHD in Hyper-V

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!

Continue reading “Nothing happens when Compacting VHD in Hyper-V”

Adding emails into SharePoint Online Discussion Boards

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”