SQL Assistant fails when Select on any table is executed.

Database

SQL Assistant fails when Select on any table is executed.

Hi

  I have got Teradata 14.00 installed recently. When I try to use the SQL Assistant the tool is failing with below error

SQLA Version: 14.1.0.2

Driver Version: ODBC 14.00.00.04

System.TypeLoadException: Could not load type 'System.DateTimeOffset' from assembly 'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

   at Teradata.SQLA.RunQry.LoadDataGrid(Object ci)

   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Threading.ThreadHelper.ThreadStart(Object obj)

*******************************************************

I have the .NET Data Provider installed to support 14.00.0.1

The .Net Framework 4 and MS Visual 2010.

I tried to contact the technical support guys who has no idea. Any suggestion or link to understand the problem is of great help.

1 REPLY

Re: SQL Assistant fails when Select on any table is executed.

posting the reply to the problem.

First of all sorry for not posting full information.

The .Netframe work that is installed was both 2.0 and 4.

So when I did a query the SQL assistant failed since the version that was considered to process Date or Time fields was using Version 2.0

I had read this in some other forum and got my .NetFrame work 2.0 uninstalled which solved the issue.

Hope this is useful for someone.