[RESOLVED] error converting data type varchar to bit in MS SQL

[nvierros]

hey guys can someone please tell me what im doing wrong.

My sproc is something like this:

create proc dt_addnewcustomer
@CustIsInactive bit,
@CustFName varchar(100)
SET NOCOUNT ON
AS 
insert into tlbcustomers (CustFName, CustIsInactive) VALUES (@CustFname, @CustIsInactive)

go

my vbcode is like this:

dim CustIsInactive as boolean
CustIsInactive = false
Set adocommand = New ADODB.Command
With adocommand
.ActiveConnection = con
.CommandType = adCmdStoredProc
.CommandText = "dt_addnewcustomer"
.Parameters.Append .CreateParameter("@CustFName", adVarChar, adParamInput, 100, Trim(CustFName.Text))
.Parameters.Append .CreateParameter("@CustIsInactive", adboolean, adParamInput, 1, CustIsInactive)
.Execute , , adCmdStoredProc + adExecuteNoRecords
Set adocommand = Nothing
end with

I really dont see what im doing wrong, and it's driving me nuts!! Someone please help