When I tried to connect via ODBC (i.e. Firebird/Interbase, Vertica), I get the following error. This even occurs when returning limited rows and memory is not expected to be an issue.
System.OutOfMemoryException
Insufficient memory to continue the execution of the program.
Stack Trace:
at System.Runtime.InteropServices.Marshal.AllocHGlobal(IntPtr cb)
at Quest.Toad.NativeOdbc.UnManagedColumnDescriptor..ctor(Int16 columnIndex, String columnName, SQL_DATA_TYPES sqlDataType, Int32 columnSize, Int16 decimalDigits, Int16 nullable)
at Quest.Toad.NativeOdbc.OdbcDriverManager.ObtainResultSet(OdbcHandle statementHandle, String tableName)
at Quest.Toad.NativeOdbc.NativeOdbcConnection.GetTables(String SchemaName, TableTypes type)
at Quest.Toad.Odbc.Scheme.TableList.TableListTrl.get_BackgroundData()
at Quest.Toad.Trl.BackgroundCachedTrl.get_GenerateData()
at Quest.Toad.Trl.CachedTrl.get_Data()
at Quest.Toad.Odbc.Scheme.TableList.TableListTrl.GetTrls()
at Quest.Toad.Odbc.Scheme.TableList.TableListTrl.GetFilteredTrls(FilterInfo info)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.updateContentTimer_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)
This may be a conflict with ODBC and memory allocation using some ODBC drivers.
TDP in general should support ODBC database connections that use ODBC 3.0 driver specifications.
If working with a large number of columns, try reducing the number of columns returned to see if results are brought back.
In some cases, the issue is with the driver. Verify that the driver is up to date, and upgrade if necessary.
