C# OleDb INSERT INTO overflow exception

Question

My query looks like this:

INSERT INTO tblFiles (filename,downloadname,description,length,parts,checksum) 
VALUES ('IMG_0228.JPG','file1','description1'
        ,2694310,1925,26931139928208758813621215525179134210220)

I am using an access database and my table looks like this:

This is the exception I get:

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll Additional information: Overflow

I do not understand what is causing this.

@lad2025 oh right because it exceeds the size of int. Solved, thanks! — Foxman, Jan 16 '16 at 15:17

score 2 · Accepted Answer · answered Jan 16 '16 at 15:20

2

The problem is with column datatype.

You tried to insert 26931139928208758813621215525179134210220 into number column which obviously generate overflow error.

You should change datatype of checksum column to string/binary.

answered Jan 16 '16 at 15:20

Lukasz Szozda

162,964
23
234
275

C# OleDb INSERT INTO overflow exception

1 Answers1