CODEWITHSUNDEEP
c#sqldatabaseoledb
Foxman
Foxman

Reputation: 189

C# OleDb INSERT INTO overflow exception

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.

Upvotes: 1

Views: 1214

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175606

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.

Upvotes: 2

Related Questions