mibuso.com
Home› SQL General
Options

Getting Session Error

palanpalan Member Posts: 26
edited 2007-06-22 in SQL General
Hi,

I am getting session error when i try to login using navision 3.1 to sql 2000 database and the error message is as below:

The following SQL Server error(s) occurred while accessing the Session table:

8152,"22001",[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
3621,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.


Can some one help me with this issue. Thanks.

Comments

  • Options
    colin_leversuch-robertscolin_leversuch-roberts Member Posts: 113
    from a sql point of view this means you are trying to put data that is too big into a column. e.g. putting a string of 20 chars into a char(10) column. The error is a bit generic however and can also refer to date time data.
    how this relates to the navision error I couldn't say but this is what sql server is complaining about. You could try using profiler to capture the sql being sent.
Sign In or Register to comment.