Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 14 Oct 2010 @ 09:58:04 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Provider does not support conversion from VarChar to System.Boolean
From:   Asish Muralidas

Dear All,

Currently we are in the process of migrating SQL Server to Teradata. There is a front application built for creating report through SQL Server using the procedures.

We have migrated all procedures to Teradata.

Current issue is regarding to .Net Application, here we added .Net Source code to support Teradata using .Net Data Provider for Teradata version,so that same reports should access Teradata to generate it.

We are facing lots of issues around Boolean data type. SQL server supports Boolean but Teradata doesn t. The product has lots of Boolean and we are not in a position to change all the code. Is there a way to support Boolean data type? We are able to change the input parameter type but the TdDataReader.GetBoolean() method is giving error.

     Public override void load()
     {       .

     TdDataReader.GetBoolean(m_columns[ (int)enumColumn.IsDefault]) ; }

This is the function which will take output of Isdefault column, Output is of type varchar ,we tried changing that to integer as well as Byte. Whenever the output datatype is changing the error received is also keep changing to that datatype

Provider does not support conversion from Varchar to System. Boolean.

Provider does not support conversion from Byte to System. Boolean.

Provider does not support conversion from Integer to System. Boolean.

We need to know which data type resolves this TdDataReader.GetBoolean() issue. Please help.

Could any suggest which is the equivalent function we should use so that code should work for both SQL Server and Teradata databases.

Appreciate your prompt help on this


Asish Murali.M

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023