UniDBType for SQL_Variant

Jonat3N1 · Post by **Jonat3N1** » Mon 07 Nov 2011 17:25

Is there a uniDBType for sql_variant for SQL Server 2005, 2008? We are trying to use unidbytype of object for the paramter in a command but when we do we get:

Devart.Data.Universal.UniException: UniDbType not supported by current data provider ---> System.NotSupportedException: UniDbType not supported by current data provider

the SQLDBType in Ado.Net for SQL Server is called Variant.

Pinturiccio · Post by **Pinturiccio** » Tue 08 Nov 2011 16:02

overtime wrote:Is there a uniDBType for sql_variant for SQL Server 2005, 2008?

There is no uniDBType for sql_variant for SQL Server 2005, 2008. We will consider the possibility to add this feature in future, but there is no time frame.

overtime wrote:We are trying to use unidbytype of object for the paramter in a command but when we do we get:

Devart.Data.Universal.UniException: UniDbType not supported by current data provider ---> System.NotSupportedException: UniDbType not supported by current data provider

UniDbType.Object cannot be used with the .NET Framework Data Provider for SQL Server. You can see all allowed UniDbType values for the .NET Framework Data Provider for SQL Server in our documentation http://www.devart.com/dotconnect/univer ... lient.html