Probably the problem in that case is related with the default value for that field. Maybe have a look to see the current default value and if it is not set, better set it to 0. Even if this works you'll likely have other problems with the table structure.
You could go through your Access tables and look at the properties for each column, and manually make appropriate changes to the sql server db. You probably lost all column default values and maybe some indices when you upsized.
I canīt find anything wrong. Anyway i recognized that the read count is working for post which were already in the access file. The counting is only dead for new topics who were posted in the MSSQL Database. Is there a bug in an asp file?
This is normally always caused by the default values not being setup on the tables correctly as the others have said. Once your 100% certain each table column has the required defaults set you'll also then need to update the fields on posts created since your conversion to ensure the correct value is in each column. Your read count will not be incrementing becuase most likely the field contains "null" instead of a numeric value.
Well finally i checked out everything and canīt find any mistakes. Maybe someone have an idea what else can be wrong. Hereīs a Screenshot of the Forum Topic Settings on the SQL Server:
If you don't have Enterprise Manager available to you but do have .NET available somewhere then try installing this product it should let you set the default values
In fact you may even be able to use it straight from their website by putting in your database server name and logon details into the login box top left of their page, though YMMV it is a beta release too, make sure you've got that backup done first !!.
Topic Locked
Posted - 04 December 2003 : 13:55:39
