Home Forums SQL Server 2005 Administering Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query. RE: Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.

  • Actually our data access layer is a generic one and many other forms from the presentation layer is using the same data access layer.So different forms will have different parameters in the insert function.Because of this we cannot directly give the parameters and its type. That is why we are using Hybrid dictionary to set the parameters, as the count of parameters will be unknown in the datalayer.

    You have mentioned about adding the type to the hybridDictionary. Can you please help us to do that....

    do you have any sample with you

    it is very urgent....please help 🙂