Category: Development

Cannot find wrapper assembly for type library “ADODB”

Happy new year and Happy coding!
Using Visual Studio 2022 on Windows 11 with the latest updates to 24H2, started giving the following errors when trying to compile an older project:

The "ResolveComReference" task returned false but did not log an error.
Cannot find wrapper assembly for type library "ADODB". Verify that (1) the COM component is registered correctly and (2) your target platform is the same as the bitness of the COM component. For example, if the COM component is 32-bit, your target platform must not be 64-bit.

So, you Google a bit and find this, but don’t do that!
In my case, the following article helped, or just a comment from it “Mine was resolved by removing the reference to “Microsoft HTML Object Library” and adding it again in the project.“.

  • In solution Explorer, open ‘My Project’
  • Go to the tab ‘References’
  • Find your mentioned library on the top, in my case, ‘Microsoft ActiveX Data Objects 2.8 Library’ with some ‘ADODB.dll’ in a system32 folder.
  • Click the ‘Add’ button, tab COM > Type Libraries, and find your library, it should be checked.
  • UNCHECK it, and OK the popup
  • Repeat: Click the ‘Add’ button, tab COM > Type Libraries, and find your library, now unchecked.
  • CHECK it, and OK the popup
  • Save everything and try to compile again.

That should work.
If not, so sorry, but it did for me…

Have a nice day!


OceanWP v4.0 loses Google Fonts

Check this! All my OceanWP websites lost their default font and fell back to something Roman, so everything looked ugly! Basically all websites using OceanWP did no longer load their Google fonts after the update to version 4.0.

Solution: I had to manually enable the fonts again! How?
Go to WP Dashboard > Appearance > Customizer > Typography > Google Font Settings and enable Google Fonts – hit “publish” and done!

Looks like someone at OceanWP forgot to check backwards compatibility…

Have a nice day!

OceanWP and SVG images

Ever tried to enable the upload of SVG images in WordPress, and kept getting the error:
“Sorry, you are not allowed to upload this file type.” ?

So, you tried the plugins Safe-SVG, disabled Wordfence, disabled Solid Security, added a snippet with WPCode, changed your wp-config.php file, and maybe some other options you found on the Interweb?
Well, if you are using the OceanWP theme like I do, then nothing will work, except when you go to your OceanWP panel, select the ‘Integration’ tab on the left, slap your forehead with a flat stretched-out hand, and finally slide the switch on that page, all just to enable the SVG files support.

Next, of course, remove all those plugins, code snippets and other things you have added to your WordPress installation and continue with your life.

Have a nice day!

PHP8 and function list() = each()

Time to write something about PHP again. With PHP 7.2, the function each() is deprecated. The documentation says: “Warning This function has been DEPRECATED as of PHP 7.2.0. Relying on this function is highly discouraged.“.
If you ignored this warning before, in PHP8 you will now get the following error: Fatal error: Uncaught Error: Call to undefined function each() in /path/file.php:line
So, what do you do when you find this in your old code or in some library that you use, but is not being updated anymore? Stackoverflow to the rescue…

Continue reading PHP8 and function list() = each()

How to encode and decode Base64 in VB.NET

Because sometimes you just need a string with ‘normal characters’ instead of funky ones…

Public Function EncodeBase64(input As String) As String
	Return System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(input))
End Function

Public Function DecodeBase64(input As String) As String
	Return System.Text.Encoding.UTF8.GetString(Convert.FromBase64String(input))
End Function

Have a nice day!