exception:SqlDbType.NChar data type is not supported by dot

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
nickcole
Posts: 7
Joined: Sat 19 Mar 2011 01:03

exception:SqlDbType.NChar data type is not supported by dot

Post by nickcole » Fri 01 Apr 2011 11:50

when I use UniCommandBuilder.DeriveParameters(cmd) ,it throw exception:SqlDbType.NChar data type is not supported by dotConnect Universal
I think type convert wrong!

StoredProcedure:

Code: Select all

create PROCEDURE [dbo].[usp_InsertDept]
	@DEPTNO int,
	@DNAME varchar(14),
	@LOC nchar(13)
AS
INSERT INTO [dbo].[Dept] (
	[DEPTNO],
	[DNAME],
	[LOC]
) VALUES (
	@DEPTNO,
	@DNAME,
	@LOC
)
myCode:

Code: Select all

     Dim cn As New UniConnection("Provider=SQL Server;User Id=sa;Password=hhzstsll;Data Source=IBM008;Database=test;Type System Version=SQL Server 2005;")
        Dim cmd As UniCommand = New UniCommand("usp_InsertDept", cn)

        cn.Open()
        cmd.CommandType = CommandType.StoredProcedure
        UniCommandBuilder.DeriveParameters(cmd)

        Debug.Print(cmd.Parameters(3).UniDbType.ToString)


win xp sp3
vs2010
SQL Server 2005
Devart dotConnect Universal 3.20.44

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 05 Apr 2011 16:22

We have reproduced the error. We will investigate the issue and post here about the results.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 06 Apr 2011 16:20

We have fixed the bug with mapping SqlDbType.NChar to UniDbType. I will post here when the corresponding build of dotConnect Universal is available for dowload.

nickcole
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Post by nickcole » Thu 07 Apr 2011 13:18

thanks!
Shalex wrote:We have fixed the bug with mapping SqlDbType.NChar to UniDbType. I will post here when the corresponding build of dotConnect Universal is available for dowload.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 08 Apr 2011 07:44

New build of dotConnect Universal 3.20.46 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20712 .

Post Reply