Toad World® Forums

Timestamp issue


#1

I have got an odbc connection linked to a postgres database.A table in that has got a column of timestamp.Every time i need to output the data of that column it gives an error and if i ignore that column i get the value overlapped into another column.Please help


#2

Hello, could you let us know what the error message is please?


#3

Our developer has also asked for a support bundle (use main menu item Help->Support Bundle) and a screenshot of the error message. You can e-mail it to me (my e-mail address can be found by clicking on my username) or attache the file to your post.


#4

The error was

System.FormatException
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.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Data.Odbc.OdbcDataReader.internalGetInt64(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValues(Object[] values)
at Quest.Toad.Db.Connection.ReadRow(IDataReader reader, FastTable datatable)
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()


#5

Thank you for the information. The developer tells me that the ODBC Provider in the .NET framework has quite a few bugs when working with lesser known databases.

We will be trying to remedy many of these bugs in version 2.0 of Toad for Data Analysis, and this issue should be fixed in that release.

Thank you for using Toad for Data Analysis.


#6

Thanx a lot.Around when can we expect the release of your 2.0 version?


#7

Current plans are for it to be available during the summer of 2008 (sometime around July).