MS SQL Stored Procedures , Visual Studio 2005 , "Input values cannot be converted"

A few people in the DOT NET world have noticed that when stepping
through SQL stored procedures using Visual Studio 2005, when
debugging, an error can occur.
This bug occurs if you try to call a stored procedure that uses a BIT
type of Parameter.
The error message "Input values cannot be converted" occurs , as you
are debugging .
This can be cured if you change the Parameter type to TINYINT.

ALTER PROCEDURE [dbo].[usp_CashBookBulkProcess]
(
@InVRevID INTEGER,
@InVIsNewSplit BIT, -- THIS CAUSES ERROR IN VISUAL STUDIO 2005,
CHANGE IT TO A TINYINT)
@InVdtSettlement DATETIME,
@InVLFID INTEGER,
@InVLoanID INTEGER,
@InVStatus TINYINT output,
@OutVCallReturnMessage VARCHAR(250) output
)

as
....etc

It will work ok in Enterprise manager though, without any trouble.

I have posted this message only for reference by others who may
encounter the problem, as I could not find another posting on the
topic.
.

Relevant Pages

  • Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005
    ... access for the Visual Studio 2005, when working on ADO.NET (SQL Server ... Permissions are per logins and users. ... permissions can be granted through stored procedures, ...
    (comp.databases.ms-sqlserver)
  • RE: debugger doesnt stop at breakpoint while debugging SQLCLR functio
    ... It seems remote debugging component was not installed during Visual Studio ... I click Step into Function and I am able to debug the function step by step. ... Stored Procedure is in separate assembly which is created in SQL Server ...
    (microsoft.public.vsnet.debugging)
  • Unable to start debugging on the web server
    ... Are you running a version of Windows that allows the Visual Studio ... launch the application without debugging and manually attach to it. ... Debugging a Web server requires NTLM ... Internet, and NTLM authentication is not done over the Internet. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: no source code at current location
    ... > I'm having a problem with Visual Studio .Net. ... two built as static libraries and one as executable which links in ... All three projects are built using Debug configuration. ... It seems that the debugging information is corrupted ...
    (microsoft.public.vstudio.development)
  • Re: Visual Web Developer Express 2008 - Javascript Debugging - not
    ... If I install the full version of Visual Studio 2008, ... list of javascript debuggers? ... in order for VWD 2008's debugging to kick in. ...
    (microsoft.public.dotnet.framework.aspnet)