I am trying to use Toad Data Point to connect to a SAS dataset source using an ODBC connection. When I use my most current version of 18.104.22.1684, the connection is made and I can see my libraries listed in the object explorer, and the datasets listed as the list of tables. The problem occurs when I open a dataset to browse, I get the following error:
Year, Month, and Day parameters describe an un-representable DateTime.
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at Quest.Toad.NativeOdbc.UnManagedColumnDescriptor.GetBufferDataAsOdbcDate(UInt16 rowOffset)
at Quest.Toad.NativeOdbc.OdbcDataReader.GetValue(Int32 i)
at Quest.Toad.Odbc.OdbcToadConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
I also tried using an older version of Toad for Data Analysts that I still had (22.214.171.124) and found that the ODBC connection to SAS worked just fine. I could open the dataset and browse with no errors.
My SAS driver version is 9.02.00.9225. Any ideas on something I can do to fix the error and be able to use newer Toad with SAS?