Toad World® Forums

12.9 beta connect issue - Could not convert variant of type (Null) into type (OleStr)

Early in 12.9 beta I was able to connect fine using 32-bit Toad with 32-bit Oracle 11g drivers.

At some point, after taking a required patch, I started receiving the following error when connecting:

Could not convert variant of type (Null) into type (OleStr)

Then anything I do in Toad (close Database Login screen, exit Toad, etc.) throws same message, call stack:

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=25268; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|--------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |00000000|041F0F23|Toad.exe |00060F23|System.Variants | |VarCastError |613[1] |

|00000040|04 |0048F1A8|041F683B|Toad.exe |0006683B|System.Variants | |_VarToUStr |2915[6] |

|00000040|04 |0048F280|04CB336C|Toad.exe |00B2336C|Xml.XMLDoc | |CloneNodeToDoc |604[18] |

|00000040|04 |0048F374|04CB37D2|Toad.exe |00B237D2|Xml.XMLDoc | |CopyChildNodes |644[4] |

|00000040|04 |0048F3C4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F414|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F464|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F4B4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F504|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F554|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F5A4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F5F4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F644|04CB3961|Toad.exe |00B23961|Xml.XMLDoc | |FormatXMLData |664[12] |

|00000040|03 |0048F690|078C6855|Toad.exe |03736855|tdDBGlobals |TLoginRecs |SaveToXML | |

|00000040|03 |0048F9AC|06FC8C34|Toad.exe |02E38C34|Login |TfrmLogin |FormClose | |

|00000040|03 |0048F9CC|0447B463|Toad.exe |002EB463|Vcl.Forms |TCustomForm |DoClose | |

|00000040|03 |0048FA08|0448094A|Toad.exe |002F094A|Vcl.Forms |TCustomForm |ShowModal | |

|00000040|03 |0048FA64|06FC6E92|Toad.exe |02E36E92|Login | |ConnectDB | |

|00000040|03 |0048FA88|0722CDFA|Toad.exe |0309CDFA|mainform |TfrmMain |TmMainformShown | |

|00000040|04 |0048FAC4|04383AB1|Toad.exe |001F3AB1|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |0048FBF0|0438840F|Toad.exe |001F840F|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|03 |0048FC3C|0447BEC5|Toad.exe |002EBEC5|Vcl.Forms |TCustomForm |WndProc | |

|00000040|04 |0048FC68|04387A64|Toad.exe |001F7A64|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |0048FC98|04223B64|Toad.exe |00093B64|System.Classes | |StdWndProc |13878[8] |

|00000040|03 |0048FCB0|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| |

|00000040|03 |0048FCDC|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | |

|00000040|03 |0048FD54|765F0D32|user32.dll |00020D32|USER32 | | (possible GetClientRect+192) | |

|00000040|03 |0048FD8C|765F0D58|user32.dll |00020D58|USER32 | |CallWindowProcW | |

|00000040|03 |0048FDAC|07223AAD|Toad.exe |03093AAD|mainform | |NewWindowProc | |

|00000040|03 |0048FDC8|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| |

|00000040|03 |0048FDF4|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | |

|00000040|03 |0048FE6C|765E77CE|user32.dll |000177CE|USER32 | | (possible CharPrevW+314) | |

|00000040|03 |0048FED0|765E7895|user32.dll |00017895|USER32 | |DispatchMessageW | |

|00000040|03 |0048FEE0|044850B7|Toad.exe |002F50B7|Vcl.Forms |TApplication |ProcessMessage | |

|--------------------------------------------------------------------------------------------------------------------------------------------|

EurekaLog 7.3.1.0
Application:------------------------------------------------------ 1.1 Start Date : Tue, 3 May 2016 11:58:56 -0500 1.2 Name/Description: Toad.exe - (Toad™ for Oracle®) 1.3 Version Number : 12.9.0.58 1.4 Parameters : 1.6 Up Time : 5 minute(s), 54 second(s)
Exception:------------------------------------------------------------------------------- 2.1 Date : Tue, 3 May 2016 12:04:51 -0500 2.2 Address : 041F0F23 2.3 Module Name: Toad.exe - (Toad™ for Oracle®) 2.5 Type : EVariantTypeCastError 2.6 Message : Could not convert variant of type (Null) into type (OleStr). 2.7 ID : 625F0000 2.8 Count : 1 2.11 Sent : 0
User:-------------------- 3.2 Name : ebrakke 3.3 Email:
Active Controls:---------------------------------------------------------------------- 4.1 Form Class : TfrmLogin 4.2 Form Text : Toad for Oracle Database Login Version 12.9.0.58 4.3 Control Class: TBitBtn 4.4 Control Text : Close
Computer:----------------------------------------------------------------------- 5.2 Total Memory : 17060790272 (15.89 Gb) 5.3 Free Memory : 5066268672 (4.72 Gb) 5.4 Total Disk : 256058060800 (238.47 Gb) 5.5 Free Disk : 57639866368 (53.68 Gb) 5.6 System Up Time : 7 day(s), 8 hour(s), 39 minute(s), 46 second(s) 5.7 Processor : Intel® Core™ i7-3770 CPU @ 3.40GHz 5.12 Virtual Machine:
Operating System:------------------------------------------- 6.1 Type : Microsoft Windows 7 (64 bit) 6.2 Build #: 7601 (6.1.7601.18015)
Steps to reproduce:------------ 8.1 Text:

Call Stack Information:----------------------------------------------------------------------------------------------------------------------------------------------|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |----------------------------------------------------------------------------------------------------------------------------------------------|*Exception Thread: ID=25268; Parent=0; Priority=-2 ||Class=; Name=MAIN ||DeadLock=0; Wait Chain= ||Comment= ||--------------------------------------------------------------------------------------------------------------------------------------------||7FFFFFFE|04 |00000000|041F0F23|Toad.exe |00060F23|System.Variants | |VarCastError |613[1] ||00000040|04 |0048F1A8|041F683B|Toad.exe |0006683B|System.Variants | |_VarToUStr |2915[6] ||00000040|04 |0048F280|04CB336C|Toad.exe |00B2336C|Xml.XMLDoc | |CloneNodeToDoc |604[18] ||00000040|04 |0048F374|04CB37D2|Toad.exe |00B237D2|Xml.XMLDoc | |CopyChildNodes |644[4] ||00000040|04 |0048F3C4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F414|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F464|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F4B4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F504|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F554|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F5A4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F5F4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F644|04CB3961|Toad.exe |00B23961|Xml.XMLDoc | |FormatXMLData |664[12] ||00000040|03 |0048F690|078C6855|Toad.exe |03736855|tdDBGlobals |TLoginRecs |SaveToXML | ||00000040|03 |0048F9AC|06FC8C34|Toad.exe |02E38C34|Login |TfrmLogin |FormClose | ||00000040|03 |0048F9CC|0447B463|Toad.exe |002EB463|Vcl.Forms |TCustomForm |DoClose | ||00000040|03 |0048FA08|0448094A|Toad.exe |002F094A|Vcl.Forms |TCustomForm |ShowModal | ||00000040|03 |0048FA64|06FC6E92|Toad.exe |02E36E92|Login | |ConnectDB | ||00000040|03 |0048FA88|0722CDFA|Toad.exe |0309CDFA|mainform |TfrmMain |TmMainformShown | ||00000040|04 |0048FAC4|04383AB1|Toad.exe |001F3AB1|Vcl.Controls |TControl |WndProc |7204[91] ||00000040|04 |0048FBF0|0438840F|Toad.exe |001F840F|Vcl.Controls |TWinControl |WndProc |9976[152] ||00000040|03 |0048FC3C|0447BEC5|Toad.exe |002EBEC5|Vcl.Forms |TCustomForm |WndProc | ||00000040|04 |0048FC68|04387A64|Toad.exe |001F7A64|Vcl.Controls |TWinControl |MainWndProc |9689[3] ||00000040|04 |0048FC98|04223B64|Toad.exe |00093B64|System.Classes | |StdWndProc |13878[8] ||00000040|03 |0048FCB0|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| ||00000040|03 |0048FCDC|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | ||00000040|03 |0048FD54|765F0D32|user32.dll |00020D32|USER32 | | (possible GetClientRect+192) | ||00000040|03 |0048FD8C|765F0D58|user32.dll |00020D58|USER32 | |CallWindowProcW | ||00000040|03 |0048FDAC|07223AAD|Toad.exe |03093AAD|mainform | |NewWindowProc | ||00000040|03 |0048FDC8|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| ||00000040|03 |0048FDF4|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | ||00000040|03 |0048FE6C|765E77CE|user32.dll |000177CE|USER32 | | (possible CharPrevW+314) | ||00000040|03 |0048FED0|765E7895|user32.dll |00017895|USER32 | |DispatchMessageW | ||00000040|03 |0048FEE0|044850B7|Toad.exe |002F50B7|Vcl.Forms |TApplication |ProcessMessage | ||--------------------------------------------------------------------------------------------------------------------------------------------|| ||Running Thread: ID=26380; Parent=25268; Priority=0 ||Class=TSendThread; Name=[Unnamed thread] Kind: TThread. Thread function: CSLog.TSendThread.Execute + $0. Thread caller: CSLog.TSendThread.Create + $1D (CSLog.TSendThread.Execute)||DeadLock=0; Wait Chain=thread: [ 670C / 26380 ] is blocked ||Comment= ||--------------------------------------------------------------------------------------------------------------------------------------------||7FFFFFFE|03 |00000000|77A3F8E1|ntdll.dll |0001F8E1|ntdll | |NtWaitForSingleObject | ||00000040|03 |0E29FEA4|753E118F|kernel32.dll|0001118F|kernel32 | &n

Could you please send your Connections.xml file to me? It’ll be in your User Files directory.

From: erik-brakke [mailto:bounce-erik-brakke@toadworld.com]
Sent: Tuesday, May 03, 2016 1:14 PM
To: toadoraclebeta@toadworld.com
Subject: [Toad for Oracle - Beta Discussion Forum] 12.9 beta connect issue - Could not convert variant of type (Null) into type (OleStr)

12.9 beta connect issue - Could not convert variant of type (Null) into type (OleStr)

Thread created by erik-brakke

Early in 12.9 beta I was able to connect fine using 32-bit Toad with 32-bit Oracle 11g drivers.

At some point, after taking a required patch, I started receiving the following error when connecting:

Could not convert variant of type (Null) into type (OleStr)

Then anything I do in Toad (close Database Login screen, exit Toad, etc.) throws same message, call stack:

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=25268; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|--------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |00000000|041F0F23|Toad.exe |00060F23|System.Variants | |VarCastError |613[1] |

|00000040|04 |0048F1A8|041F683B|Toad.exe |0006683B|System.Variants | |_VarToUStr |2915[6] |

|00000040|04 |0048F280|04CB336C|Toad.exe |00B2336C|Xml.XMLDoc | |CloneNodeToDoc |604[18] |

|00000040|04 |0048F374|04CB37D2|Toad.exe |00B237D2|Xml.XMLDoc | |CopyChildNodes |644[4] |

|00000040|04 |0048F3C4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F414|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F464|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F4B4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F504|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F554|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F5A4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F5F4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] |

|00000040|04 |0048F644|04CB3961|Toad.exe |00B23961|Xml.XMLDoc | |FormatXMLData |664[12] |

|00000040|03 |0048F690|078C6855|Toad.exe |03736855|tdDBGlobals |TLoginRecs |SaveToXML | |

|00000040|03 |0048F9AC|06FC8C34|Toad.exe |02E38C34|Login |TfrmLogin |FormClose | |

|00000040|03 |0048F9CC|0447B463|Toad.exe |002EB463|Vcl.Forms |TCustomForm |DoClose | |

|00000040|03 |0048FA08|0448094A|Toad.exe |002F094A|Vcl.Forms |TCustomForm |ShowModal | |

|00000040|03 |0048FA64|06FC6E92|Toad.exe |02E36E92|Login | |ConnectDB | |

|00000040|03 |0048FA88|0722CDFA|Toad.exe |0309CDFA|mainform |TfrmMain |TmMainformShown | |

|00000040|04 |0048FAC4|04383AB1|Toad.exe |001F3AB1|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |0048FBF0|0438840F|Toad.exe |001F840F|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|03 |0048FC3C|0447BEC5|Toad.exe |002EBEC5|Vcl.Forms |TCustomForm |WndProc | |

|00000040|04 |0048FC68|04387A64|Toad.exe |001F7A64|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |0048FC98|04223B64|Toad.exe |00093B64|System.Classes | |StdWndProc |13878[8] |

|00000040|03 |0048FCB0|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| |

|00000040|03 |0048FCDC|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | |

|00000040|03 |0048FD54|765F0D32|user32.dll |00020D32|USER32 | | (possible GetClientRect+192) | |

|00000040|03 |0048FD8C|765F0D58|user32.dll |00020D58|USER32 | |CallWindowProcW | |

|00000040|03 |0048FDAC|07223AAD|Toad.exe |03093AAD|mainform | |NewWindowProc | |

|00000040|03 |0048FDC8|765E62F7|user32.dll |000162F7|USER32 | | (possible gapfnScSendMessage+815)| |

|00000040|03 |0048FDF4|765E6D35|user32.dll |00016D35|USER32 | | (possible GetThreadDesktop+210) | |

|00000040|03 |0048FE6C|765E77CE|user32.dll |000177CE|USER32 | | (possible CharPrevW+314) | |

|00000040|03 |0048FED0|765E7895|user32.dll |00017895|USER32 | |DispatchMessageW | |

|00000040|03 |0048FEE0|044850B7|Toad.exe |002F50B7|Vcl.Forms |TApplication |ProcessMessage | |

|--------------------------------------------------------------------------------------------------------------------------------------------|

EurekaLog 7.3.1.0
Application:------------------------------------------------------ 1.1 Start Date : Tue, 3 May 2016 11:58:56 -0500 1.2 Name/Description: Toad.exe - (Toad™ for Oracle®) 1.3 Version Number : 12.9.0.58 1.4 Parameters : 1.6 Up Time : 5 minute(s), 54 second(s)
Exception:------------------------------------------------------------------------------- 2.1 Date : Tue, 3 May 2016 12:04:51 -0500 2.2 Address : 041F0F23 2.3 Module Name: Toad.exe - (Toad™ for Oracle®) 2.5 Type : EVariantTypeCastError 2.6 Message : Could not convert variant of type (Null) into type (OleStr). 2.7 ID : 625F0000 2.8 Count : 1 2.11 Sent : 0
User:-------------------- 3.2 Name : ebrakke 3.3 Email:
Active Controls:---------------------------------------------------------------------- 4.1 Form Class : TfrmLogin 4.2 Form Text : Toad for Oracle Database Login Version 12.9.0.58 4.3 Control Class: TBitBtn 4.4 Control Text : Close
Computer:----------------------------------------------------------------------- 5.2 Total Memory : 17060790272 (15.89 Gb) 5.3 Free Memory : 5066268672 (4.72 Gb) 5.4 Total Disk : 256058060800 (238.47 Gb) 5.5 Free Disk : 57639866368 (53.68 Gb) 5.6 System Up Time : 7 day(s), 8 hour(s), 39 minute(s), 46 second(s) 5.7 Processor : Intel® Core™ i7-3770 CPU @ 3.40GHz 5.12 Virtual Machine:
Operating System:------------------------------------------- 6.1 Type : Microsoft Windows 7 (64 bit) 6.2 Build #: 7601 (6.1.7601.18015)
Steps to reproduce:------------ 8.1 Text:

Call Stack Information:----------------------------------------------------------------------------------------------------------------------------------------------|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |----------------------------------------------------------------------------------------------------------------------------------------------|*Exception Thread: ID=25268; Parent=0; Priority=-2 ||Class=; Name=MAIN ||DeadLock=0; Wait Chain= ||Comment= ||--------------------------------------------------------------------------------------------------------------------------------------------||7FFFFFFE|04 |00000000|041F0F23|Toad.exe |00060F23|System.Variants | |VarCastError |613[1] ||00000040|04 |0048F1A8|041F683B|Toad.exe |0006683B|System.Variants | |_VarToUStr |2915[6] ||00000040|04 |0048F280|04CB336C|Toad.exe |00B2336C|Xml.XMLDoc | |CloneNodeToDoc |604[18] ||00000040|04 |0048F374|04CB37D2|Toad.exe |00B237D2|Xml.XMLDoc | |CopyChildNodes |644[4] ||00000040|04 |0048F3C4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F414|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F464|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F4B4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F504|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F554|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F5A4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F5F4|04CB3803|Toad.exe |00B23803|Xml.XMLDoc | |CopyChildNodes |648[8] ||00000040|04 |0048F644|04CB3961|Toad.exe |00B23961|Xml.XMLDoc | |FormatXMLData |664[12] ||00000040|03 |0048F690|078C6855|Toad.exe |03736855|tdDBGlobals |TLoginRecs |SaveToXML | ||00000040|03 |0048F9AC|06FC8C34|Toad.exe |02E38C34|Login |TfrmLogin |FormClose | ||00000040|03 |0048F9CC|0447B463|Toad.exe |002EB463|Vcl.Forms |TCustomForm |DoClose | ||00000040|03 |0048FA08|0448094A|Toad.exe |002F094A|Vcl.Forms |TCustomForm |ShowModal | ||00000040|03 |0048FA64|06FC6E92|Toad.exe |02E36E92|Login | |ConnectDB | ||00000040|03 |0048FA88|0722CDFA|Toad.exe |0309CDFA|mainform |TfrmMain |TmMainformShown | ||00000040|04 |0048FAC4|04383AB1|Toad.exe |001F3AB1|Vcl.Controls |TControl |WndProc |7204[91] ||00000040|04 |0048FBF0|0438840F|Toad.exe |001F840F|Vcl.Controls |TWinControl |WndProc |9

Hmm I pasted the whole Eureka log and CTRL-Z’ed it out. Instead I pasted just the exception call stack but the whole log posted anyway. If a moderator would like to delete the Eureka log that’d be appreciated.

Could you please send your Connections.xml file to me so I can take a look? It’ll be in your User Files directory.

When I went through my CONNECTIONS.INI file and set CustomFIeldsOBJ0=0 for any LOGIN entries that did not have a value in CustomFields0, it started working again.

This has been fixed for the next beta.