Inserting into Access Database from C# ASP.

[Zak Milas]

The field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data. Is the error I get when it get
dbCmd.ExecuteNo nQuery();. I have 15 fields to insert, therefore I did one
field at the time and found that the 13th field is the one causing the
problem, this field is in size 20 and data I am entering size is 1. I took
the INSERT command and entered it from Access Query and it worked, but not
from ASP page using C#. Please help I thank you for your assistance. I found
the similar error in
http://www.error-bank.com/microsoft....23_Thread.aspx. But there is no solutions posted.

[Herfried K. Wagner [MVP]]

"Zak Milas" <Za******@discu ssions.microsof t.com> schrieb:

inserting or pasting less data. Is the error I get when it get
dbCmd.ExecuteNo nQuery();. I have 15 fields to insert, therefore I did one
field at the time and found that the 13th field is the one causing the

Notice that there is a separate group for .NET+database questions available:

<URL:news://news.microsoft. com/microsoft.publi c.dotnet.framew ork.adonet>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[W.G. Ryan eMVP]

What does your update statement look like? Are you using Parameterized
query or dynamic SQL? You could have some illegal character if you're using
Dynamic SQL - that's the likely culprit.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Zak Milas" <Za******@discu ssions.microsof t.com> wrote in message
news:AB******** *************** ***********@mic rosoft.com...

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. Is the error I get when it get
dbCmd.ExecuteNo nQuery();. I have 15 fields to insert, therefore I did one
field at the time and found that the 13th field is the one causing the
problem, this field is in size 20 and data I am entering size is 1. I took
the INSERT command and entered it from Access Query and it worked, but not
from ASP page using C#. Please help I thank you for your assistance. I found the similar error in

http://www.error-bank.com/microsoft....23_Thread.aspx. But there is no solutions posted.

[Zak Milas]

I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",
OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access is
Yes/No field. And intOpenCall = 1.

"W.G. Ryan eMVP" wrote:

What does your update statement look like? Are you using Parameterized
query or dynamic SQL? You could have some illegal character if you're using
Dynamic SQL - that's the likely culprit.

--
W.G. Ryan, MVP

[Mike Labosh]

> >I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",

OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access is
Yes/No field. And intOpenCall = 1.

If "open_call" is Yes/No field shouldn't you be using OleDbType.Boole an?

Or possibly try setting it to -1. In Access, True = -1 and False = 0. If
the OP is thinking like a SQL Server BIT data type, he may be thinking 1 =
True, and Access will choke on that.
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

[Zak Milas]

I have tried the -1 and this time I am getiing the error message:
(0x80040e57): Overflow

"Mike Labosh" wrote:

I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",
OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access is
Yes/No field. And intOpenCall = 1.

If "open_call" is Yes/No field shouldn't you be using OleDbType.Boole an?

Or possibly try setting it to -1. In Access, True = -1 and False = 0. If
the OP is thinking like a SQL Server BIT data type, he may be thinking 1 =
True, and Access will choke on that.
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

[Greg Burns]

Why use an integer to begin with? Why not use True and False?

Greg

"Mike Labosh" <ml************ *@hotmail.com> wrote in message
news:uV******** ********@TK2MSF TNGP09.phx.gbl. ..

>I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",
> OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access is
> Yes/No field. And intOpenCall = 1.

If "open_call" is Yes/No field shouldn't you be using OleDbType.Boole an?

Or possibly try setting it to -1. In Access, True = -1 and False = 0. If
the OP is thinking like a SQL Server BIT data type, he may be thinking 1 =
True, and Access will choke on that.
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

[Zak Milas]

I have tried the true/false as well and I get similar error; (0x80040e57):
Overflow
"Greg Burns" wrote:

Why use an integer to begin with? Why not use True and False?

Greg

"Mike Labosh" <ml************ *@hotmail.com> wrote in message
news:uV******** ********@TK2MSF TNGP09.phx.gbl. ..

>I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",
> OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access is
> Yes/No field. And intOpenCall = 1.

If "open_call" is Yes/No field shouldn't you be using OleDbType.Boole an?

Or possibly try setting it to -1. In Access, True = -1 and False = 0. If
the OP is thinking like a SQL Server BIT data type, he may be thinking 1 =
True, and Access will choke on that.
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

[Greg Burns]

Post your code.

Remember OleDb parameters are referenced by POSITION not by name.

For example

INSERT INTO mytable (call_desc, open_call) VALUES (@call_desc, @open_call)

cmd.parameters. add("@open_call ", OleDbType.Boole an).value=bOpen Call
cmd.parameters. add("@call_desc ", OleDbType.varch ar,50).value=sD esc

This will fail.

Just my .02.

Greg
"Zak Milas" <Za******@discu ssions.microsof t.com> wrote in message
news:4C******** *************** ***********@mic rosoft.com...

I have tried the true/false as well and I get similar error; (0x80040e57):
Overflow
"Greg Burns" wrote:

Why use an integer to begin with? Why not use True and False?

Greg

"Mike Labosh" <ml************ *@hotmail.com> wrote in message
news:uV******** ********@TK2MSF TNGP09.phx.gbl. ..

>> >I am using Parameterized Query; dbCmd.Parameter s.Add("@open_ca ll",
>> > OleDbType.VarCh ar, 1).Value = intOpenCall; Where open_call in Access
>> > is
>> > Yes/No field. And intOpenCall = 1.
>
>> If "open_call" is Yes/No field shouldn't you be using
>> OleDbType.Boole an?
>
> Or possibly try setting it to -1. In Access, True = -1 and False = 0.
> If
> the OP is thinking like a SQL Server BIT data type, he may be thinking
> 1 =
> True, and Access will choke on that.
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD
>
> "Mr. McKittrick, after very careful consideration, I have
> come to the conclusion that this new system SUCKS!"
> ~~ General Barringer ~~
>
>

[Zak Milas]

You'll have been nothing but simply fabulous. Yes! the problem was
order/position of the OleDB Parameters. I trully appretiate for your input in
helping me. After two days of sweat, its finally done. Thank you from the
bottom of my heart.

"Greg Burns" wrote:

Post your code.

Remember OleDb parameters are referenced by POSITION not by name.

For example

INSERT INTO mytable (call_desc, open_call) VALUES (@call_desc, @open_call)

cmd.parameters. add("@open_call ", OleDbType.Boole an).value=bOpen Call
cmd.parameters. add("@call_desc ", OleDbType.varch ar,50).value=sD esc

This will fail.

Just my .02.

Greg