overflow error yet database field is adequate length

Posts   
 
    
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 23-Oct-2007 16:58:54   

version 1.0.2005.1 final (self-servicing) VS2005 asp.net 2.0


hiya,

In sql server management studio, I can enter 70 chars in the "registeredName" field.

Yet when I try the same via my web page (which uses llblGenPro) I get an overflow error:

 System.ArgumentOutOfRangeException: The value specified will cause an overflow error in the database. Value length: 86. Column max. length: 75
Parameter name: RegisteredName

Is this due to my llblGenPro DAL dll being out of synch? I ask because I had ensured that the:

1) schema had been refreshed 2) project regenerated 3) c# generated had been rebuilt in the solution

Somehow, it now works, but It'd be nice to know where the actual issue was.

cheers,

yogi

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 23-Oct-2007 19:03:59   

Seems to me that the catalog was out of sync of your db.

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 23-Oct-2007 19:41:23   

ok,

thanks.

yogi