i get this error sometimes, my sessioni is tinyint as data type...

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'



[Microsoft][ODBC SQL Server Driver][SQL Server] Arithmetic overflow 

error for type tinyint, value =3D 256.



/includes/tools_clients_shop.inc, line 17

in the include file tools_clients_shop. inc( hereunder inserted)

<%



Sub OpenDatabase(ByRef dbConn)

	Set dbConn =3D Server.CreateObject("ADODB.Connection")

	dbConn.ConnectionTimeout =3D 15

	dbConn.CommandTimeout =3D 30

	dbConn.Open "DSN=3Dameel;UID=3D***;PWD=3D;DATABASE=3D****l"

End Sub



Function CheckLogin(ByVal SessionID, ByVal Level)

	OpenDatabase dbconn

	sqlcheck =3D "sp_checklogin_client '" & SessionID & "','" & 

UCase(Level) & "'"

	Set rs =3D dbconn.Execute(sqlcheck)(this is rule 17!!!)

 =09

******************

a stored procedure is executed towards the database..

some suggestions to find out where this error comes from?





Met Vriendelijke groet,

Eric Van Camp

Atmilestone BVBA

Trolieberg 74

3010 Kessel-lo

Tel:016/35.69.99

Fax:016/35.57.90

eric@a... <mailto:eric@a...>





 <http://www.atmilestone.be/>

I believe this error is caused when you attempt to put

a number into a variable type that is too small to

hold the value.  For example is you had a field in

your database that has been defined to hold only

"tinyint", then if you attempted to store a value in

that field that exceeded the maximum value of a

"tinyint" then you would get that error.  try changing

the field definition to "int".



--- Eric Van Camp <eric@a...> wrote:

> i get this error sometimes, my sessioni is tinyint

> as data type...

> Microsoft OLE DB Provider for ODBC Drivers error

> '80040e57' 

> 

> [Microsoft][ODBC SQL Server Driver][SQL Server]

> Arithmetic overflow error for type tinyint, value 

> 256. 

> 

> /includes/tools_clients_shop.inc, line 17 

> in the include file tools_clients_shop. inc(

> hereunder inserted)

> <%

> 

> Sub OpenDatabase(ByRef dbConn)

> 	Set dbConn 

> Server.CreateObject("ADODB.Connection")

> 	dbConn.ConnectionTimeout = 15

> 	dbConn.CommandTimeout = 30

> 	dbConn.Open "DSN=ameel;UID=***;PWD=;DATABASE=****l"

> End Sub

> 

> Function CheckLogin(ByVal SessionID, ByVal Level)

> 	OpenDatabase dbconn

> 	sqlcheck = "sp_checklogin_client '" & SessionID &

> "','" & UCase(Level) & "'"

> 	Set rs = dbconn.Execute(sqlcheck)(this is rule

> 17!!!)

>  	

> ******************

> a stored procedure is executed towards the

> database..

> some suggestions to find out where this error comes

> from?

> 

> 

> Met Vriendelijke groet,

> Eric Van Camp