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

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

Postby 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
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Postby Shalex » Tue 05 Apr 2011 16:22

We have reproduced the error. We will investigate the issue and post here about the results.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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.
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Postby 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 .
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect Universal