-
Title
Error connecting to database and viewing table data: "Unable to cast object of type 'System.DBNul -
Description
The following error occurs when user connects to database and views table data:
**********************************************************************
Exception Information
**********************************************************************
Exception: System.InvalidCastException
Message : Unable to cast object of type System.DBNull to type System.String.
Stack Trace:
at Quest.Toad.SqlServer.Trl.Tables.TableColumnTrl.QueryDone_EventHandler(Object sender, EventArgs e)...
Toad version 4.1 does not return any errors connecting to the same database. -
Cause
Insufficient user rights on the particular database. User account is a restricted (read-only) user.
-
Resolution
WORKAROUND:
None
STATUS:
Issue addressed in Toad version 4.6. Download the current version of Toad via:https://support.quest.com/SUPPORT/index?page=downloads -
Defect ID
ST66935 -
Additional Information
Toad does not support restricted user accounts.