I exported a SQL server table to an Excel spreasheet.
Doing the following:
Create heterogenious join between a SQL Server table and an Excel spreadsheet
Save query as .tsm file
Close Toad
Open Toad
Open .tsm file
An error occurs.
System.Exception
Error occurs
Stack Trace:
at DevExpress.XtraGrid.GridControl.EndUpdate(Boolean synchronized)
at DevExpress.XtraGrid.GridControl.EndUpdate()
at Quest.Toad.QueryBuilder.QueryBuilderControl.SetXml(String xml)
at Quest.Toad.QueryBuilder.QueryBuilderControl.set_Xml(String value)
at Quest.Toad.QueryBuilder.QueryBuilder.LoadModel(String file, String xml)
at Quest.Toad.QueryBuilder.QueryBuilder.OpenFile(String file)
at Quest.Toad.QueryBuilder.QueryBuilder.timerDelayFileLoad_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
System.InvalidCastException
Unable to cast object of type 'Quest.Toad.SqlServer.SqlServerConnection' to type 'Quest.Toad.Odbc.OdbcToadConnection'.
Stack Trace:
at Quest.Toad.Odbc.OdbcScheme.GetObjectName(ITrl trl, ITrlScheme quotingSchema)
at Quest.Toad.QueryBuilder.SqlEngine.BuildTableName(TableObject tableObject, ITrlScheme quotingScheme)
at Quest.Toad.Odbc.SqlEngineOdbc.BuildTableName(TableObject tableObject, ITrlScheme quotingScheme)
at Quest.Toad.QueryBuilder.SqlBuilder.GetTableNamePostfixAlias(TableObject tableObject, IConnection modelConnection)
at Quest.Toad.QueryBuilder.SqlBuilder.BuildJoinString(ArrayList relations, Boolean heterogeneousQuery, SqlEngine sqlEngine, QueryBuilderControl model)
at Quest.Toad.QueryB
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center