Error converting data type varchar to tinyint

[Elmo Watson]

I am having all kinds of problems with a Stored Proc I'm trying to run, with
the error I'm getting above.

First - the way I'm reading it - the database EXPECTS a TinyInt - and it
thinks I'm giving it a varchar input - right?

If that's so - there's only one field in the table that uses tinyInt - and
I've double checked:

cmd.Parameters. Add(New OleDbParameter( "@idMarketingRe pType",
OleDbType.TinyI nt))
cmd.Parameters( "@idMarketingRe pType").Value = intMktgType ' <-------this is
DEFINITELY an 8

With 7 insertable fields:
1 is a SmallInt
1 is a TinyInt
2 are varchars
3 are Bit fields (because of using a UDL for the conn string, I'm having to
use OleDB instead of the SQL client, so I'm using this format:

cmd.Parameters. Add(New OleDbParameter( "@Percent_Y n", OleDbType.BSTR) )
cmd.Parameters( "@Percent_Yn"). Value = intCommissionTy pe

Another question - since these values are bits (-1 or 0) - when I dim the
datatype for these - I've been using Integer
I assume that's ok here -

the whole parameter section is here:
cmd.Parameters. Add(New OleDbParameter( "@idEmploye e", OleDbType.Small Int))
cmd.Parameters( "@idEmployee"). Value =System.DBNull. Value ' I've tried
leaving this out completely since it's always null

cmd.Parameters. Add(New OleDbParameter( "@idMarketingRe pType",
OleDbType.TinyI nt))
cmd.Parameters( "@idMarketingRe pType").Value = intMktgType

cmd.Parameters. Add(New OleDbParameter( "@RepID", OleDbType.varch ar,10))
cmd.Parameters( "@RepID").V alue = txtRepID.text

cmd.Parameters. Add(New OleDbParameter( "@RepName", OleDbType.varch ar,42))
cmd.Parameters( "@RepName").Val ue = txtRepName.text

cmd.Parameters. Add(New OleDbParameter( "@Percent_Y n", OleDbType.BSTR) )
cmd.Parameters( "@Percent_Yn"). Value = intCommissionTy pe

cmd.Parameters. Add(New OleDbParameter( "@AutoRecalc_Yn ", OleDbType.BSTR) )
cmd.Parameters( "@AutoRecalc_Yn ").Value = System.DbNull.V alue ' I've
tried leaving this out completely since it's always null

cmd.Parameters. Add(New OleDbParameter( "@Active_Yn ", OleDbType.BSTR) )
cmd.Parameters( "@Active_Yn").V alue = intActive

I've verified all field inputs using Tracing - and if I use an inline sql
statement with hardcoded numbers, it works find.
Any ideas here, on what could be wrong?