Toad for oracle 14.2.104.1069: error: Could not convert variant of type (OleStr) into type (Integer)

Toad for Oracle & DevOps Toolkit
1

This morning I upgraded to toad for oracle 14.2.104.1069

100% of the time when starting a new connection
[as in "session" / "new connection" / select_a_predefined_line_item(s) / "connect"

then each item(s) connected to pop a this error:
Could not convert variant of type (OleStr) into type (Integer)

the resultant SQL window seems "ok"/functional
I did notice the window's tab contains unexpected text like its a mal-formed query
image

2

Toad 14.2 has a bug with Oracle client version 12.1.0.1. That is what's causing this.
Please use any of the following clients instead:
12.1.0.2
12.2.0.1
18c (any)

I do not recommend any 19c client in any version of Toad, as they have a memory leak with LOBs.

3

WOW! thank you.