Toad World® Forums

Only one item is displayed


So using the trial version of Data Analysis and I used the Query with Priya SQL server type and I used am trying to get a report with all the items in Priya (Warehouse system), but every time I Run the Query only one of the items (Row) shows up.

I am wondering if there is something I select for it to show more rows after or before running the Query.

Still new to the system keep in mind when answering please and thank you.


I am not familiar with Priya. Are you using ODBC to connect with or our Native SQL Server provider? The native SQL Server connection type would be best if this is compatible. If you must use ODBC please send a link to the driver media and I will have our ODBC developer take a look.



Yes it uses ODBC link to connect. I am not sure if it is just me not putting a correct table or array in maybe, but an error does show up as in a format error, but everything I want for data is there (Columns) just only one item (Row).

This is the Error:

Input string was not in a correct format.
Stack Trace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
at Quest.Toad.NativeOdbc.UnManagedColumnDescriptor.GetBufferDataAsDecimal(UInt16 rowOffset)
at Quest.Toad.NativeOdbc.OdbcDataReader.GetValue(Int32 i)
at Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()



It looks like there is an existing bug when regional settings have a comma used as a decimal separater. To work around the error you will need to temporarily change your regional settings. This will be fixed in the next release.



For tracking purposes, the CR for this issue is 71219.